Senior Snowflake Data Architect - Remote Data & DW Leader

Datavail; Boulder (CO); Remote; USD 170,000 - 240,000; Full time

Job summary

Datavail is seeking a Senior Snowflake Data Architect to own Snowflake architecture, lead dimensional and historical modeling, and translate business requirements into scalable logical and physical designs for engineering delivery.

You will guide engineers, conduct design reviews, manage technical risks, and ensure data quality, lineage, and security compliance across payer, member and clinical data domains. Remote-friendly, senior role with 10+ years in data engineering/analytics.

Qualifications

• 10+ years in data engineering, warehousing or analytics.
• 5+ years as a data or solution architect.
• Deep hands-on Snowflake architecture and advanced SQL experience.
• Expert dimensional modeling, including SCD Type 2.
• Experience with MPI logic and client-defined matching.

Responsibilities

• Own Snowflake architecture and define staging, curated and conformed-layer patterns.
• Translate business and technical requirements into logical and physical designs for delivery.
• Lead dimensional and historical modeling for patient/member data, including SCD Type 2.
• Design patient/member crosswalks and enterprise identity structures supporting MPI logic.
• Design payer attribution, member-month and temporal models across payer/plan networks.
• Define reconciliation, schema-drift, null/datatype, referential-integrity, exceptional 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.

Skills

Snowflake architecture

Data engineering

Data warehousing

Dimensional modeling

SCD Type 2

SQL proficiency

Data quality

Data governance

MPI logic

Client leadership

Job description

Datavail is seeking a Senior Snowflake Data Architect to own Snowflake architecture, lead dimensional and historical modeling, and translate business requirements into scalable logical and physical designs for engineering delivery.

You will guide engineers, conduct design reviews, manage technical risks, and ensure data quality, lineage, and security compliance across payer, member and clinical data domains. Remote-friendly, senior role with 10+ years in data engineering/analytics.