Slået op for 1 uge siden
Snowflake Data Architect
Datavail
Fjernarbejde · USA 🇺🇸
- Fjernarbejde
- Fuldtid
- Snowflake
- SQL
Jobbeskrivelse
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.
Flere job hos Datavail
Andre job i USA
Warehouse Associate - 1st Shift - TIR
tk accelis, Inc. Acworth, Georgia, USA🇺🇸
På arbejdspladsen Fuldtid for 2 timer siden
TTT - Liaison
thyssenkrupp Supply Chain Services NA, Inc. USA 🇺🇸
På arbejdspladsen Fuldtid for 2 timer siden
Solutions Design Intern
thyssenkrupp Supply Chain Services NA, Inc. Michigan, USA🇺🇸
Hybrid PraktikDeltid for 2 timer siden
Sr. Superintendent
Satterfield & Pontikes Dallas, Texas, USA🇺🇸
På arbejdspladsen Fuldtid for 2 timer siden
Lead IT Coordinator
AmeriPharma Orange, Californien, USA🇺🇸
På arbejdspladsen Fuldtid $30 to $40 Hourly, DOE for 2 timer siden
Inside Apparatus Electrical Salesperson
Scott Electric Company Youngwood, Pennsylvania, USA🇺🇸
På arbejdspladsen Fuldtid for 2 timer siden
Part-Time Teller, Student Position- Highland Branch
Mid Hudson Valley Federal Credit Union Highland, New York, USA🇺🇸
På arbejdspladsen $18.50 per hour. The salary offered will be dependent upon candidate's relevant & job-related skills, work experience, and education/training. for 2 timer siden
Electronic Flight Bag / Electronic Knee Board (EFB/EKB) Manager
LMR Technical Group Georgia, USA🇺🇸
På arbejdspladsen Fuldtid for 2 timer siden
Standardization and Evaluation Administrative Program Assistant (SEAA)
LMR Technical Group Georgia, USA🇺🇸
På arbejdspladsen Fuldtid for 2 timer siden