Senior Snowflake Data Platform Architect

Proviniti; Frisco (TX); Hybrid; USD 140,000 - 180,000; Full time

Job summary

Proviniti is seeking a Senior Snowflake Data Platform Architect to drive analytics-focused data architecture across an enterprise data platform. You will partner with Platform Architects, engineering teams, and business stakeholders to onboard data sources, refine patterns, and ensure Snowflake is used efficiently for analytics and reporting.

Responsibilities include Snowflake architecture, schema design, workload isolation, cost optimization, ELT patterns, and collaboration with BI teams using

Qualifications

• Strong hands-on Snowflake experience in an enterprise analytics environment.
• Advanced SQL and relational data warehousing background.
• Proven ability to design dimensional models and semantic layers.
• Experience enabling BI platforms like Power BI or Sigma.
• Experience with ELT-based ingestion and enterprise data tooling.

Responsibilities

• Act as Snowflake SME and partner with Platform Architects to operationalize analytics architectures.
• Provide guidance on schema design, workload isolation, performance optimization, and cost control.
• Apply Snowflake best practices across ingestion, transformation, and consumption layers.
• Collaborate to onboard new source systems into Snowflake and define ELT patterns.
• Work with pipelines using tools like CData Sync, Qlik Replicate, ADF, or Openflow.

Skills

Snowflake

SQL

Data warehousing

Dimensional modelling

BI tools

ELT pipelines

Data integration

CDC

Education

Bachelor's degree in CS/IS or related field

Tools

CData Sync

Qlik Replicate

Azure Data Factory

Openflow

Job description

• Hybrid at one of these locations: Frisco, TX, Alpharetta, GA, Coral Springs, FL, or Berkeley Heights, NJ

Role Summary:

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