Enter a job title or keyword

Senior Snowflake Engineer

Datavail Infotech


Job Location:

Boulder, CO - USA

Monthly Salary: Not provided by the employer
Posted: 14 November 2026 (5 days ago)
Application Deadline: 11 February 2027
Vacancies: 1 Vacancy

Job Summary

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.




Required Experience:

Senior IC


About Company

Company Logo

Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leadi ... View more

View Profile View Profile