Senior Snowflake Engineer
About The Position
The Senior Snowflake Engineer builds and optimizes Snowflake SQL transformations across staging, curated, and conformed data layers. The role implements tables, views, and transformation logic based on approved models and source-to-target mappings, and develops processing that is restartable, testable, supportable, auditable, and equipped with error handling. The engineer implements patient/member matching logic, crosswalks, and exceptions for duplicate, unmatched, or conflicting records. The role also builds Type 2 history, member-month outputs, current-state models, and payer attribution across payer/plan, provider networks, PCPs, and clinics while preserving monthly history. Attribution is reconciled to source rosters, with discrepancies and unassigned members retained. The position automates data-quality checks and builds audit, balance, and control logging, metrics, alerting, and reconciliation evidence. It includes troubleshooting defects, maintaining technical documentation, and participating in reviews, planning, and client demonstrations. The role is remote and has a stated duration of three months.
Requirements
- 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.
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 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, 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
