Unified Patient Data Platform for a Regional Health System
The challenge
A Pacific Northwest health system was operating with 14 disconnected data sources — EHR, billing, scheduling, lab, and pharmacy — making it impossible to get a unified view of patient outcomes or operational performance.
Our solution
We designed and built a cloud-native data warehouse on Snowflake, implementing a medallion architecture (bronze/silver/gold) with automated ELT pipelines via dbt. A unified patient 360 model was delivered alongside role-based Power BI dashboards for clinical and operational teams.
Results