SnowFlake Architect

Job Position: Epic/Snowflake Architect Duration 6-12 months + extensions. Location: Remote Role
Please see the updated notes below for the Data Architect position. The big difference to note here is that they need candidates who have experience with Claims Data on the provider side.

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.

How This Differs from Previous Work

• Prior initiatives were focused on building the foundation, data ingestion, and platform enablement.
• Current need is for someone who can build analytics products on top of claims data while serving as a subject matter expert for Population Health, Risk Adjustment, and Value-Based Care initiatives.
• Greater emphasis on healthcare domain expertise than pure engineering capability.

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.