ENTERPRISE DATA WAREHOUSE ARCHITECT

JOB PURPOSE

Planning, connecting, designing & optimizing data management activities and understanding of industry best practices for Data warehouse, Key Data elements, Data Quality Management, Metadata, and Enterprise Data Management Policy, Process, and Procedures.

Description

Enterprise Data Warehouse Architect

1. Prepare design for all metadata according to various ETL processes.

2. Develop both physical and logical data models.

3. Prepare designs for database systems and recommend improvements for performance.

4. Engage with Business Stakeholders to ensure that CIB Data Warehouse Strategies are developed in alignment with business outcomes and corporate goals and strategies.

5. Promote and guide CIB Data Warehouse team to the principles and contents of Technology Strategies to ensure their correct implementation and adherence.

6. Provide support throughout project life cycles, including during the delivery and implementation of solutions, ensuring patterns and development standards are understood and adhered to.

7. Ensure that Data governance standards are fully adhered to, with oversight of data modelling work.

8. Support warehouse development to optimise performance.

9. Work closely with Stakeholders and Business Analysts to analyse and translate business requirements into practical technical requirements and appropriate solutions.

Policies, Processes and Procedures

1. Follow all relevant department policies, processes, standard operating procedures and instructions so that work is carried out in a controlled and consistent manner.

Day-to-day operations

1. Follow the day-to-day operations related to own jobs in the IT Architecture & Strategy department to ensure continuity of work.

Compliance

1. Comply with all relevant CBE regulations, banking laws, AML regulations and internal CIB policies and code of conduct in order to maintain CIB's sound legal position and mitigate any potential risks