Snowflake Developer with ADF

Snowflake Developer (ADF, Databricks, SQL, Python)
Metropark,NJ (Hybrid)

Must go Face to face interview at NYC office Role Overview

We are seeking an experienced Snowflake Developer with strong expertise in Azure Data Factory (ADF), Databricks, SQL, and Python to design, build, and optimize scalable data pipelines and cloud-based data solutions. The ideal candidate will work closely with cross-functional teams to deliver high-quality, high-performance data systems that support analytics, reporting, and business intelligence needs.

Key Responsibilities Snowflake Development

• Design and develop scalable data models, schemas, and pipelines in Snowflake.

• Implement Snowflake features such as Virtual Warehouses, Snowpipe, Streams, Tasks, and Time Travel.

• Optimize Snowflake queries, storage, and compute usage for cost efficiency and performance.

• Develop stored procedures, UDFs, and SQL scripts for data transformation.

Azure Data Factory (ADF)

• Build, schedule, and monitor ETL/ELT pipelines using ADF.

• Configure linked services, datasets, triggers, and integration runtimes for automated workflows.

• Integrate ADF with Snowflake, Azure Data Lake, and Databricks.

Databricks

• Develop and maintain data transformation notebooks using SQL & Python.

• Optimize spark jobs for performance and reliability.

• Build reusable modules and frameworks for big-data processing.

SQL & Python Development

• Write advanced SQL queries for profiling, validation, and data transformations.

• Develop Python scripts/notebooks for automation, data cleansing, and analytics.

• Perform root-cause analysis of data issues and implement fixes.

Required Skills

• 14 years of experience in data engineering or cloud data development.

• Strong hands-on experience in Snowflake (mandatory).

• Proficiency with ADF pipelines, data flows, integration runtime setups.

• Experience with Databricks (SQL & Python notebooks, Delta Lake processing).

• Strong in SQL performance tuning and optimization.

• Python experience in ETL, data manipulation, and automation.

• Knowledge of Azure services (ADLS Gen2, Key Vault, Azure Functions) preferred.

• Strong understanding of CI/CD and Git-based development.

Nice-to-Have

• Experience with dbt, Airflow, or other orchestration tools.

• Knowledge of cloud cost optimization and performance governance.

• Exposure to Power BI or other visualization tools.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.