Skip to content
×

Snowflake Data Architect

Listing for: Datavail
Full Time position Listed on 2026-11-16
Job specializations:
Salary/Wage Range or Industry Benchmark: 150000 - 180000 USD Yearly USD 150000.00 180000.00 YEAR

Job Description & How to Apply Below

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.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Education Level
Experience Level (years)
Posted in last:
Salary