Snowflake Data Architect

About this role

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.

Originally posted on Himalayas