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.