Senior Specialist - Architecture (Sr Snowflake Data Platform Architect)

About the Role

We are seeking a Senior Snowflake Data Platform Architect to serve as a senior subject-matter expert 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 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 and Impact

This is a senior-level individual contributor role 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 requires 7 to 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 trade-offs and risks to Platform Architects

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 CDC, Data 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.

Qualifications

Required:

• Strong hands-on experience with Snowflake as an enterprise analytics platform
• Advanced SQL skills and a 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:

• Experience with Salesforce Data Cloud/Data 360 and Salesforce data models
• Exposure to Snowflake Cortex (non-specialist level)
• Experience operating in large, multi-team enterprise environments
• Snowflake certifications such as SnowPro Core, SnowPro Advanced Architect, or additional advanced/specialty certifications (a plus)

Benefits

• Comprehensive medical plan covering medical, dental, and vision
• Short-term and long-term disability coverage
• 401(k) plan with company match
• Life insurance
• Vacation time, sick leave, and paid holidays
• Paid paternity and maternity leave

Pay

The range displayed reflects the minimum and maximum salary target for the position across all US locations. Individual pay is determined by work location, job level, and additional factors including job-related skills, experience, and relevant education or training. Depending on the position, other forms of compensation may be provided, such as an annual performance-based bonus, sales incentive pay, or other forms of bonus/variable compensation.