AI-Ready Snowflake Data Engineer

Lunate; Abu Dhabi; On-site; AED 300,000 - 600,000; Full time

Job summary

Lunate in Abu Dhabi is seeking a Senior Data Engineer to lead the design and implementation of scalable data pipelines powering BI and AI workloads. You will own ingestion to Snowflake, collaborate with Head of Data & AI, and work with Infrastructure to establish a modern data-as-code practice.

The role emphasizes data modeling, quality checks, CI/CD, and cost-conscious Snowflake usage, with partnerships across investment, operations, and finance to deliver robust data products.

Qualifications

• 6+ years of professional data engineering experience delivering production pipelines.
• Strong experience with Snowflake’s full suite of products, especially core functionality.
• Hands-on experience with dbt, including testing and environment management.
• Familiarity with modern ingestion tools such as Fivetran.
• Strong grounding in data modelling fundamentals (Kimball and relational).
• Python-native, production-quality pipeline code with Git-based version control.
• Strong software engineering discipline (Git, CI/CD, automated testing).
• Experience building replayable, idempotent pipelines with backfill support.
• Financial services experience preferred, with understanding of audit and as-of data concepts.

Responsibilities

• Build and own ingestion pipelines into Snowflake using modern ELT patterns.
• Leverage AI tools to design and automate pipelines.
• Implement a layered data architecture (raw, standardised, business) that preserves immutability and governance.
• Develop transformations as version-controlled code (SQL and Python) using dbt or equivalent tooling.
• Apply pragmatic data modelling practices, using Kimball or relational approaches.
• Build data quality and reconciliation into pipelines with automated checks.
• Operate pipelines like software: CI/CD, automated testing, peer review, and controlled promotion.
• Optimise Snowflake usage for performance and cost with governance controls.
• Partner with BI practitioners and AI engineers to deliver AI-ready datasets.
• Collaborate with investment, operations, and finance teams to translate requirements into robust data products.
• Contribute to engineering standards, patterns, and documentation as the data function scales.

Skills

Snowflake

dbt

Python

ELT pipelines

Fivetran

data modeling (Kimball)

Git & CI/CD

SQL

ETL orchestration

Tools

Airflow

Job description

Lunate in Abu Dhabi is seeking a Senior Data Engineer to lead the design and implementation of scalable data pipelines powering BI and AI workloads. You will own ingestion to Snowflake, collaborate with Head of Data & AI, and work with Infrastructure to establish a modern data-as-code practice.

The role emphasizes data modeling, quality checks, CI/CD, and cost-conscious Snowflake usage, with partnerships across investment, operations, and finance to deliver robust data products.