Key Skills: Senior Snowflake Data Architect

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 a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.

Job Description

Title: Senior Snowflake Data Architect

Location: Remote

Duration: 3 Month

Job Description:

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

Roles and 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.

About the Team

Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.

Job Info

• Job Identification 1998
• Job Category Technical
• Posting Date 11/07/2026, 02:29 PM
• Locations 4770, Baseline Rd., Boulder, CO, 80303, US (Remote)