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 contemporary 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.

📌 Snowflake Data Engineer (Bengaluru)
🏢 Genpact
📍 Bengaluru