- Remote, United States
- Remote
- Full-time · Senior
- 7+ years
Join a data management and analytics team delivering modern data solutions for clients across a range of industries. As a Senior Snowflake Engineer, you will play a key role in building, optimizing, and maintaining robust data transformations and warehouse models using Snowflake.
Responsibilities
- Build, develop, and optimize Snowflake SQL transformations across staging, curated, and conformed data layers
- Implement tables, views, and transformation logic based on approved data models and source-to-target mappings
- Develop restartable, testable, and maintainable data processing workflows with robust auditability and error handling
- Implement patient and member identity matching logic, crosswalks, and exception handling for duplicate, unmatched, or conflicting records
- Build and maintain dimensional models, including facts, dimensions, surrogate keys, and Slowly Changing Dimension Type 2 (SCD Type 2) history
Requirements
- Nice to have: Healthcare payer data experience
- Nice to have: Master Patient Index (MPI)
- Nice to have: Member identity resolution
