Senior Snowflake Engineer
At a glance
Senior Data Engineering role at Datavail Career Site. Remote, United States · full-time · no salary stated · we estimate $142,400–$194,000 across the United States.
Datavail Career Site has not published a salary for this role. The figure below is our estimate, not theirs.
remoteroles summary, based on the employer's posting.
What you'll do
- Build and tune Snowflake transformations through staging, curated and conformed data layers
- Turn approved models and source mappings into tables, views and transformation logic
- Create restartable processing with audit trails, error handling and tests, including member matching and SCD Type 2 history
- Model payer attribution and monthly history, then reconcile results against source rosters
- Automate data-quality checks and control logging; troubleshoot defects and document technical decisions
What you bring
- At least seven years in data engineering, warehousing or analytics engineering, with recent Snowflake delivery
- Advanced Snowflake SQL skills, including layered transformations, query tuning and production issue resolution
- Hands-on dimensional modeling, source-to-target mapping, incremental processing, reconciliation, testing and deployment
- Experience with Git and data-quality checks, audit logging and error handling
Who this fits
This senior role suits an engineer who can deliver Snowflake data models and processing end to end, then support troubleshooting and client demonstrations. The role is remote in the United States and has a three-month duration.
From the employer
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.