Data Engineering Lead

About the role

We are seeking an experienced Data Engineering Lead to support a high-priority data integration and cloud enablement initiative. The primary focus of this role is designing and executing end-to-end ELT pipelines and data transfer workflows—migrating structured data from SQL sources into Snowflake and orchestrating bulk file transfers into Azure Data Lake Storage (ADLS).

What you'll do

• Design, build, and maintain scalable ELT/ETL pipelines and data workflows for ingestion and transformation
• Execute structured data extraction, movement, and landing from relational SQL databases directly into Snowflake staging and core layers
• Build, execute, and monitor file movement tasks to efficiently transfer flat files, logs, or unstructured formats into Azure Data Lake Storage (ADLS)
• Write and tune high-performance SQL queries for data modeling, validation, data verification, and staging transformations
• Conduct data reconciliation and completeness checks to ensure zero loss across data pipelines during bulk migration

What you need

• SQL
• ETL
• Snowflake
• Azure
• Data modelling
• Reconciliation
• Any graduate

Good to have

• Python
• Azure Data Factory
• Airflow
• dbt
• SAP
• Git