نُشرت منذ أسبوعين

Snowflake Data Architect

Datavail
عن بُعد · الولايات المتحدة 🇺🇸
  • عن بُعد
  • دوام كامل
  • Snowflake
  • SQL

وصف الوظيفة

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

Senior Data Architect

Datavail عن بُعد · الولايات المتحدة 🇺🇸

عن بُعد دوام كامل منذ 3 أسابيع

وظائف أخرى في الولايات المتحدة

SEO Director

upgrow الولايات المتحدة 🇺🇸

دوام كامل منذ 31 دقيقة

Learning Services Jobs

uniformjunction عن بُعد · الولايات المتحدة 🇺🇸

عن بُعد دوام كامل منذ 32 دقيقة

Technology / Engineering Jobs

uniformjunction عن بُعد · الولايات المتحدة 🇺🇸

عن بُعد دوام كامل منذ 32 دقيقة

Operations Intern

umba الولايات المتحدة 🇺🇸

دوام كامل منذ 32 دقيقة

Machine Learning Lead

umba الولايات المتحدة 🇺🇸

دوام كامل منذ 32 دقيقة

BD/Sales Associate (Remote)

ultrade عن بُعد · الولايات المتحدة 🇺🇸

عن بُعد دوام كامل منذ 33 دقيقة

Barista

xandercoffee الولايات المتحدة 🇺🇸

دوام جزئي منذ 15 دقيقة

Director of Marketing

wjdexclusives الولايات المتحدة 🇺🇸

دوام كامل منذ 16 دقيقة

Sales Manager

wishforyellow الولايات المتحدة 🇺🇸

دوام كامل منذ 16 دقيقة

Team Supervisor

webhostingnorthwest الولايات المتحدة 🇺🇸

دوام كامل منذ 19 دقيقة

المزيد من الوظائف عن بُعد في الولايات المتحدة