Snowflake Data Architect
Job in
San Jose, Santa Clara County, California, 95025, USA
Listing for:
Datavail
Full Time
position
Listed on 2026-11-16
Job specializations:
-
IT/Tech
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.
- - 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
(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