Data Architect - Snowflake

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.

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.

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.