What are the responsibilities and job description for the Snowflake Developer with ADF position at Ryantech?
Job Details
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.
-
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.
-
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.
-
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.
-
10-12 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.
-
Experience with dbt, Airflow, or other orchestration tools.
-
Knowledge of cloud cost optimization and performance governance.
-
Exposure to Power BI or other visualization tools.