Snowflake Data Engineer – Lead | Data Engineering |Mumbai
1. Job Persona Parameters
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
Department: Data Engineering & Analytics
Industry : IT Services & Consulting; Data & Analytics
Location : Mumbai
Location Relocation: No
Preferred Mode of Work: Hybrid
Min Experience: 5 years
Max Experience : 12 years
Notice Period: 0-30 days
Minimum Compensation: 25 Lacs
Maximum Compensation: 30 Lacs
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. Valuable To Have Skills
- Streamlit on Snowflake
- Kafka or streaming pipelines
- CI/CD with Azure DevOps or GitHub Actions
- Data governance tooling (Collibra, Informatica MDM)
- 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.
📌 Snowflake Data Engineer – Lead (Mumbai)
🏢 Taggd
📍 Mumbai