Snowflake Lead 10-15 years Exp – Chennai

HypTechie; Chennai District; Hybrid; INR 3,000,000 - 3,500,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

HypTechie is seeking a Snowflake Lead in Chennai, Tamil Nadu, with 10–15 years of IT experience and deep Snowflake expertise. The role is hybrid (office + home) and permanent, offering a challenging chance to drive end-to-end data architecture, modeling, and design initiatives in a large-scale environment.

The candidate will lead teams, craft scalable data solutions, and collaborate with BI and cross-functional stakeholders to optimize performance using Snowflake, Data Vault 2.0, and arc42

Qualifications

• 10–15 years IT experience with Snowflake.
• Advanced SQL and handling large datasets.
• Experience in data modeling: 3NF, Star, Snowflake schema.

Responsibilities

• Collaborate with business stakeholders and cross-functional teams to translate business needs into scalable data solutions.
• Design and document solution architectures using the arc42 framework and create Architecture Decision Records (ADR).
• Develop and optimize data models (3NF, Star Schema, Snowflake Schema).
• Apply Data Vault 2.0 modeling concepts in enterprise-level data solutions.
• Ensure high performance and efficiency in Snowflake scripts for large datasets.
• Guide design and development teams to ensure alignment with enterprise data architecture.
• Collaborate with BI teams for performance optimization and analytics delivery.
• Utilize Wherescape RED & 3D tools for automation and modeling (preferred).
• Ability to design and deliver end-to-end data pipeline and BI solutions.

Skills

Snowflake

SQL

Data modeling

Data Vault 2.0

arc42

Architecture docs

Leadership

Stakeholder mgmt

Tools

Wherescape RED

3D

Job description

Snowflake Lead | Job ID – 6263

Location: Chennai, Tamil Nadu (Hybrid – Office + Home)
Job Type: Permanent | Duration: Permanent
Experience: 10 – 15 Years
Salary Range: ₹30,00,000 – ₹35,00,000 per annum

About the Role

Our client is looking for an experienced Snowflake Lead to drive end-to-end data architecture, modeling, and design initiatives in a large-scale enterprise environment. The ideal candidate will have deep technical expertise in Snowflake and data modeling, combined with strong leadership skills to guide teams and ensure the delivery of high-performance data solutions.

Key Responsibilities

• Collaborate with business stakeholders and cross-functional teams to translate business needs into scalable data solutions.
• Design and document solution architectures using the arc42 framework and create Architecture Decision Records (ADR).
• Develop and optimize data models (3NF, Star Schema, Snowflake Schema).
• Apply Data Vault 2.0 modeling concepts in enterprise-level data solutions.
• Ensure high performance and efficiency in Snowflake scripts for large datasets.
• Guide design and development teams to ensure alignment with enterprise data architecture.
• Collaborate with BI teams for performance optimization and analytics delivery.
• Utilize Wherescape RED & 3D tools for automation and modeling (preferred).

Skills & Qualifications

• 10–15 years of overall IT experience, with strong hands-on expertise in Snowflake.
• Advanced proficiency in SQL and handling large datasets.
• Strong experience in data modeling — 3NF, Star Schema, Snowflake Schema.
• Knowledge of Data Vault 2.0 modeling and modern data architecture frameworks.
• Experience in solution design and architecture documentation using arc42.
• Working knowledge of Wherescape RED & 3D is a plus.
• Excellent communication, analytical, and stakeholder management skills.

Ability to design and deliver end-to-end data pipeline and BI solutions.