Building an Enterprise Data Platform from the Ground Up for a Post-Acute Care Organisation

Building an Enterprise Data Platform from the Ground Up for a Post-Acute Care Organisation

Client Overview

  • 40+

    years in operation

  • 600+

    Patients in active care daily

  • 10/10

    Hospice index score achieved

INDUSTRY

  • Healthcare/ Hospice and Palliative Care

TECH STACK

  • Data Platform
    • Snowflake (EDW)
    • Azure ADF
    • dbt
  • Analytics & Reporting
    • Power BI
  • Automation & Identity Resolution
    • Python
    • Master Patient Index framework

Executive Summary

Multiple disconnected systems including some EMRs, a patient triaging platform, a state HIE, and HR data, operated with no shared model between them, leaving the data engineering team stretched across everything at once. Inferenz built a unified Enterprise Data Warehouse on Snowflake, created a Master Patient Index resolving patient identities across EMRs, and delivered 7 KPI dashboards across clinical, operational, and business domains. Leadership recovered 2 hours daily from manual spreadsheet audits, and the organization now has an AI-ready data foundation it can build on.

Challenges

The organization’s entire data operation ran on limited resources managing disconnected systems with no shared model, unable to support the analytics and AI capabilities leadership needed.

01

Limited resources, unlimited demands.

Schema design, integration, dashboards, and data quality all competed for the same limited bandwidth of engineering team, across separate source systems. Every request or incident pulled focus from strategic work.

02

Disparate systems, no shared view

The EMRs, a triaging platform, a state HIE, and HR data operated independently. Cross-functional analysis required manual consolidation from scratch every time.

03

Reporting Built on Manual Spreadsheet Audits

Leadership reporting was compiled manually before every meeting. The Business Development review alone consumed 2 hours daily before any strategic discussion could begin.

04

No Foundation for AI or Quality Programs

Care gap detection, automated alerts, and patient safety monitoring were on the roadmap but structurally blocked. The data existed across multiple systems. It could not be used.

Our Solution

Inferenz developed a unified Enterprise Data Warehouse on Snowflake integrating multiple EMRs, the triaging system, the state HIE, and HR data into one governed repository. Here’s what they did:

Real-time ADF pipeline migration

Azure ADF pipelines replaced fragmented manual extracts with real-time, documented data flows.

Master patient index resolution

A Master Patient Index resolved conflicting identities across multiple EMRs, creating a single clinical record per patient the prerequisite for safety monitoring, care gap detection, and quality benchmarking.

KPI dashboards across 7 domains

KPI dashboards were built across 7 domains: patient safety, quality of care, business development, revenue, and more, replacing the daily 2-hour spreadsheet audit with a live, automated view.

Automated data quality and alerting

Real-time data quality checks and automated alerting replaced reactive, engineer-dependent quality management.

Extensible platform architecture

The platform was architected for extensibility: new EMRs, service lines, or acquired entities onboard without rebuilding the foundation.

Impact Delivered

1.5+ Years

Delivery acceleration

An expected 18-month build delivered in a fraction of the timeline with governed pipelines and live dashboards in parallel.

2 hrs/day

Freed for leadership

Business development dashboard eliminated the daily spreadsheet audit; referral and partner metrics now live and automated.

Centralized and unified

Enterprise data warehouse

All system data in one Snowflake warehouse; no more manual cross-system consolidation.

7 Domains

KPIs live in production

Patient safety, quality, business development, and revenue, all automated on one unified data foundation.

Let’s create something truly remarkable & intelligent!

Whether you’re starting with data modernization or exploring AI copilots, we’re here to help.

Contact Us