Senior Snowflake Data Platform Architect

We are seeking a Senior Snowflake Data Platform Architect to serve as a senior subject matter expert (SME) supporting a modern enterprise analytics platform built on Snowflake. This role partners closely with existing Platform Architects and senior technical leaders, contributing deep expertise in analytics-focused data architecture, modeling, reporting enablement, ELT-based system onboarding, and enterprise data integration.

This individual is not the final architectural authority, but a highly experienced practitioner who works alongside platform architects, engineering teams, and business stakeholders to onboard new data sources, refine platform patterns, and ensure Snowflake is used effectively for enterprise analytics and reporting use cases.

Scope, Accountability & Impact (Senior Level)

This role operates as a Senior individual contributor within the enterprise data platform organization. The Senior Snowflake Data Platform Architect contributes hands-on expertise while executing within established architectural guardrails defined by Platform Architects.

• Typically 7 10 years of experience in data engineering, analytics, or data architecture roles.

• 3+ years of hands-on experience working with Snowflake in enterprise environments.

• Supports onboarding of individual systems or domains into Snowflake.

• Designs analytics-ready data models and semantic views aligned to existing platform standards.

• Escalates major architectural tradeoffs and risks to Platform Architects.

Key Responsibilities

Snowflake Platform Expertise

• Act as a Snowflake subject matter expert partnering with Platform Architects to operationalize analytics architectures.
• Provide hands-on guidance on schema design, workload isolation, performance tuning, and cost optimization.
• Apply Snowflake best practices across ingestion, transformation, and consumption layers.

System Onboarding & Data Pipelines

• Partner with technical teams and business stakeholders to onboard new source systems into Snowflake.
• Provide architectural guidance on ELT-based ingestion and transformation patterns.
• Collaborate on pipelines using tools such as CData Sync, Qlik Replicate, Azure Data Factory (ADF), Openflow, or similar.
• Help define standards for incremental loading, CDC, data quality, and reliability.

Analytics & Data Modeling

• Design analytics-optimized data models including star schemas, fact/dimension tables, and reporting-ready datasets.
• Apply modern patterns such as medallion architectures and curated semantic views.

Reporting & BI Enablement

• Ensure Snowflake datasets are optimized for BI tools such as Power BI and Sigma.
• Partner with reporting teams to ensure metric consistency and reduce downstream modeling complexity.

Enterprise & SaaS Data Integration

• Support analytical integration of data from systems such as Salesforce (strong plus for Salesforce Data Cloud / Data 360), SAP, Workday, Jira, ServiceNow, and similar platforms.
• Translate operational and SaaS-native data models into analytics-ready Snowflake structures.

Collaboration & Emerging Capabilities

• Work closely with Platform Architects, data engineering teams, analytics teams, and business stakeholders.
• Maintain foundational familiarity with Snowflake Cortex and partner with AI specialists when applicable.

Required Qualifications

• Strong hands-on experience with Snowflake as an enterprise analytics platform.

• Advanced SQL skills and strong background in relational data warehousing.

• Proven experience designing dimensional models and semantic data layers.

• Experience enabling BI platforms such as Power BI or Sigma.

• Experience working with ELT-based ingestion pipelines and enterprise data tooling.

Preferred / Strong Plus Qualifications

• Experience with Salesforce Data Cloud (Data 360) and Salesforce data models.

• Exposure to Snowflake Cortex (non-specialist).

• Experience operating in large, multi-team enterprise environments.

• Snowflake certifications such as SnowPro Core, SnowPro Advanced Architect, and / or additional advanced or specialty certifications are a plus