DATA ENGINEER
Commercial International Bank Egypt DATA ENGINEER
Job Purpose\:
To develop and implement needed solutions and adhere to planned projects to enrich the Big data & Data warehouse layers with required data across the organization and ensure proper storage of data assets; also ensure the proper delivery of required data elements for either reporting or application needs.
Job Description\:
Data Modelling
1. Assist the DWH & Big Data teams to develop & deliver the proposed Data Architecture
2. Support in creating logical & physical data model for the required data structures using client's modelling standards and standard ERWin modelling tools.
3. Execute the process of data mapping between source systems and EDW and from EDW to different integrated systems.
Data Transformation(ETL)
4. Implement different data integration & ETL workflows and jobs between data sources and Enterprise Data Warehouse (EDW) and from EDW to different integrated systems
Data Consumption
5. Develop different application data needs from EDW
6. Implement the best approaches to use for applications data integration with EDW
Data Development
7. Put Hadoop and big data technology stack in work and development of the needed data applications for better data development.
8. Implement data integration and distribution across Hadoop nodes
9. Apply best data movements’ techniques from and to Hadoop.
Controls
10. adhere to the guiding principles of data warehousing & Big Data.
11. Develop a feedback loop with data science and EPM/ERM team to constantly enhance data structure.
Day-to-day operations
12. Follow the day-to-day operations related to own jobs in the department to ensure continuity of work
Policies, Processes and Procedures
13. Follow all relevant department policies, processes, standard operating procedures and instructions so that work is carried out in a controlled and consistent manner.
Compliance
14. 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