Snowflake Data Architect

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.