
Case study 02 · Healthcare Data
Turning legacy health records into data products
The challenge
An innovative health-data company holds legacy health records for health systems at multi-petabyte scale. The opportunity was to turn those records into de-identified data products for registries, quality measures and life-sciences research. The challenge was that the data came from dozens of EHR vendors, each with thousands of tables and no common language.
Our approach
We built a secure, HITRUST-aligned cloud foundation, then an automated pipeline that takes each source system, maps it to a FHIR-based canonical model and produces analytics-ready tables.
To speed up the hardest part, mapping thousands of source columns, we combined a rules engine with AI classification and a human review loop, so experts confirm the AI instead of starting from scratch.
Where our experience mattered
- Architected a secure, HITRUST-aligned data platform
- Designed a pipeline mapping dozens of EHR systems to one model
- Applied AI with human review to accelerate data mapping
- Built patient privacy protection in from the start
- Embedded our team alongside the client to lead technical delivery
Outcome
A repeatable path from raw health records to research-ready data, across dozens of EHR systems.
Next case study
Rescuing and rebuilding an AI platform →