Posted 1 week ago

Senior Snowflake Engineer

Datavail
Remote · United States 🇺🇸
  • Remote
  • Full Time
  • Snowflake
  • SQL

Job description

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.

Other jobs in United States

Maintenance Technician

LyvWell Apartments LLC Los Angeles, California, United States🇺🇸

Full Time 1 hour ago

Porter

LyvWell Apartments LLC Charlotte, North Carolina, United States🇺🇸

Full Time 1 hour ago

Teller

First PREMIER Sioux Falls, South Dakota, United States🇺🇸

Onsite Full Time 1 hour ago

More remote jobs in the United States