Principal Snowflake Architect

Job Category: 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.
Eligible Visa: GC GC-EAD H4 EAD L2S U.S. Citizen (USC)

US Work Authorization Requirement:
Candidates must be legally authorized to work in the United States without employer sponsorship. This includes, but is not limited to, U.S. Citizens, Permanent Residents, and other individuals with valid U.S. work authorization.

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.
Experience in client-facing consulting environments is preferred.

Nice to Have:
SnowPro Advanced Architect certification