Pubblicata 1 settimana fa
Snowflake Data Architect
Datavail
Da remoto · Stati Uniti 🇺🇸
- Da remoto
- Tempo pieno
- Snowflake
- SQL
Descrizione dell’offerta
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.
Altre offerte di Datavail
Altre offerte: Stati Uniti
Warehouse Associate - 1st Shift - TIR
tk accelis, Inc. Acworth, Georgia, Stati Uniti🇺🇸
In sede Tempo pieno 3 ore fa
TTT - Liaison
thyssenkrupp Supply Chain Services NA, Inc. Stati Uniti 🇺🇸
In sede Tempo pieno 3 ore fa
Solutions Design Intern
thyssenkrupp Supply Chain Services NA, Inc. Michigan, Stati Uniti🇺🇸
Ibrido StagePart-time 3 ore fa
Lead IT Coordinator
AmeriPharma Orange, California, Stati Uniti🇺🇸
In sede Tempo pieno $30 to $40 Hourly, DOE 3 ore fa
Inside Apparatus Electrical Salesperson
Scott Electric Company Youngwood, Pennsylvania, Stati Uniti🇺🇸
In sede Tempo pieno 3 ore fa
Part-Time Teller, Student Position- Highland Branch
Mid Hudson Valley Federal Credit Union Highland, New York, Stati Uniti🇺🇸
In sede $18.50 per hour. The salary offered will be dependent upon candidate's relevant & job-related skills, work experience, and education/training. 3 ore fa
Electronic Flight Bag / Electronic Knee Board (EFB/EKB) Manager
LMR Technical Group Georgia, Stati Uniti🇺🇸
In sede Tempo pieno 3 ore fa
Standardization and Evaluation Administrative Program Assistant (SEAA)
LMR Technical Group Georgia, Stati Uniti🇺🇸
In sede Tempo pieno 3 ore fa