Senior Snowflake Engineer
About The Position
Datavail is seeking a Senior Snowflake Engineer to build and optimize Snowflake data transformations and models, particularly for healthcare payer/provider data and member identity use cases. The role works with staging, curated, and conformed data layers, implementing tables, views, and transformation logic based on approved models and source-to-target mappings. The engineer will develop restartable, testable, supportable, and auditable data processing, including patient/member matching, crosswalks, exception handling, SCD Type 2 history, member-month outputs, and current-state models. The position also implements payer attribution across plans, provider networks, PCPs, and clinics, preserves monthly history, and reconciles attribution against source rosters while retaining discrepancies and unassigned members. The role includes automating data-quality checks and building audit, balance, and control logging, metrics, alerting, and reconciliation evidence. The engineer will troubleshoot defects, maintain technical documentation, and participate in reviews, planning, and client demonstrations. The position is remote and has a stated duration of three months.
Requirements
- At least 7 years of experience in data engineering, data warehousing, or analytics engineering, with strong recent Snowflake delivery.
- Advanced Snowflake SQL skills, including layered transformations, query tuning, and production troubleshooting.
- Experience implementing dimensional models, 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/control logging, error handling, Git, testing, and deployment.
Nice To Haves
- Healthcare payer/provider, MPI, or member identity experience.
Responsibilities
- 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, supportable processing with auditability and error handling.
- Implement patient/member matching logic, crosswalks, and exception handling 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 while preserving 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 and maintain technical documentation.
- Participate in reviews, planning, and client demonstrations.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
