Principal Snowflake Architect

Job Category: Principal Snowflake Architect

Job Type: Onsite

Job Location: Kansas City Missouri

Compensation: Depends on Experience

W2: W2-Contract Only; Kindly note that applications on a C2C basis will not be considered for this role.

Job Description

Job Description:

We are looking for a Principal Snowflake Architect to lead the architecture and design of a Customer Data Platform (CDP) for our client. The ideal candidate will have deep expertise in Snowflake and experience building enterprise-scale data platforms that unify customer data from multiple systems for analytics, personalization, and AI-driven insights.

Key Responsibilities

Lead the end-to-end architecture, design, and implementation of the Customer Data Platform (CDP) on Snowflake.

Define data flow from ingestion and transformation to data activation and consumption.

Design data models, marts, and analytical layers for 360° customer views, segmentation, and personalization.

Integrate data from various sources such as CRM, marketing, sales, web analytics, and product telemetry.

Define data governance, security, and privacy frameworks, ensuring compliance with GDPR, CCPA, and other regulations.

Collaborate with cross-functional teams (data engineering, product, marketing, analytics) to align architecture with business goals.

Evaluate and recommend modern data tools for ETL/ELT, orchestration, and data activation.

Mentor data engineering teams on best practices for Snowflake performance, cost optimization, and CI/CD automation.

Communicate architecture decisions and technical concepts effectively to both technical and non-technical stakeholders.

Required Qualifications

12+ years of experience in data engineering and architecture, with at least 4 years focused on Snowflake.

Proven track record of designing and implementing Customer Data Platforms (CDPs) or similar large-scale analytical ecosystems.

Strong expertise in Snowflake architecture (Virtual Warehouses, Secure Data Sharing, Streams, Tasks, Time Travel, etc.).

Experience with ELT frameworks such as DBT or equivalent.

Hands-on experience with data ingestion tools like SnapLogic, Matillion, or Workato.

Familiarity with orchestration tools such as Airflow or Dagster.

Experience integrating marketing, CRM, and digital analytics data sources.

Solid understanding of data governance, MDM, and metadata management concepts.

Exposure to AI/ML or real-time data activation within a CDP is a plus.

Excellent communication and presentation skills for engaging both technical and business stakeholders.

Nice To Have

Experience in client-facing consulting environments is preferred.

SnowPro Advanced Architect certification

Apply Online

Your Name *

Your Phone Number *

Your Email Address *

Job id

What is your current U.S. visa or immigration status? *

SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa

Where are you currently located at? *

W2 or C2C *

SelectW2C2C

How many years of total experience do you have? *

How many years of relevant experience do you have? *

Do you require H1B sponsorship? *

YesNo

Do you require sponsorship? *

NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship

Upload Resume *

Δ

Facebook X LinkedIn WhatsApp