Snowflake Architect -Epic/Claims

Epic/Snowflake Architect

100% Remote

6-12 months + extensions.

MUST HAVE CLAIMS DATA ON THE PROVIDER SIDE. Need Expert level.

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.