Data Engineer - Azure Data Factory & Snowflake

As a Data Engineer - Azure Data Factory (ADF) & Snowflake, you will make an impact by designing, building, and supporting cloud data pipelines that ingest data from multiple source systems into Snowflake using Azure Data Factory. This role covers end-to-end delivery, from source analysis and data modeling through pipeline development, performance tuning, and production support. You will be a valued member of the Data Engineering team and work collaboratively with data architects, BI teams, and business stakeholders.

• Build and orchestrate ingestion and transformation pipelines in Azure Data Factory using mapping and data flows, linked services, datasets, triggers, and parameterized, metadata-driven frameworks.

• Develop and optimize Snowflake objects including databases, schemas, tables, views, streams, tasks, stored procedures, and Snowpipe-based loads.

• Write complex SQL for transformation logic, implement SCD Type 1 and Type 2 patterns, and tune warehouse sizing, clustering, and query performance for cost efficiency.

• Integrate ADF with Azure Data Lake Storage Gen2, Azure SQL, Key Vault, Logic Apps, and Databricks or Synapse where required.

• Implement CI/CD for ADF and Snowflake through Azure DevOps or GitHub, along with monitoring, alerting, and data quality and reconciliation checks.