caferemote
Datavail

Senior Snowflake Engineer

Remote United States Full-time Senior Posted 11 days ago
Apply now
Work from
United States
Contract
Full-time
Experience
Senior
Posted
9 November 2026
Apply by
8 January 2027

Title: Senior Snowflake Engineer

Location: Remote

Duration: 3 Month

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.

Discussion

No comments yet. Ask a question or share a tip about this role.

Apply now

More jobs from Datavail

View company →

NetSuite Consultant

Datavail
Remote India Full-time

Title: Senior Consultant - NetSuite Location: Hyderabad/Mumbai/Bangalore Education: Bachelors Exp Leve: 8+ Years Key Responsibilities: 1) 6+ years in NetSuit…

8 days ago Software Development

Peoplesoft Security Admin

Datavail
Remote India Contract

Title: Peoplesoft Security Admin Location: Remote Duration: 3 Months Jobs Description: Assess the security configuration of Client’s PeopleSoft application…

8 days ago All Other Remote

Snowflake Data Architect

Datavail
Remote United States Contract

Title: Senior Snowflake Data Architect Location: Remote Duration: 3 Month Job Description: 10+ years in data engineering, warehousing or analytics, including…

11 days ago Data

Similar remote jobs

Browse all →

AI Safety Expert - Bilingual

mercor
Remote United States Contract $17 – $25 / hour

About the job Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter…

1h ago Data

Senior AI & Transformation Enablement Specialist

Datasite
Remote United States Full-time $83K – $141K / year

About us Datasite is the essential infrastructure for M&A. Also comprising Grata, Blueflame AI, and Sherpany, we help dealbreakers find opportunities, manage transactions, and make key…

2h ago Data

Business Analyst III Claims, DRG

Centene Corporation
Remote United States Full-time $70K – $126K / year

Position Purpose: Perform various analysis and interpretation to link business needs and objectives for assigned function. Key Details: Must be authorized to work in the U.S. without the…

2h ago Data

Functional Consultant – Epicor Kinetic (Operations & Supply Chain) – 100% Remote

TeccWeb
Remote United States Full-time

About Teccweb Teccweb is an Epicor Service Partner specializing in the implementation and optimization of Epicor Kinetic for mid-market manufacturers and distributors across North America.…

2h ago Data

Product Owner

Dev Partners
Remote Philippines Full-time

💻 We Are Hiring- Product Owner | 100% Remote We are seeking an experienced Product Owner to oversee and coordinate the ongoing maintenance, enhancement, and continuous improvement of an…

2h ago Data

Mechanical Engineer III

DLB Associates
Remote United States Full-time $105K – $135K / year

DLB Associates is a premier engineering and consulting firm specializing in innovative, mission-critical solutions across hyperscale data centers, advanced infrastructure, and…

3h ago Data

Get remote jobs the moment they are posted

Choose your categories and skills. We push matching jobs to your device. No email, ever.