Snowflake Data Architect

Datavail · Remote, US
Work typeRemote
Pay · estimate~$110k – $145kMarket rate · not set by employer
PostedNov 22, 2026
LevelMid level
In short * 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.…
SQLAWSAZURESNOWFLAKE

📋 About the job

LocationRemote
Duration3 Month

Title: Senior Snowflake Data Architect

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…
📄 Read the full description → The rest of this listing is on the hiring partner’s site.
Interested in this role?Apply in one click — no JobQ account needed.
Apply now →
Snowflake Data ArchitectDatavail
Apply now