Snowflake Architect

Position: Epic/Snowflake Architect

Duration 6-12 months + extensions.

Project Overview

• Over the past year, the team rebuilt its data foundation and successfully integrated Milliman MedInsight data.
• Focus is now shifting from foundational data movement to developing new Population Health data products and analytics capabilities.
• Team has identified an opportunity to accelerate delivery but lacks the healthcare provider claims expertise needed to scale effectively.
• Resource will either support a newly forming third product team or integrate into the existing Population Health team..

Key Responsibilities

• Design, build, and enhance Population Health data products using Snowflake, dbt, and healthcare claims data.
• Develop solutions leveraging the Milliman MedInsight Transport Database.
• Build population cohorts supporting risk contracts, outcomes measurement, care gap identification, and performance improvement initiatives.
• Partner with stakeholders, analysts, and product teams to translate business requirements into scalable data solutions.
• Serve as the team's healthcare provider claims SME and help establish best practices for future growth.

Required Experience

• Senior/Architect-level data engineering experience.
• Deep provider-side healthcare claims analytics expertise.
• Strong understanding of Population Health, Risk Adjustment, Risk Capture, Quality Measures (HEDIS, Stars), Cost & Utilization Analytics, and Value-Based Care programs.
• Experience designing and building solutions in Snowflake.
• Strong dbt experience including reusable models, testing frameworks, transformations, and data pipelines.
• Strong data modeling background.

Preferred Experience

• Milliman MedInsight experience, particularly the Transport Database.
• Understanding of Milliman data structures, claims models, and Population Health use cases.
• Team is willing to consider candidates with more modern tooling backgrounds if they possess deep provider claims expertise and are open to working within MGB's Snowflake/dbt environment.

Why Current Team Needs Support

• Existing resources have strong technical and organizational knowledge but lack the level of healthcare provider claims expertise needed for upcoming initiatives.
• Team is looking for a true SME who can elevate the organization's knowledge while helping accelerate product delivery.