Yayınlanma: 1 hafta önce
Snowflake Data Architect
- 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 🇺🇸
Diğer ilanlar: Amerika Birleşik Devletleri
Insurance Professional (Remote)
pcfginsurance Uzaktan · Amerika Birleşik Devletleri 🇺🇸
Life Insurance & Annuity Adviser (Remote)
pcfginsurance Uzaktan · Amerika Birleşik Devletleri 🇺🇸
Virtual Assistant With Excellent English Skills
payetteforward Amerika Birleşik Devletleri 🇺🇸
Teller (Part Time) - Keller
Prosperity Bank Keller, Teksas, Amerika Birleşik Devletleri🇺🇸
Senior Lending Assistant (Full Time) - SB South Belt
Prosperity Bank Houston, Teksas, Amerika Birleşik Devletleri🇺🇸
Chimney Technician [Full Time]
patriotchimney Amerika Birleşik Devletleri 🇺🇸
Treasury Operations Specialist
Suveto Conshohocken, Pensilvanya, Amerika Birleşik Devletleri🇺🇸
Event & Field Marketing Manager (Remote)
projectaugustus Uzaktan · Amerika Birleşik Devletleri 🇺🇸
Events Coordinator (Remote)
projectaugustus Uzaktan · Amerika Birleşik Devletleri 🇺🇸
Manufacturing Operator - Day Shift
Resource Label Group, LLC Longmont, Colorado, Amerika Birleşik Devletleri🇺🇸
Director, IT Portfolio & Product Management
Resource Label Group, LLC Franklin, Tennessee, Amerika Birleşik Devletleri🇺🇸
Medical Virtual Assistant (Remote)
primeremotestaff Uzaktan · Amerika Birleşik Devletleri 🇺🇸
Real Estate Acquisition Specialist (Remote)
primeremotestaff Uzaktan · Amerika Birleşik Devletleri 🇺🇸
Registered Nurse
Mosaic Rockford, Illinois, Amerika Birleşik Devletleri🇺🇸