Senior Snowflake Engineer

Datavail

United States

Teletrabalho

USD 140 000 - 190 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 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

Qualificações

  • 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.

Responsabilidades

  • 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.

Conhecimentos

Data engineering
Analytics engineering
Production troubleshooting

Ferramentas

Snowflake
SQL
Git
ETL

Descrição da oferta de emprego

Title: Senior Snowflake Engineer

Location: Remote

Duration: 3 Month

Job 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.
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

Snowflake Data Architect
Snowflake Data Architect

Datavail • EUA

Teletrabalho
USD 150 000 - 180 000
Senior Snowflake Engineer
Senior Snowflake Engineer

Jobgether • EUA

Teletrabalho
USD 150 000 - 210 000
Remote work within US
3-month contract
Key Skills: Senior Snowflake Engineer
Key Skills: Senior Snowflake Engineer

Datavail • Boulder (CO)

Teletrabalho
USD 120 000 - 180 000
Remote Senior Snowflake Engineer (3-Month)
Remote Senior Snowflake Engineer (3-Month)

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
Senior Snowflake Engineer
Senior Snowflake Engineer

Datavail Infotech • EUA

Teletrabalho
USD 130 000 - 190 000
Senior Snowflake Developer
Senior Snowflake Developer

Narvee Tech Inc • Snowflake (AZ)

Híbrido
USD 90 000 - 130 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 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