Posted 10 days ago
Senior Snowflake Engineer
AI Summary
Builds and optimizes Snowflake SQL transformations and dimensional models, including SCD Type 2 history, member matching and payer attribution, with data-quality checks and audit logging for a healthcare client on a remote 3-month contract.
About this role
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.
Skills
Explore related jobs
More jobs at Datavail
Similar Snowflake jobs
- P
Army Audit Readiness Program (AARP) Logistics (Log) Analyst (Contingent)ProSidian Consulting, LLC · Fort Bragg, NC - R
Technical Library Clerk Junior (DTA)Resource Management Concepts, Inc. · Patuxent, MD - BSystems AdministratorBart & Associates · Huntsville, Alabama
- K
Senior Security Engineer, Data SecurityKikoff · San Francisco - S
Platform Engineer, APIs & ObservabilityStackAI · Poland - Warsaw Office - MSenior Cloud / Data Engineer (Data / Reconstruction / HIPAA)Midjourney · San Francisco
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.