Snowflake Senior technical lead

EXL Talent Acquisition Team; Pune District; On-site; INR 3,000,000 - 5,500,000; Full time

Job summary

EXL Talent Acquisition Team seeks a seasoned Snowflake CoE Leader to architect and scale modern data platforms in Pune. You will own end-to-end Snowflake architecture, governance, and delivery for enterprise programs, while mentoring engineers and steering data strategy.

You will collaborate with clients to define roadmaps, drive FinOps and CI/CD adoption, and foster a strong data-driven culture across large delivery teams.

Qualifications

• 15+ years in data engineering/analytics roles.
• 7+ years in Snowflake with architecture & delivery experience.
• Proven leadership of CoE / large delivery teams.
• Deep expertise in Snowflake features, data modelling, and governance.
• Experience with ELT pipelines and orchestration tools.

Responsibilities

• Build and scale Snowflake CoE capabilities (architecture, governance, FinOps).
• Define reference architectures, reusable assets, frameworks, and accelerators.
• Drive capability development, hiring strategy, and upskilling.
• Establish standards for delivery quality, security, and performance.
• Own end-to-end Snowflake architecture for enterprise-scale programs.
• Translate business goals into data platform strategies (lakehouse/modern data stack).
• Design solutions across data ingestion, transformation, orchestration, modelling, and consumption.
• Lead architecture governance and design reviews.
• Lead large-scale implementations and transformations on Snowflake.
• Define and track delivery KPIs, cost optimisation, and performance metrics.
• Ensure CI/CD, DataOps, and DevSecOps adoption; escalate complex challenges.
• Partner with clients to define data strategies and roadmaps; drive account growth.
• Mentor architects and engineers; foster communities around Snowflake and dbt.

Skills

Snowflake Architecture

CoE Leadership

Delivery Leadership

Data Governance

Data Modelling

ETL/ELT Pipelines

Data Orchestration

Performance Tuning

FinOps

Mentorship

Client Engagement

Tools

Snowflake

dbt

Airflow

ADF

Matillion

Informatica

Spark

Job description

Key Responsibilities

1. COE Leadership & Strategy

• Build and scale Snowflake CoE capabilities (architecture, engineering, governance, FinOps).


• Define reference architectures, reusable assets, frameworks, and accelerators.


• Drive capability development, hiring strategy, and upskilling initiatives.


• Establish standards for delivery quality, security, and performance.

2. Solution Architecture & Advisory

• Own end-to-end Snowflake architecture for enterprise-scale programs.


• Translate business goals into data platform strategies (lakehouse / data warehouse / modern data stack).


• Design solutions across: o Data ingestion, transformation, and orchestration o Data modelling (Dimensional, Data Vault, Medallion/Lakehouse architectures) o Data consumption (BI, APIs, AI/ML integration)


• Lead architecture governance and design reviews.

3. Delivery Leadership & Governance

• Lead large-scale implementations and transformations on Snowflake.


• Define and track delivery KPIs, cost optimisation (FinOps), and performance metrics.


• Ensure adoption of CI/CD, DataOps, and DevSecOps practices.


• Act as escalation point for complex technical challenges.

4. Client Engagement & Consulting

• Partner with clients to define data strategies, roadmaps, and transformation journeys.


• Lead solution workshops, proposals, and executive discussions.


• Provide thought leadership in Snowflake, Data Engineering, and Analytics.


• Drive account growth through cross-selling and innovation-led proposals.

5. Engineering Excellence & Mentorship

• Mentor architects and engineers across projects.


• Build strong internal communities around: o Snowflake o dbt / modern data stack o Cloud-native data engineering


• Promote best practices in coding, modelling, and governance.

Must Have Skills & Experience

• 15+ years overall experience in data engineering / analytics / data platform roles.


• 7+ years in Snowflake with strong architecture + delivery experience.


• Proven experience in leading CoE / practice / large delivery teams.


• Deep expertise in: o Snowflake (Snowpipe, Streams & Tasks, Dynamic Tables, Secure Sharing) o Data modelling (Dimensional / Data Vault / Lakehouse) o Performance tuning & cost optimisation strategies o Data governance & security (RBAC, masking, row/column security)


• Strong experience in ELT/ETL pipelines and orchestration tools (ADF, Airflow, dbt, Matillion, Informatica)


• Hands-on experience in client-facing consulting roles and solution design.

Good to Have

• Experience on Azure / AWS / GCP ecosystems


• Exposure to GenAI / AI integration with data platforms


• Experience in domain analytics (Insurance, BFSI, Healthcare)


• Familiarity with modern data stack tools (dbt, Python frameworks, Spark)