EXL
Website:
exlservice.com
Job details:
Role: Snowflake Architect (Strong Data Engineering Background)
Location: Pune / Gurgaon / Bangalore
Work Mode: Hybrid
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
- 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 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
Click on Apply to know more.