Snowflake Data Engineer

Genpact Ltd.; Hyderabad, Bengaluru, Delhi; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Genpact Ltd. Hyderabad seeks a Senior Snowflake & DBT Architect/Lead Data Engineer with 5+ years in data engineering, warehousing, and cloud analytics. You will architect scalable data platforms, lead technical teams, and drive best practices for enterprise-scale BI and analytics solutions.

Role emphasizes Snowflake, DBT, SQL, and cloud platforms (Azure/AWS/GCP) with governance, performance tuning, and CI/CD integration. Mentoring and cross-functional collaboration are core to success.

Qualifications

• 5+ years in Data Engineering or Analytics Engineering.
• 4+ years hands-on Snowflake experience.
• DBT development and ELT framework experience.
• Strong SQL and data modeling skills; cloud platform experience.
• Leadership, mentoring, and collaboration with stakeholders.

Responsibilities

• Architect scalable data warehouses and modern data platforms.
• Lead ELT development using DBT and optimize pipelines.
• Drive performance tuning, cost governance, and security.
• Define data modeling standards and governance.
• Mentor junior engineers and lead design/architecture reviews.

Skills

SQL

Python

Data modeling

ETL/ELT

Leadership

Education

Bachelor's or Master's in CS/IT/Engineering

Tools

Snowflake

DBT

Azure

AWS

GCP

Git

CI/CD

Airflow

Databricks

Terraform

Job description

Role & responsibilities

We are looking for a highly experienced Senior Snowflake & DBT Architect/Lead Data Engineer with 5+ years of experience in Data Engineering, Data Warehousing, and Cloud Analytics. The ideal candidate will have strong expertise in Snowflake, DBT (Data Build Tool), SQL, and cloud platforms, with a proven track record of designing and implementing enterprise-scale data solutions.

The candidate will be responsible for architecting modern data platforms, leading technical teams, driving best practices, and delivering scalable, high-performance data solutions that support business intelligence and analytics initiatives.

Key Responsibilities

• Design and architect scalable data warehouse solutions using Snowflake.
• Lead the development and implementation of ELT frameworks using DBT.
• Develop and optimize complex SQL queries, stored procedures, tasks, streams, and data pipelines.
• Define and implement data modeling standards including dimensional and data vault methodologies.
• Work closely with business stakeholders, architects, and analytics teams to understand requirements and translate them into technical solutions.
• Drive Snowflake performance tuning, cost optimization, and governance initiatives.
• Implement DBT best practices including testing, documentation, lineage, and CI/CD integration.
• Establish data quality, security, and audit controls across the data ecosystem.
• Mentor and guide junior data engineers and technical teams.
• Lead architecture reviews, code reviews, and technical discussions.
• Collaborate with DevOps teams to automate deployments and monitoring processes.
• Support cloud migration and modernization initiatives from legacy platforms to Snowflake.

Mandatory Skills

• 5+ years of experience in Data Engineering, Data Warehousing, or Analytics Engineering.
• Minimum 4+ years of hands-on experience with Snowflake.
• Exp in Cortex AI
• Minimum 3+ years of hands-on experience with DBT.
• Strong expertise in advanced SQL and query optimization.
• Extensive experience in data warehouse design, dimensional modeling, and ETL/ELT frameworks.
• Experience with cloud platforms:
• Azure (preferred)
• AWS
• GCP
• Strong knowledge of Python for data engineering and automation.
• Experience with Git, CI/CD pipelines, and DevOps practices.
• Excellent understanding of data governance, security, and performance optimization.

Preferred Skills

• Microsoft Azure Data Factory (ADF)
• Azure Synapse Analytics
• Microsoft Fabric
• Apache Airflow
• Databricks
• Spark / PySpark
• Power BI or Tableau
• Terraform or Infrastructure as Code (IaC)

Responsibilities as Technical Lead

• Provide technical leadership for Snowflake and DBT initiatives.
• Define architecture standards and data engineering best practices.
• Conduct design reviews and solution assessments.
• Collaborate with enterprise architecture and business teams.
• Drive innovation, automation, and platform optimization.
• Support hiring, mentoring, and capability development of data engineering teams.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or related field.
• Snowflake certifications are highly preferred.
• Strong communication and stakeholder management skills.
• Experience working in global delivery and Agile environments.