Yayınlanma: 1 hafta önce

Snowflake Data Architect

Datavail
Uzaktan · Amerika Birleşik Devletleri 🇺🇸
  • Uzaktan
  • Tam zamanlı
  • Snowflake
  • SQL

İlan açıklaması

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.

Datavail şirketinin diğer ilanları

Senior Data Architect

Datavail Uzaktan · Amerika Birleşik Devletleri 🇺🇸

Uzaktan Tam zamanlı 3 hafta önce

Diğer ilanlar: Amerika Birleşik Devletleri

Registered Nurse

Mosaic Rockford, Illinois, Amerika Birleşik Devletleri🇺🇸

İş yerinde Tam zamanlı 47 dakika önce

ABD için daha fazla uzaktan iş ilanı