Snowflake Technical Lead

Experience: 3 to 4 years

Location: Gautam Buddha Nagar, India

Skills: DBT, Snowflake, data warehousing, ELT frameworks, Snowflake performance optimization, SQL, data quality checks, testing frameworks, CI/CD, data governance, data security, DBT models, DBT macros, DBT snapshots

Job Summary
We are seeking an experienced Senior Developer specializing in DBT (Data Build Tool) and Snowflake to design, develop, and optimize scalable data transformation pipelines on a modern cloud data platform. The ideal candidate will have solid expertise in data warehousing, ELT frameworks, and Snowflake performance optimization, along with the ability to independently own end-to-end data pipeline and migration initiatives.

Key Responsibilities
Design, develop, and maintain scalable ELT pipelines using DBT on Snowflake
Build modular, reusable, and well-documented DBT models following best practices
Optimize Snowflake workloads for performance, cost, and scalability
Translate complex business requirements into efficient data models and transformations
Perform end-to-end migration of legacy ETL jobs (e.g., DataStage) to DBT/Snowflake
Analyze existing ETL pipelines and redesign them using modern ELT architecture patterns




Implement data quality checks, testing frameworks, and CI/CD pipelines using DBT
Monitor, troubleshoot, and improve pipeline reliability and performance
Collaborate with data architects, analysts, and business stakeholders to deliver high-quality data solutions
Ensure adherence to data governance, security, and best engineering practices

Skill Requirements
Mandatory Skills & Experience
6+ years of experience in data engineering / ETL development
Minimum 3–4 years of hands-on experience with DBT on Snowflake
Strong expertise in:
Snowflake architecture, performance tuning, and query optimization
DBT models, macros, snapshots, and testing frameworks
SQL (advanced level)
Solid understanding of:
Data warehousing concepts
ELT vs ETL frameworks
Dimensional data modeling
Experience in end-to-end development and deployment of data pipelines
Ability to independently deliver and own complete modules/migrations

Other Requirements
Nice to Have
DBT certification or Snowflake certification
Experience in healthcare or enterprise data platforms
Exposure to data governance and compliance frameworks

📌 Snowflake Technical Lead (Noida)
🏢 HCL Technologies
📍 Noida