Snowflake Technical Lead

EXL; Pune District; Hybrid; INR 4,000,000 - 6,500,000; Full time

Job summary

EXL is seeking a Snowflake Architect with a strong Data Engineering foundation to design secure, scalable, and cost-optimised Snowflake-based platforms in a hybrid role. You will work with product owners and client teams to translate business needs into customised data solutions across ingestion, transformation, modelling, governance, and consumption.

You will lead end-to-end Snowflake platform architecture, implement ELT/ETL pipelines, and design data models like star and snowflake schemas.

Qualifications

• 9+ years of data engineering experience with strong fundamentals.
• 5+ years hands-on Snowflake architecture/implementation experience.
• Strong SQL, performance tuning, and data modelling expertise.

Responsibilities

• Lead end-to-end Snowflake platform architecture with reference architectures and design patterns.
• Translate business requirements into customised data solutions (lakehouse/warehouse, marts, semantic layers).
• Architect ELT/ETL pipelines into Snowflake using orchestration and CI/CD.
• Design data modelling approaches (star/snowflake, data vault) and establish naming standards.
• Implement Snowflake features: Snowpipe, Streams & Tasks, Dynamic Tables; optimize clustering and cost governance.
• Define performance tuning strategies and resource monitoring for cost efficiency.
• Design and implement data security controls (RBAC, masking, encryption, secure sharing).
• Collaborate with stakeholders to drive adoption and improve customer experience and decision-making.
• Mentor engineers and develop reusable accelerators and templates.

Skills

9+ years exp

Snowflake experience

SQL

Performance tuning

Data modelling

Data governance

Security

Stakeholder management

Communication

Cloud platforms (Azure/AWS/GCP)

Python frameworks

Spark integrations

Education

Bachelors/Masters in CS/IS/Data Eng

Tools

ADF

Airflow

dbt

Matillion

Informatica

CI/CD

Job description

Role: Snowflake Technical Lead (Strong Data Engineering Background)

Work Mode:

Hybrid

About EXL

EXL is a leading global analytics and digital solutions company that partners with clients to improve business outcomes and accelerate growth. With expertise across industries such as insurance, healthcare, banking, financial services, and logistics, EXL leverages advanced analytics, AI, digital transformation, and domain knowledge to deliver innovative solutions. Headquartered in New York, EXL operates in more than 50 offices worldwide, combining deep industry expertise with cutting-edge technology to help organisations enhance customer experience, optimise operations, and drive sustainable value.

About the Role

We are seeking a Snowflake Architect with a strong Data Engineering foundation to design and deliver secure, scalable, performant, and cost-optimised Snowflake-based platforms. The role demands a customer-centric mindset—understanding business outcomes and translating them into customised data solutions across ingestion, transformation, modelling, governance, and consumption.

Key Role & Responsibilities

• Lead end-to-end Snowflake platform architecture: reference architectures, design patterns, and implementation blueprints.
• Translate business requirements into customised solution designs (data lakehouse/warehouse, marts, semantic layers) aligned to customer priorities.
• Architect ELT/ETL pipelines into Snowflake using best-practice orchestration and CI/CD.
• Design data modelling approaches (dimensional, data vault, mart layers) and establish standards and naming conventions.
• Implement Snowflake features: Snowpipe, Streams & Tasks, Dynamic Tables (where applicable), clustering strategies, secure views, and secure data sharing.
• Define performance tuning strategy (warehouse sizing, query optimisation, clustering, caching) and cost governance (resource monitors, usage dashboards).
• Design and implement security: RBAC, masking policies, row/column level security, encryption, secrets management, secure sharing.
• Partner with stakeholders (product owners, analysts, client teams) to drive adoption and ensure solutions improve customer experience and decision-making.
• Mentor engineers and conduct design/architecture reviews; build reusable accelerators and templates.

Must Have

• 9+ years overall experience with a strong Data Engineering background (data pipelines, modelling, distributed processing, production support).
• 5+ years hands‑on Snowflake experience in architecture and implementation roles.
• Strong SQL, performance tuning, and data modelling expertise (star/snowflake schemas, marts, warehouse patterns).
• Hands‑on experience with modern ingestion/orchestration tooling (e.g., ADF/Airflow/dbt/Matillion/Informatica) and CI/CD.
• Strong understanding of data governance, security, and compliance controls in cloud data platforms.
• Proven ability to work directly with customers: requirements workshops, solution options, trade‑offs, and implementation roadmaps.
• Strong communication skills—able to explain complex architecture to technical and non‑technical stakeholders.

Good to Have

• Cloud experience on Azure/AWS/GCP (networking basics, IAM, storage, monitoring).
• Experience with dbt on Snowflake, Python‑based frameworks, or Spark integrations.
• Experience in BFSI/Insurance/Healthcare analytics environments.

Education

• Bachelor’s/Master’s in Computer Science, Information Systems, Data Engineering, or related fields.

Key Skills:

Snowflake, Data Architecture, Data Modelling, Data Governance, Stakeholder Management