Snowflake Architect
- EXL
- 10 - 20 years
- Pune
- 1 day ago
- Email to a friend
- Report this job
Job Description
Role: Snowflake Architect
Location: Pune / Gurgaon / Bangalore
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 mindsetunderstanding 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
- 10+ years overall experience with a strong Data Engineering background (data pipelines, modelling, distributed processing, production support).
- 4+ 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 skillsable 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
- Bachelors/Masters in Computer Science, Information Systems, Data Engineering, or related fields.
Key Skills: Snowflake, Data Architecture, Data Modelling, Data Governance, Stakeholder Management
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Technical ArchitectEmployement Type: Full timeContact Details:
Company: EXLLocation(s): Pune
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in