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

  • 46+

    years in operation

  • 650

    Patients in active care daily

  • 10/10

    Hospice index score achieved

INDUSTRY

  • Healthcare/ Hospice and Palliative Care services

TECH STACK

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

Executive Summary

A single BI engineer was managing four disconnected systems: two EMRs, a patient triaging platform, a state HIE, and HR data, with no shared model between them. Inferenz built a unified Enterprise Data Warehouse on Snowflake, created a Master Patient Index resolving patient identities across both 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 rested on a single BI engineer managing four disconnected systems with no shared model, unable to support the analytics and AI capabilities leadership needed.

01

One Engineer, Everything on Hold

A single BI engineer handled schema design, integration, dashboard development, and data quality across all systems. Every new request queued. Every incident pulled focus from strategic work.

02

Four Systems, No Shared View

Two 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 four systems. It could not be used.

Our Solution

Inferenz developed a unified Enterprise Data Warehouse on Snowflake integrating both 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 both 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 18-month solo 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.

4 → 1

Unified data warehouse

Two EMRs, triaging system, state HIE, and HR 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