Snowflake Architect

EXL•Jersey City, NJ

About The Position

We are seeking an experienced Snowflake Architect with 10+ years of experience in designing, architecting, and governing enterprise-scale data platforms. The ideal candidate will be responsible for driving Snowflake Center of Excellence (CoE) initiatives, establishing architecture standards, defining best practices, and leading enterprise-wide adoption of Snowflake capabilities including Snowflake Cortex, data governance, security, and performance optimization. The role requires strong expertise in Snowflake architecture, modern cloud data platforms, data modeling, ELT frameworks, and AI-powered analytics solutions. For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits

Requirements

10+ years of experience in Data Engineering, Data Architecture, or Data Warehousing.
5+ years of hands-on experience architecting and implementing Snowflake solutions.
Strong expertise in Snowflake architecture, platform design, and enterprise adoption.
Experience establishing and managing Data Platform or Snowflake CoE practices.
Deep understanding of Snowflake security, RBAC, data sharing, masking policies, and governance.
Expertise in dimensional modeling, data warehousing, and modern ELT architectures.
Experience with Snowpark and advanced Snowflake development capabilities.
Strong SQL expertise and performance tuning experience.
Experience with CI/CD, DevOps, and automated deployment processes.
Excellent stakeholder management and technical leadership skills.
Experience designing and implementing AI-driven solutions using Snowflake Cortex.
Knowledge of Cortex AI functions, LLM integration, semantic search, and ML-powered analytics.
Experience leveraging Cortex for intelligent data insights, summarization, classification, and natural language querying.
Understanding of AI governance, security, and responsible AI practices within Snowflake.
Bachelor's in engineering or computer science

Nice To Haves

Experience with dbt for transformation and data modeling.
Experience with Azure, AWS, or GCP cloud platforms.
Exposure to Databricks, Spark/PySpark, and modern data ecosystems.
Experience supporting Analytics, BI, and AI/ML use cases.
Snowflake certifications preferred.
BFSI/Insurance domain experience is a plus.

Responsibilities

Lead the Snowflake Center of Excellence (CoE) and define enterprise architecture standards, frameworks, and governance practices.
Design scalable, secure, and high-performance Snowflake data platform architectures.
Define Snowflake best practices for data modeling, ingestion, transformation, security, and operational excellence.
Drive enterprise data modernization and migration initiatives to Snowflake.
Establish reusable frameworks, templates, accelerators, and architecture patterns.
Implement and optimize Snowflake capabilities including Virtual Warehouses, Data Sharing, Snowpark, and Cortex.
Define strategies for data governance, lineage, metadata management, and data quality.
Provide architecture guidance to data engineering, analytics, and business teams.
Conduct architecture reviews, design assessments, and performance optimization initiatives.
Mentor engineering teams and build Snowflake capabilities across the organization.