Senior Snowflake Engineer
Cloud, Data, and Application Experts
Remote · Anywhere USA, United States · Posted November 7, 2026
Just laid off? Start here: a plan for the first weeks
See every open role at Cloud, Data, and Application Experts
More in Technology & Software · Engineering jobs
More roles at Cloud, Data, and Application Experts
Similar jobs
Engineering jobs in the rankings
Rankings about engineering jobs
- Best cities for software and engineering jobs #1 San Francisco (3,412 openings)
- Best cities for engineering pay after cost of living #1 San Mateo ($216k)
- Most requested AI skills in engineering jobs #1 AI tools in daily work (6.1%)
- AI tools named most often in engineering jobs #1 Claude (1.7%)
- Employers with the most engineering jobs #1 Amazon (2,992 roles)
Skills this job asks for
Say which you have and which you want to build. We use it to match you to jobs like this one.
About the job
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.
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 leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.