Datavail

Senior Snowflake Engineer

  • Anywhere USA, United States
  • Remote
  • full time
  • Posted 13 days ago
Apply on Datavail's site ↗Checked today on the employer's career site. We never take applications.

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.