Snowflake Data Architect

Datavail

. Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards .

Posted 11/7/2026full-timeRemote • United StatesSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in Snowflake architecture, advanced SQL, and dimensional modeling, with a strong focus on healthcare data security and compliance. Proven ability to translate complex business and technical requirements into effective data solutions while leading engineering teams and managing technical risks.

Highest-signal resume keywords

Snowflake ArchitectureAdvanced SQLDimensional ModelingData Quality ManagementClient-Facing Leadership

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data EngineeringData WarehousingAnalyticsDimensional ModelingSCD Type 2Crosswalk/Entity-Resolution ModelsReconciliationAudit/Control LoggingException HandlingDocumentation

Soft Skills

LeadershipCommunicationCollaboration

Industry Keywords

Healthcare PayerHealthcare ProviderMPIClient SecurityCompliance Requirements

Tech Stack

Tools & technologies

SnowflakeSQL

About the role

Key responsibilities & impact

Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards
Translate business and technical requirements into logical and physical designs for engineering delivery
Lead dimensional and historical modeling for patient/member data, including SCD Type 2
Design patient/member crosswalks and enterprise identity structures supporting client-validated MPI logic
Design payer attribution, member-month and temporal models across payer/plan, provider networks, PCPs and clinics
Define reconciliation, schema-drift, null/datatype, referential-integrity, exception and alerting controls
Establish naming, lineage, source-to-target, testing, operational logging and runbook standards
Protect sensitive healthcare data and support client security and compliance requirements
Guide engineers, conduct design reviews, manage technical risks and support sprint planning and estimates

Requirements

What you’ll need

10+ years in data engineering, warehousing or analytics, including 5+ years as a data or solution architect
Deep hands-on Snowflake architecture and advanced SQL experience
Expert dimensional modeling: star schemas, conformed dimensions, surrogate keys and SCD Type 2
Experience with member identity, crosswalk/entity-resolution models and client-defined matching logic
Strong data quality, reconciliation, audit/control logging, exception handling, lineage and documentation skills
Client-facing leadership experience
Healthcare payer/provider and MPI experience preferred
Ability to protect sensitive healthcare data and support client security and compliance requirements

Benefits

Comp & perks

3-month contract duration