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