Dodano 1 tydzień temu
Snowflake Data Architect
- Zdalnie
- Pełny etat
- Snowflake
- SQL
Opis oferty
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.
Więcej ofert w firmie Datavail
Inne oferty: Stany Zjednoczone
Dealer Lot Services Specialist
AutoCartel Texas LLC Plano, Teksas, Stany Zjednoczone🇺🇸
Business Development Manager
AutoCartel Texas LLC Southlake, Teksas, Stany Zjednoczone🇺🇸
Office Manager & HR Administrator - Nashville
Infopro Digital Nashville, Tennessee, Stany Zjednoczone🇺🇸
Conference Content Manager
Infopro Digital Nashville, Tennessee, Stany Zjednoczone🇺🇸
Civil or Structural Engineer - Pittsburgh
Rimkus Pittsburgh, Pensylwania, Stany Zjednoczone🇺🇸
Civil or Structural Engineer - Cincinnati
Rimkus Cincinnati, Ohio, Stany Zjednoczone🇺🇸
Center-Based BCBA | Full-time & Part-time
Behavioral Health Works Cleveland, Ohio, Stany Zjednoczone🇺🇸
Board Certified Behavior Analyst (BCBA) - Sign-On Bonus
Behavioral Health Works Boston, Massachusetts, Stany Zjednoczone🇺🇸
NUI Maintenance I/Custodian SY
North Slope Borough School District Alaska, Stany Zjednoczone🇺🇸
NUI Maintenance I/Custodian YR
North Slope Borough School District Alaska, Stany Zjednoczone🇺🇸
Director of Talent Acquisition
Libra Solutions Wiele lokalizacji🇺🇸