Job Description

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.

Base Compensation Range: 100,000 - 150,000

The posted range is the hiring range for this role - a subset of the broader range available to employees over time - and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process.

Responsibilities

Key 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.

Required Skills and Qualifications

• 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.

Snowflake Cortex Requirements

• 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.

Preferred Skills

• 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.

Qualifications

Bachelor's in engineering or computer science