Snowflake Data Engineer – Lead

Taggd

Mumbai

Hybrid

INR 3,500,000 - 6,000,000

Full time

34 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Saint-Gobain in Mumbai is hiring a Lead Data Engineer to own architecture and delivery of enterprise-grade data solutions on Snowflake and DBT. This is a hands-on leadership role overseeing the DBT transformation layer and setting engineering standards through code reviews, while collaborating with analysts, product, and business stakeholders.

The role requires 5–12 years of experience, hybrid work, and a focus on ELT pipelines, performance tuning, and scalable architectures.

Qualifications

  • Expert Snowflake: Streams, Tasks, Snowpipe and performance tuning.
  • Hands-on DBT (mandatory).
  • Advanced SQL and physical data modelling.
  • Building ELT pipelines at scale.
  • Orchestration with ADF or Airflow, with Azure DevOps or GitHub

Responsibilities

  • Design and build scalable ELT pipelines and data warehouses.
  • Engineer Snowflake platform: schemas, stages, Streams and Tasks.
  • Implement Snowflake security and governance: RBAC, masking policies, Time Travel and cloning.
  • Own the DBT transformation layer: staging, intermediate and mart models, incremental models, SCD Type 1 and Type 2, snapshots, testing, source freshness, documentation and CI/CD.
  • Orchestrate workflows with Airflow or Azure Data Factory and integrate data from APIs, databases and cloud storage (ADLS).
  • Drive engineering best practices and code reviews with analysts, product and business stakeholders

Skills

Snowflake
DBT
Advanced SQL
Physical data modelling
ELT pipelines
Airflow
Azure DevOps
GitHub

Education

Bachelor's Degree in CS/IS

Tools

Airflow
Azure DevOps
GitHub

Job description

Snowflake Data Engineer – Lead | Data Engineering |Mumbai

The values below are the definitive persona parameters for this role. Where any other section of this document appears to suggest a different value, this table takes precedence.

Job Title: Snowflake Data Engineer – Lead

Industry : IT Services & Consulting; Data & Analytics

Location Relocation: No

Preferred Mode of Work: Hybrid

Min Experience: 5 years

Max Experience : 12 years

Notice Period: 0-30 days

Must Have Skills

Expert Snowflake (Streams, Tasks, Snowpipe, performance tuning); DBT (hands-on, mandatory); Advanced SQL and physical data modelling; ELT pipelines at scale; Orchestration with ADF or Airflow plus Azure DevOps or GitHub

Good To Have Skills

Streamlit; Kafka or streaming pipelines; CI/CD with Azure DevOps or GitHub Actions; Collibra or Informatica MDM; Legacy data warehouse or data lake migration to Snowflake; Team mentoring and code reviews

Qualification

Bachelors Degree in Computer Science, Information Systems or a related field

Certification

Not required (SnowPro Advanced preferred)

2. Position Summary

Saint-Gobain is hiring a Lead Data Engineer for its data engineering team in Mumbai. The role owns the architecture and delivery of enterprise-grade data solutions on Snowflake and DBT.

This is a hands-on leadership role: the job holder designs and builds the platform, owns the DBT transformation layer, sets engineering standards through code reviews, and works directly with analysts, product and business stakeholders.

3. Must Have Skills
  • Expert-level Snowflake: Streams, Tasks, Snowpipe and performance tuning
  • Hands-on DBT (mandatory)
  • Advanced SQL and physical data modelling
  • Building ELT pipelines at scale
  • Orchestration with ADF or Airflow, with Azure DevOps or GitHub
4. Good To Have Skills
  • Streamlit on Snowflake
  • Kafka or streaming pipelines
  • CI/CD with Azure DevOps or GitHub Actions
  • Migration from a legacy data warehouse or data lake to Snowflake
  • Mentoring engineers and leading code reviews
5. Roles and Responsibilities
  • Design and build scalable ELT pipelines and enterprise data warehouses (star and snowflake schema), covering ingestion, DBT transformation and serving layers.
  • Engineer the Snowflake platform: schemas, stages, Streams and Tasks for CDC, Snowpipe, warehouse sizing, clustering and performance optimisation.
  • Implement Snowflake security and governance: RBAC, masking policies, Time Travel and cloning.
  • Own the DBT transformation layer: staging, intermediate and mart models, incremental models, SCD Type 1 and Type 2, snapshots, testing, source freshness, documentation and CI/CD.
  • Orchestrate workflows with Airflow or Azure Data Factory and integrate data from APIs, databases and cloud storage (ADLS), with monitoring, alerting and error recovery.
  • Drive engineering best practices and code reviews, and work with analysts, product and business stakeholders.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Snowflake Data Engineer
Snowflake Data Engineer

Genpact Ltd. • Hyderabad, Bengaluru, Delhi

On-site
INR 3,500,000 - 7,000,000
Snowflake Data Engineer
Snowflake Data Engineer

PALNI • Hyderabad

On-site
INR 900,000 - 1,500,000
Snowflake + DBT - Data Engineer
Snowflake + DBT - Data Engineer

Tiger Analytics • Hyderabad, Chennai, Bengaluru

Hybrid
INR 1,500,000 - 2,300,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

VMC Soft Technologies • Bengaluru Urban

On-site
INR 1,500,000 - 2,700,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

RandomTrees • Kolkata

On-site
INR 3,500,000 - 7,000,000
Snowflake Data Engineer
Snowflake Data Engineer

Bahwan Cybertek Group • Hyderabad

Hybrid
INR 1,200,000 - 1,800,000
Snowflake Developer
Snowflake Developer

Weekday AI • Pune District

On-site
INR 1,400,000 - 2,000,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

EPAM Systems Inc • Hyderabad

On-site
INR 4,000,000 - 7,000,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

EPAM Systems Inc • Chennai District, Coimbatore District

On-site
INR 3,500,000 - 6,000,000
Lead Snowflake Data Engineer
Lead Snowflake Data Engineer

EPAM Systems Inc • Gurugram District

Hybrid
INR 3,500,000 - 6,000,000