Senior Snowflake Engineer
Core
Build, optimize, and maintain robust data transformations and warehouse models in Snowflake for healthcare clients, focusing on member identity matching, payer attribution, and data reconciliation.
Role type
Senior Snowflake Data Engineer
Builds
Production-ready data models, dimensional models, and automated data-quality checks for healthcare analytics platforms
Domain
Healthcare data management and analytics
Deliverable
production ML models
Required skills
Snowflake SQL, dimensional modeling, SCD Type 2, source-to-target mapping, data quality validation, Git version control, query optimization, error handling
Preferred skills
Healthcare payer/provider data experience, Master Patient Index (MPI) knowledge, member identity resolution
Technologies
Snowflake, SQL, Git
Responsibilities
Build and optimize Snowflake SQL transformations across staging, curated, and conformed layers; Implement patient/member identity matching and payer attribution logic; Develop dimensional models with facts, dimensions, and surrogate keys; Automate data-quality checks and audit logging; Troubleshoot production issues and optimize query performance; Maintain technical documentation and participate in code reviews
Seniority
Senior, hands-on IC