Lead Snowflake Engineer

Anblicks; Ahmedabad District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Anblicks in India seeks an experienced Snowflake Developer to design and optimize data pipelines using Snowflake, DBT, and Airflow, supporting data warehouse modernization and legacy-to-Snowflake migrations. You will build ELT workflows, develop DBT models and tests, manage Airflow DAGs, and collaborate with stakeholders to meet data requirements while ensuring data quality and governance.

7+ years in data engineering with strong Snowflake expertise and SQL skills are expected; familiarity with

Qualifications

• 7+ years of experience in Data Engineering and Data Warehousing.
• Strong hands-on Snowflake experience with DBT and Airflow.
• Proficient SQL development and query optimization.
• Understanding of DW concepts and ELT frameworks.
• Experience with Git-based version control and collaboration.

Responsibilities

• Design, develop, and maintain data pipelines with Snowflake, DBT, and Airflow.
• Build and optimize ELT workflows for large-scale data processing.
• Develop DBT models, tests, and documentation.
• Create and manage Airflow DAGs for orchestration, scheduling, monitoring.
• Design Snowflake databases, schemas, tables, views, streams, tasks, and procedures.
• Optimize Snowflake performance via query tuning and best practices.
• Collaborate with stakeholders to implement data requirements.
• Implement data quality, validation, and governance.
• Participate in data warehouse modernization and migration initiatives.
• Troubleshoot and resolve data pipeline issues.

Skills

Snowflake

DBT

Airflow

SQL

ELT

Data warehousing

Git

Data modeling

Data governance

Communication

Tools

Git

Job description

Job Summary

Seeking an experienced Snowflake Developer with strong expertise in Snowflake, DBT, and Airflow. The candidate will be responsible for building and optimizing data pipelines, implementing data transformation frameworks, and supporting data warehouse modernization initiatives. Experience with legacy-to-Snowflake migration projects is preferred.

Key Responsibilities

• Design, develop, and maintain data pipelines using Snowflake, DBT, and Airflow.
• Build and optimize ELT workflows for large-scale data processing.
• Develop DBT models, tests, and documentation following best practices.
• Create and manage Airflow DAGs for workflow orchestration, scheduling, and monitoring.
• Design and maintain Snowflake databases, schemas, tables, views, streams, tasks, and stored procedures.
• Optimize Snowflake performance through query tuning and best practices.
• Collaborate with business stakeholders and technical teams to understand and implement data requirements.
• Implement data quality, validation, and governance processes.
• Participate in data warehouse modernization and migration initiatives.
• Troubleshoot and resolve issues related to data pipelines and Snowflake environments.

Required Skills

• 7+ years of experience in Data Engineering and Data Warehousing.
• Strong hands-on experience with Snowflake.
• Expertise in DBT for data transformation and modeling.
• Experience with Apache Airflow for workflow orchestration and scheduling.
• Strong SQL development and query optimization skills.
• Solid understanding of data warehousing concepts, dimensional modeling, and ELT frameworks.
• Experience with Git-based version control.
• Strong analytical, problem-solving, and communication skills.

Preferred Skills

• Experience in legacy-to-Snowflake migration projects.
• Exposure to reporting and analytics solutions consuming data from Snowflake.
• Experience working in Agile development environments.