Haystack
← Back to Jobs
Technology

Healthcare Data Architect / Snowflake Architect (MedInsight)

Tech Tandem IncUnited States🇺🇸United StatesPosted 14 Aug 2026

Quick Overview

Work Type
Hybrid
Level
Mid Senior

Job Description

Job Description:
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.

Skills

Snowflake
dbt

Similar jobs