Snowflake Data Architect

Datavail Infotech; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

Datavail is seeking a Senior Snowflake Data Architect for a remote, 3-month engagement. You will own Snowflake architecture, drive dimensional modeling, and design staging/curated layers for patient/member data within a healthcare context.

Responsibilities include translating requirements into designs, leading SCD Type 2 modeling, and guiding engineers through design reviews and sprint planning. Experience with MPI logic and data governance is highly valued.

Qualifications

• 10+ years in data engineering, warehousing or analytics.
• 5+ years as a data or solution architect.
• Strong Snowflake architecture and SQL skills.
• Expert dimensional modeling: star schemas, conformed dimensions, surrogate keys and SCD Type 2.
• Experience with identity/matching logic and crosswalk models.
• Strong data quality, reconciliation, logging and lineage skills.
• Client-facing leadership in healthcare context preferred.

Responsibilities

• Own Snowflake architecture; define staging, curated, conformed layers.
• Translate business requirements into logical and physical designs.
• Lead dimensional and historical modeling for patient data (SCD Type 2).
• Design crosswalks and enterprise identity structures supporting MPI logic.
• Define payer attribution and temporal models across payer networks.
• Establish naming, lineage, source-to-target, testing and runbook standards.
• Protect healthcare data; support security and compliance.
• Guide engineers; conduct design reviews and plan estimates.

Skills

Snowflake architecture

Advanced SQL

Dimensional modeling

SCD Type 2

Data quality

Client-facing leadership

Domain experience (healthcare)

Mentoring engineers

Tools

Snowflake

SQL

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)