ENTERPRISE DATA WAREHOUSE ARCHITECT at Commercial International Bank (Egypt)

Giza, Giza, Egypt -

Full Time

Start Date

Immediate

Expiry Date

08 Aug, 26

Salary

0.0

Posted On

10 May, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Warehouse Architecture, Data Modeling, ETL Processes, Microsoft SQL Server, Oracle, Data Governance, Metadata Management, Data Quality Management, Analytical Thinking, Leadership, Communication, Problem Solving, Decision Making, Stakeholder Management, Database Performance Tuning, Data Mining

Industry

Banking

Description

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 10. 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 11. Follow the day-to-day operations related to own jobs in the IT Architecture & Strategy department to ensure continuity of work. Compliance 12. 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 Qualifications & Experience • Bachelor's degree in Engineering, Computer Science, Mathematics, Statistics or related field. • 15+ years of experience with at least 10 years of Data warehouse architecture/management/design. • Track record of managing the architecture of multiple change projects/programs in a complex environment • Strong knowledge of database structure systems and data mining • Highly results driven, with the energy and determination to succeed in a very fast paced environment where the pace and quality of response is critical to success • Motivated self-starter who can work autonomously and add value in a team • Excellent interpersonal, organization and time management skills • Must be cooperative, flexible and able to work well with others • Expertise in Microsoft SQL Server and Oracle • Hands on experience in the Insurance sector or Financial Services is preferred • Excellent organizational and analytical skills Skills • Very Good in English, reading, writing and speaking. • Ability to effectively communicate, both verbally and in writing. • Analytical thinker Strong knowledge of Data Architectures found in banking sector • Very good Leadership skills • Very good Communication skills • Analytic thinking, problem solving and decision making

Responsibilities

The architect is responsible for designing and optimizing the enterprise data warehouse, including physical and logical data models and metadata for ETL processes. They must align data strategies with business goals and ensure adherence to data governance and technology standards.