KEY RESPONSIBILITIES

• Collaborate with other Technology staff to ensure smooth and reliable operation of software and systems for fulfilling business objectives and processes.
• Implement and adhere to regular systems maintenance policies and procedures, including change request mechanisms and update schedules to ensure optimum uptime and service availability.
• Participate in system acquisition process; propose and create system design models, specifications, diagrams, charts and implementation roadmaps to provide strategic direction to the business.
• Administer the assigned Systems at Application level and connected databases, define and optimize database structures, content and processing flows through appropriate Data Definition, Data Manipulation and Data Control Languages.
• Perform recovery and testing of systems and processes in accordance with the bank’s disaster recovery and business continuity strategies.
• Create and maintain documentation as it relates to system configuration, mapping, and processes.
• Create and maintain best practice policies and procedures for business users; ensuring that there are adequate controls around that all data improvements are managed effectively and meet the needs of the organization.
• Responsible for designing and implementing ETL architecture to meet corporate data management needs and business functional requirements, ensuring that solution designs address operational requirements such as scalability, maintainability, extensibility, flexibility, and integrity.
• Recognize and adopt best practices in reporting, analysis, ETL data integrity, test automation, data quality validation and documentation.
• Support, develop and maintain ETL and data warehouse objects and processes in a large Data warehouse of Terabyte scale.

DAILY RESPONSIBILITIES

• Design and implement efficient data management systems
• Develop, maintain, and test infrastructures for data generation and storage into an enterprise data warehouse.
• Ensure digital databases and archives are protected from security breaches and data losses.
• Troubleshoot data-related problems and authorize maintenance or modifications during ETL process.
• Maintain the integrity and validity of data throughout the ETL processing cycle by implementing data reconciliation processes and error handling based on source to target data comparisons.