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 Required
- 7+ years of experience in data engineering, data warehousing, or analytics engineering with recent Snowflake delivery
- Advanced Snowflake SQL, layered transformations, query tuning, and production troubleshooting
- Strong dimensional modeling experience, including facts, dimensions, surrogate keys, and SCD Type 2
- Experience with source-to-target mappings, complex business rules, incremental processing, and reconciliation
- Hands-on experience with data-quality checks, audit and control logging, error handling, Git, testing, and deployment
- Healthcare payer/provider, MPI, or member identity experience
- Experience implementing patient/member matching logic, crosswalks, and duplicate or unmatched record handling
- Experience implementing payer attribution across plans, provider networks, PCPs, and clinics with monthly history
- Experience building audit, balance, control logging, metrics, alerting, and reconciliation evidence
Datavail Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Datavail and has not been reviewed or approved by Datavail.
-
Fair & Transparent Compensation — Pay is considered competitive for many roles at the time of hire, with some noting significant initial increases and timely pay. Feedback suggests compensation can be strong in particular regions or positions even as overall satisfaction varies.
-
Wellbeing & Lifestyle Benefits — Remote-friendly roles and flexible or unlimited time off policies are highlighted as part of the employment experience. Feedback suggests these arrangements support work flexibility, though experiences differ by team and location.
Datavail Insights
What We Do
A premiere data services company serving clients in North America, Datavail has 1,000 data professionals, data engineers, developers, project managers, consultants, and business experts, supported by industry-leading automation and intellectual property. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes. At Datavail, we look for more than smarts, experience and proficiency. On top of those requirements, we seek people who mesh with our corporate values. We seek brilliance without bravado and know-how without a know-it-all attitude. We hold low ego in high regard, embrace problem-solving as a passion and welcome every day as a new opportunity to learn. We’re flexible and hard working. We’re committed to our clients and colleagues. We help our people grow so they can help our clients grow. That makes us grow so we can help even more customers leverage organizational data for business value. Our Core Values: 1. We desire to serve. 2. We embody flexibility for availability 3. We exemplify low ego. 4. We work hard. 5. We strive for continuous improvement. 6. We are growth-oriented.
