Pubblicata 1 settimana fa

Snowflake Data Architect

Datavail
Da remoto · Stati Uniti 🇺🇸
  • Da remoto
  • Tempo pieno
  • Snowflake
  • SQL

Descrizione dell’offerta

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.

Altre offerte di Datavail

Altre offerte: Stati Uniti

Recruiter

tk accelis, Inc. Southfield, Michigan, Stati Uniti🇺🇸

Ibrido Tempo pieno 3 ore fa

TTT - Liaison

thyssenkrupp Supply Chain Services NA, Inc. Stati Uniti 🇺🇸

In sede Tempo pieno 3 ore fa

Solutions Design Intern

thyssenkrupp Supply Chain Services NA, Inc. Michigan, Stati Uniti🇺🇸

Ibrido StagePart-time 3 ore fa

Altre offerte da remoto: USA