The brief
Design and build a comprehensive employer health plan analytics platform enabling health plan administrators and benefits consultants to monitor member spending, identify clinical risk, manage contracts, and surface actionable AI-powered insights — starting with product discovery and UX design in early 2024 before transitioning to core data engineering in 2025.
What we built
A dual-layer health analytics platform for employer-sponsored health plans. Layer 1 (UX/Product): High-fidelity designs for onboarding, workflow management, playbooks, contract AIQ, document comparison, risk register, and an experience/insights screen — delivered across two design phases (early 2024 and early 2025). Layer 2 (Data Engineering): A production FHIR→OMOP ingestion and transformation pipeline for multiple employer groups (Hero Health, DCC, and others), feeding a claims analysis engine (surge, emerging, top spending), a 19+-KPI clinical/financial library (including NYU-ED algorithm), a 6-dimension patient cohort engine (diseases, procedures, drugs, demographics, facilities, providers), and a MongoDB-backed insights schema — all deployed across dev and prod VMs with automated batch orchestration, pre-commit code quality hooks, uv-managed Python environments, and Drata compliance controls.



