Snowflake Data Architect

Datavail Infotech • Boulder, CO

16h • Remote

About The Position

The Senior Snowflake Data Architect owns Snowflake architecture and establishes patterns and standards for staging, curated, and conformed data layers. The role translates business and technical requirements into logical and physical designs for engineering delivery, and leads dimensional and historical modeling for patient and member data, including SCD Type 2.

The architect designs patient/member crosswalks and enterprise identity structures that support client-validated MPI logic, as well as payer attribution, member-month, and temporal models spanning payer and plan data, provider networks, PCPs, and clinics. The role defines data-quality and operational controls, including reconciliation, schema-drift, null and datatype, referential-integrity, exception, and alerting controls. It establishes standards for naming, lineage, source-to-target documentation, testing, operational logging, and runbooks.

The position protects sensitive healthcare data and supports client security and compliance requirements. It also provides technical leadership by guiding engineers, conducting design reviews, managing technical risks, and supporting sprint planning and estimates. The role is remote and has a stated duration of three months.

Requirements

• 10+ years in data engineering, warehousing, or analytics.
• 5+ years as a data or solution architect.
• Deep hands-on Snowflake architecture experience.
• Advanced SQL experience.
• Expertise in dimensional modeling, including 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.

Nice To Haves

• Healthcare payer/provider experience.
• MPI experience.

Responsibilities

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

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed