Data Engineer jobs

Snowflake Data Architect

DatavailRemote · US onlyContract10+ years experiencePosted 14 days ago

Pay not listed

Looks real. 1 thing to check before you apply.

On Datavail’s own careers site (Oracle Recruiting), checked open today.

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteOracle Recruiting board
  • Checked: Checked open todayOracle Recruiting board
  • Checked: No reposts foundOracle Recruiting board
  • Trust score 89 / 100 · Looks good
See all 5 checksShow fewer
How we check

What you’ll do

  • Own Snowflake architecture and define staging, curated and conformed-layer patterns and standards.
  • Translate requirements into logical and physical designs, and lead patient/member dimensional, historical, identity, payer attribution and temporal modeling.
  • Define data quality, reconciliation, schema, integrity, exception and alerting controls; establish lineage, testing, logging and runbook standards.
  • Protect sensitive healthcare data and support client security and compliance requirements.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 10+ years in data engineering, warehousing or analytics
  • 5+ years as a data or solution architect
  • Deep hands-on Snowflake architecture experience
  • Experience with member identity, crosswalk/entity-resolution models and client-defined matching logic
  • Client-facing leadership experience
  • Healthcare payer/provider experience (preferred)
  • MPI experience (preferred)

Skills

  • Advanced SQL experience
  • Expert dimensional modeling, including star schemas, conformed dimensions, surrogate keys and SCD Type 2
  • Strong data quality, reconciliation, audit/control logging, exception handling, lineage and documentation skills

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Datavail’s careers site

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.
Show full descriptionShow less
  • 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.

Something wrong with this job? Report it · This flag looks wrong

Similar remote jobs

Data and AI Architect

Ascend Technologies · Remote · US only

$140k/yrFull-time

StrongChecked open todayPosted 17 days ago

Senior Data Engineer

Vericast · Remote · US only

$130k–$150k/yrFull-time

StrongChecked open todayPosted yesterday

Data Engineer

Mindex · Remote · US only

$90k–$140k/yrFull-time

StrongChecked open todayPosted 7 days ago

Data Integration Engineer

D.A. Davidson · Remote · US only

$74k–$106k/yrFull-time

StrongChecked open todayPosted 10 days ago

Principal Data Engineer

Constant Contact · Remote · US, Canada

$138k–$172k/yrFull-time

StrongChecked open todayPosted 11 days ago

See more like this