Key Responsibilities:
- Ensure 24/7 System availability by collaborating with other Technology staff to ensure smooth and reliable operation of systems for fulfilling business objectives and processes across KCB
- Coordinate extraction, transformation, loading and generation of data from Core Banking and other channels in and out of Data warehouse to facilitate end user consumption.
- Support, develop and maintain ETL and data warehouse objects and processes in a large Data warehouse of Terabyte scale
- Support teams across with data related items
- Work with vendors to resolve any arising system issues that affect the reporting ecosystem.
- Recommend establishment of new or modified reporting methods and procedures to improve report content and completeness of information
- Participate in 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.
The Person
For the above position, the successful applicant should have the following:
- Bachelor’s degree in computer science, Data Science, Information Technology, Engineering, Mathematics or an equivalent combination of education and experience is required.
- Professional Qualifications: System Administration/Cloud Platform Data management/SQL is a requirement
- Master’s degree will be an added advantage
- 5 years of Relevant Experience is Required as well as the following:
- 4 years’ experience in Data Warehousing (On Premise or cloud)
- 3 years’ experience in use of any ETL tool e.g., Oracle ODI/Microsoft SSIS/SAP Data services/Alteryx or any other tool
- 3 years’ experience in SQL (Oracle PL/SQL)
- 3 years’ experience in System Administration
- 2 years’ experience in Data Visualization e.g. OBIEE/Power BI/Tableau/SAP BI tools
- 2 years’ experience in Data Governance/Data Quality
- 2 years’ experience in Cloud Data Management
- 2 years’ experience in Programming (Python and(or) R) will be an added advantage
