Data Engineer - Azure Data Factory & Snowflake

Please note, this role is not able to offer visa transfer or sponsorship now or in the future. About the role

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.

In this role, you will

• 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.

Work model

We strive to provide flexibility wherever possible. Based on this role's business requirements, this is a remote position open to qualified applicants in the United States. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we wi