Remote Senior Snowflake Engineer (3-Month)

Datavail

United States

Remote

USD 140,000 - 190,000

Full time

9 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Datavail is seeking a Senior Snowflake Engineer to work remotely in the United States. The role focuses on delivering robust Snowflake-based data pipelines, advanced SQL, and dimensional modeling within a healthcare data context.

You will build restartable transformations, implement SCD Type 2 histories, and ensure data quality through audits and automated validations. Ideal candidates have 7+ years in data engineering or analytics engineering, deep Snowflake expertise, and experience with

Qualifications

  • 7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery.
  • Advanced Snowflake SQL, layered transformations, query tuning and production troubleshooting.
  • Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2.
  • Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.
  • Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment.
  • Healthcare payer/provider, MPI or member identity experience preferred.
  • Build and optimize Snowflake SQL transformations across staging, curated and conformed layers.
  • Implement tables, views and transformation logic from approved models and source-to-target mappings.
  • Develop restartable, testable and supportable processing with auditability and error handling.
  • Implement patient/member matching logic, crosswalks and exceptions for duplicate, unmatched or conflicting records.
  • Build SCD Type 2 history, member-month outputs and current-state models.
  • Implement payer attribution across payer/plan, provider networks, PCPs and clinics and preserve monthly history.
  • Reconcile modeled attribution to source rosters and retain discrepancies and unassigned members.
  • Automate row-count, null, datatype, referential-integrity and schema-drift checks.
  • Build audit, balance and control logging, metrics, alerting and reconciliation evidence.
  • Troubleshoot defects, maintain technical documentation and participate in reviews, planning and client demonstrations.

Responsibilities

  • 7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery.
  • Advanced Snowflake SQL, layered transformations, query tuning and production troubleshooting.
  • Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2.
  • Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.
  • Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment.
  • Healthcare payer/provider, MPI or member identity experience preferred.
  • Build and optimize Snowflake SQL transformations across staging, curated and conformed layers.
  • Implement tables, views and transformation logic from approved models and source-to-target mappings.
  • Develop restartable, testable and supportable processing with auditability and error handling.
  • Implement patient/member matching logic, crosswalks and exceptions for duplicate, unmatched or conflicting records.
  • Build SCD Type 2 history, member-month outputs and current-state models.
  • Implement payer attribution across payer/plan, provider networks, PCPs and clinics and preserve monthly history.
  • Reconcile modeled attribution to source rosters and retain discrepancies and unassigned members.
  • Automate row-count, null, datatype, referential-integrity and schema-drift checks.
  • Build audit, balance and control logging, metrics, alerting and reconciliation evidence.
  • Troubleshoot defects, maintain technical documentation and participate in reviews, planning and client demonstrations.

Skills

Data engineering
Analytics engineering
Production troubleshooting

Tools

Snowflake
SQL
Git
ETL

Job description

Datavail is seeking a Senior Snowflake Engineer to work remotely in the United States. The role focuses on delivering robust Snowflake-based data pipelines, advanced SQL, and dimensional modeling within a healthcare data context.

You will build restartable transformations, implement SCD Type 2 histories, and ensure data quality through audits and automated validations. Ideal candidates have 7+ years in data engineering or analytics engineering, deep Snowflake expertise, and experience with

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Senior Snowflake Engineer | Data & Analytics
Remote Senior Snowflake Engineer | Data & Analytics

Datavail • Boulder (CO)

Remote
USD 120,000 - 180,000
Remote Senior Snowflake Architect — Healthcare Identity
Remote Senior Snowflake Architect — Healthcare Identity

Datavail • United States

Remote
USD 150,000 - 180,000
Key Skills: Senior Snowflake Engineer
Key Skills: Senior Snowflake Engineer

Datavail • Boulder (CO)

Remote
USD 120,000 - 180,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Datavail Infotech • United States

Remote
USD 130,000 - 190,000
Senior Snowflake Data Engineer (Remote)
Senior Snowflake Data Engineer (Remote)

Datavail Infotech • United States

Remote
USD 130,000 - 190,000
Key Skills: Senior Snowflake Data Architect
Key Skills: Senior Snowflake Data Architect

Datavail • Boulder (CO)

Remote
USD 170,000 - 240,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Datavail • United States

Remote
USD 140,000 - 190,000
Senior Snowflake Data Architect — Remote & Influential Lead
Senior Snowflake Data Architect — Remote & Influential Lead

Datavail Infotech • United States

Remote
USD 140,000 - 190,000
Snowflake Data Architect
Snowflake Data Architect

Datavail Infotech • United States

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

Datavail • Boulder (CO)

Remote
USD 170,000 - 240,000