Senior Snowflake Data Platform Architect - Hybrid

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

Do you have experience in Tooling?, * Location: Hybrid at one of these locations: Frisco, TX, Alpharetta, GA, Coral Springs, FL, or Berkeley Heights, NJ

• 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., 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., * 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, * Are you comfortable working on W2? If not, please hold off on completing the application for now. We’ll be posting another opportunity in the future for 1099/C2C candidates.
• Are you legally authorized to work in the United States, US Citizen/Green Card Holder? If not, please hold off on completing the application for now. We’ll be posting another opportunity in the future for visa candidates.
• Are you willing to work on a contract basis? If not, please hold off on completing the application for now. We’ll be posting another opportunity in the future for full time roles.
• Do you have advanced SQL skills and strong background in relational data warehousing? If you do not have, please hold off on completing the application for now. We’ll be posting another opportunity in the future for candidates without the required experience.
• Do you have proven experience designing dimensional models and semantic data layers? If you do not have, please hold off on completing the application for now. We’ll be posting another opportunity in the future for candidates without the required experience.
• Do you have experience enabling BI platforms such as Power BI or Sigma? If you do not have, please hold off on completing the application for now. We’ll be posting another opportunity in the future for candidates without the required experience.
• Do you have experience working with ELT-based ingestion pipelines and enterprise data tooling? If you do not have, please hold off on completing the application for now. We’ll be posting another opportunity in the future for candidates without the required experience.
• Do you have strong hands-on experience with Snowflake as an enterprise analytics platform? If you do not have, please hold off on completing the application for now. We’ll be posting another opportunity in the future for candidates without the required experience.

Work Location: Hybrid remote in Berkeley Heights, NJ 07922

3.93.9 out of 5 stars Berkeley Heights, NJ 07922 Hybrid work $60 - $65 an hour - Full-time, Contract, Pulled from the full job description

• Referral program
• Health insurance
• Vision insurance
• Dental insurance, Job Types: Full-time, Contract

Pay: $60.00 - $65.00 per hour

Benefits:

• Dental insurance
• Health insurance
• Referral program
• Vision insurance