Lead ETL Engineer & Data Modeller

Dicetek LLC; Dubai; On-site; AED 300,000 - 520,000; Full time

Job summary

Dicetek LLC is seeking an experienced Lead ETL Engineer & Data Modeller to lead data integration, ETL/ELT, and data modelling initiatives for a banking client. The role focuses on building scalable data pipelines, audit/reconciliation frameworks, and data structures supporting transaction processing, monitoring, and regulatory requirements.

The candidate will work closely with Solution Architects, Data Architects, and business stakeholders to design robust data solutions, optimize Snowflake

Qualifications

• 8+ years in ETL development, data engineering, and data modelling, banking/financial services preferred.
• Strong Snowflake and Informatica expertise.
• Proven experience in ETL/ELT architecture, data integration patterns, and enterprise data modelling.
• Experience with data lineage, metadata, data governance, and security in banking environments.

Responsibilities

• Lead design and development of ETL/ELT pipelines for large-scale banking data integration.
• Design data structures and tables for audit logs, error queues, and status history.
• Develop data quality, reconciliation, and auditability frameworks.
• Create scalable data models to support operational and analytical needs.
• Optimize ETL workflows and Snowflake workloads for performance and cost.
• Define standards for ETL development, testing, deployment, and documentation.
• Mentor ETL developers and coordinate with stakeholders.

Skills

Snowflake

Informatica

ETL Architecture

SQL

Data Modelling

Data Governance

Cloud Platforms

Data Quality

Regulatory Compliance

Git

CI/CD

DevOps

Tools

Git

CI/CD

DevOps

Job description

We are seeking an experienced

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.