Lead ETL Engineer & Data Modeller

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. Desired Candidate Profile 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 Employment Type Full-time

Keywords