Snowflake Technical Lead

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 strong 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

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., Data Stage) 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