Publicat: acum o săptămână
Snowflake Data Architect
- Remote
- Normă întreagă
- Snowflake
- SQL
Descrierea jobului
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.
Mai multe joburi la Datavail
Senior Data Architect
Datavail Remote · Statele Unite ale Americii 🇺🇸
Alte joburi în Statele Unite ale Americii
Psychotherapist (work from home) - LPCC, LPC, LCSW or LMFT (Remote)
sparkmentalhealth Remote · Statele Unite ale Americii 🇺🇸
Psychiatric Nurse Practitioner for Remote Telepsychiatry - FT - REMOTE
sparkmentalhealth Remote · Statele Unite ale Americii 🇺🇸
Clinical Massage Therapist
somavidapainrelief Statele Unite ale Americii 🇺🇸
Director, Strategy & Operations (Executive Services)
Gartner Stamford, Connecticut, Statele Unite ale Americii🇺🇸
Executive Partner, Bus Services
Gartner Remote · Statele Unite ale Americii 🇺🇸
Patient Access Specialist
Ensemble RCM LLC Topeka, Kansas, Statele Unite ale Americii🇺🇸
Pharmacy Technician ( Nuclear Pharmacy )
Cardinal Health San Diego, Калифорния, Statele Unite ale Americii🇺🇸
Clinical Nurse Manager
Roswell Park Comprehensive Cancer Center Statele Unite ale Americii 🇺🇸
Nurse II - (Full Time/First Shift -Temporary-Benefited) Pre-operative Anesthesia Clinic (APEC)
Roswell Park Comprehensive Cancer Center Statele Unite ale Americii 🇺🇸
Operator - FG, Stamper, DC -ASC
Amcor Peachtree City, Georgia, Statele Unite ale Americii🇺🇸
Engineer 2, Engineering Services
LUMA Energy Statele Unite ale Americii 🇺🇸
Smart Course - Associate (Remote)
tazapay Remote · Statele Unite ale Americii 🇺🇸
Smart Course - Internship (Remote)
tazapay Remote · Statele Unite ale Americii 🇺🇸