Snowflake Architect – ADF-to-Snowflake Migration, Data Modeling & ELT/ETL

Overview

Snowflake Architect to lead enterprise-scale data platform modernization and migration from Azure Data Factory (ADF) to Snowflake, re-engineering ELT/ETL into Snowflake-native pipelines.

What you'll do

• Lead migration of pipelines and workloads from Azure Data Factory to Snowflake.
• Re-engineer ADF-based ELT/ETL logic into Snowflake-native pipelines using Snowpipe, Streams & Tasks, dbt, or comparable approaches.
• Define Snowflake architecture strategies, target-state designs, technical standards, and implementation roadmaps.
• Design scalable, secure, reliable, and cost-efficient Snowflake data platforms and apply Snowflake capabilities (e.g., Time Travel, Zero-Copy Cloning, Secure Data Sharing, warehouse cost management).
• Design and govern dimensional models, data vault structures, data warehouses, and data marts.
• Develop and review complex SQL for transformation, validation, reconciliation, and performance optimization.
• Use Python or another scripting language to automate pipeline orchestration, validation, monitoring, deployment, and operational processes.

What you'll need

• 10–13 years of overall experience in data engineering, data architecture, or related roles.
• At least 4–5 years of hands-on Snowflake architecture and administration experience.
• Proven hands-on experience migrating pipelines/workloads from Azure Data Factory (ADF) to Snowflake.
• Experience re-engineering ADF-based ELT/ETL into Snowflake-native pipelines using Snowpipe, Streams & Tasks, and/or dbt.
• Strong SQL skills for data transformation, analysis, optimization, and troubleshooting.
• Hands-on experience with at least one ELT/ETL tool (Informatica, dbt, Matillion, Talend, or ADF).
• Working knowledge of at least one cloud platform: AWS, Azure, or GCP.

Details

• Location: Mumbai.