Lead ETL Engineer & Data Modeller

Job Overview

We are seeking an experienced Lead ETL Engineer & Data Modeller to design and lead data integration, ETL, and data modelling initiatives for a banking client. The role will focus on building robust and scalable data pipelines, audit and reconciliation frameworks, and data structures supporting transaction/message processing, monitoring, and regulatory requirements.

Key Responsibilities

• Lead the design and development of ETL/ELT pipelines for large-scale banking data integration requirements.
• Design and implement data structures and tables for message tracking, audit logs, error queues, status history, and corrected/validated values.
• Develop robust audit, reconciliation, exception-handling, and data quality frameworks.
• Design scalable data models to support operational, analytical, reporting, and regulatory requirements.
• Develop and optimize ETL workflows using Informatica and Snowflake.
• Ensure accurate and traceable movement of data across source, staging, transformation, and target systems.
• Implement mechanisms for data validation, error handling, data lineage, reconciliation, and auditability.
• Work closely with Solution Architects, Data Architects, application teams, business stakeholders, and infrastructure teams to define integration requirements.
• Optimize ETL processes and Snowflake workloads for performance, scalability, reliability, and cost efficiency.
• Establish standards and best practices for ETL development, data modelling, coding, testing, deployment, and documentation.
• Lead technical design reviews and provide guidance to ETL developers and data engineers.
• Ensure solutions comply with the bank’s data governance, security, privacy, and regulatory requirements.
• Troubleshoot complex data and integration issues and provide root-cause analysis and remediation.

Required Skills & Experience

• 8+ years of experience in ETL development, data engineering, and data modelling, with experience in a banking or financial services environment preferred.
• Strong hands-on expertise in Snowflake and Informatica.
• Strong understanding of ETL/ELT architecture, data integration patterns, and enterprise data modelling.
• Proven experience designing audit trails, reconciliation frameworks, error handling, exception management, and data quality controls.
• Strong SQL skills and experience working with large-scale datasets.
• Experience with relational databases, data warehouses, and cloud-based data platforms.
• Good understanding of data lineage, metadata, data governance, and master/reference data concepts.
• Experience working with high-volume, mission-critical data integration environments.
• Strong understanding of data security, access controls, encryption, and regulatory compliance within banking environments.

Preferred

• Experience with UAE banking clients and CBUAE regulatory requirements.
• Exposure to banking transactions, payments, financial messaging, or reconciliation systems.
• Experience with cloud platforms such as AWS or Azure.
• Familiarity with CI/CD, DevOps, Git, and automated ETL deployment practices.
• Experience leading ETL/data engineering teams and coordinating with multiple technology and business stakeholders.

Key Competencies

• Strong analytical and problem-solving skills.
• Excellent understanding of data architecture and integration design.
• Strong leadership and stakeholder management capabilities.
• Attention to detail with a strong focus on data accuracy, traceability, and auditability.
• Ability to work effectively in a high-volume, regulated banking environment.

Skills: ETL development , Snowflake , Informatica