Veröffentlicht vor 1 Woche
Snowflake Data Architect
- Remote
- Vollzeit
- Snowflake
- SQL
Jobbeschreibung
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.
Weitere Jobs bei Datavail
Weitere Jobs: Vereinigte Staaten
3rd shift | Injection Molding Technician
Partnersinstaffingmi Caledonia, Michigan, Vereinigte Staaten🇺🇸
1st Shift | Material Handler
Partnersinstaffingmi Caledonia, Michigan, Vereinigte Staaten🇺🇸
Front Desk Receptionist / Data Entry
True Mission HR Irvine, Kalifornien, Vereinigte Staaten🇺🇸
Hospice Licensed Practical Nurse (LPN)
Purposelink Recruitment Carlinville, Illinois, Vereinigte Staaten🇺🇸
Physician – Occupational Medicine
Purposelink Recruitment Santa Rosa, Kalifornien, Vereinigte Staaten🇺🇸
Restaurant General Manager
Schlotzsky's Vereinigte Staaten 🇺🇸
Kitchen Staff
Schlotzsky's Vereinigte Staaten 🇺🇸
Regulatory Operations Specialist
Enigma Search South San Francisco, Kalifornien, Vereinigte Staaten🇺🇸
Principal Perfusionist - San Francisco, CA
VitalHire San Francisco, Kalifornien, Vereinigte Staaten🇺🇸
Registered Nurse (RN) Weekend Package Nights
Care Initiatives Waterloo, Iowa, Vereinigte Staaten🇺🇸
Material Handler
ATCO Rubber Products Inc. Crawfordsville, Indiana, Vereinigte Staaten🇺🇸
Painter (Entry Level) - Broussard, LA
Textron Broussard, Louisiana, Vereinigte Staaten🇺🇸
Estimator/Project Assistant
Elevant Recruiting Irwindale, Kalifornien, Vereinigte Staaten🇺🇸