Snowflake Data Architect

Datavail

United States

Teletrabalho

USD 150 000 - 180 000

Tempo integral

Há 9 dias

Uma candidatura completa num minuto

Currículo e carta de apresentação personalizados, prontos a enviar.

Ultrapassa os filtros ATS

Resumo da oferta

Datavail is seeking a Senior Snowflake Data Architect for a remote, 3-month engagement. You will own Snowflake architecture, staging, curated and conformed-layer patterns, and translate business requirements into actionable designs for engineering delivery.

Ideal candidates have 10+ years in data engineering or analytics, 5+ years as an architect, and deep Snowflake and SQL expertise. Experience with dimensional modeling (star schemas, SCD Type 2) and MPI identity logic is preferred, especially

Qualificações

  • 10+ years in data engineering/analytics
  • 5+ years as data/solution architect
  • Healthcare payer/provider experience preferred

Responsabilidades

  • Own Snowflake architecture and define staging, curated and conformed-layer patterns.
  • 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 MPI logic.
  • Design payer attribution, member-month and temporal models across payer/plan, networks 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.

Conhecimentos

Snowflake architecture
Advanced SQL
Dimensional modeling
SCD Type 2
Data quality
Client-facing leadership

Descrição da oferta de emprego

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.
Obtém a tua avaliação gratuita e confidencial do currículo.

ou arrasta e larga o ficheiro aqui.

Similar jobs

Ofertas semelhantes que vale a pena comparar

Senior Snowflake Engineer
Senior Snowflake Engineer

Datavail • EUA

Teletrabalho
USD 140 000 - 190 000
Key Skills: Senior Snowflake Data Architect
Key Skills: Senior Snowflake Data Architect

Datavail • Boulder (CO)

Teletrabalho
USD 170 000 - 240 000
Snowflake Data Architect
Snowflake Data Architect

Datavail Infotech • EUA

Teletrabalho
USD 140 000 - 190 000
Remote Senior Snowflake Architect — Healthcare Identity
Remote Senior Snowflake Architect — Healthcare Identity

Datavail • EUA

Teletrabalho
USD 150 000 - 180 000
Senior Snowflake Data Architect — Remote & Influential Lead
Senior Snowflake Data Architect — Remote & Influential Lead

Datavail Infotech • EUA

Teletrabalho
USD 140 000 - 190 000
Snowflake Architect
Snowflake Architect

5 Star Recruitment • Dallas (TX)

Presencial
USD 130 000 - 160 000
Senior Snowflake Engineer
Senior Snowflake Engineer

Jobgether • EUA

Teletrabalho
USD 150 000 - 210 000
Remote work within US
3-month contract
Data Architect – Job Description
Data Architect – Job Description

Executive Staff Recruiters / ESR Healthcare • EUA

Teletrabalho
USD 140 000 - 190 000
Senior Snowflake Data Architect - Remote Data & DW Leader
Senior Snowflake Data Architect - Remote Data & DW Leader

Datavail • Boulder (CO)

Teletrabalho
USD 170 000 - 240 000
Snowflake Architect
Snowflake Architect

Aroha Technologies, Inc • Raritan (NJ)

Híbrido
USD 96 000 - 165 000