Senior Snowflake Data Architect — Remote & Influential Lead

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