Fortune 500 Self-Insured Employer Saves $6M Annually with Hospital Price Transparency Data

Vertical

Healthcare / Employee Benefits

Client

Fortune 500 manufacturing company, 80,000+ covered lives (name withheld under NDA)

Engagement Duration

14 months (ongoing)

Key Metric

$6.2M in first-year plan savings

Executive Summary

A Fortune 500 US manufacturing company partnered with Actowiz Solutions to build a custom hospital price transparency data pipeline that unlocked 6 million dollars in first-year health plan savings. The engagement processed CMS-mandated Machine-Readable Files (MRFs) from over 2,100 hospitals and 47 payers, delivered a normalized, employer-specific dataset, and powered downstream benefit design changes — network steering, centers of excellence programs, and reference-based pricing — that reduced healthcare spend by 4.1% in the first full plan year.

This case study documents how hospital price transparency data, when operationalized properly, becomes one of the highest-ROI data investments available to large self-insured employers in America.

Client Background

The client is a Fortune 500 US manufacturing company with over 80,000 covered lives across their self-insured medical plan. Their annual healthcare spend exceeded $780 million, growing 7-8% annually in the years before the engagement — meaningfully faster than CPI and wage growth.

The Total Rewards team had attempted multiple cost containment initiatives over the prior 5 years:

• Narrow network designs (partial success, low employee satisfaction)
• High-deductible health plans (limited impact, high employee disruption)
• Wellness programs (marginal impact)
• Pharmacy benefits manager (PBM) renegotiation (valuable but one-time)

By 2024, they had exhausted the obvious levers. What they needed was data: objective, granular, facility-level pricing data to identify where their TPA’s negotiated rates were competitive and where they were not.

The 2021 CMS Hospital Price Transparency rule had theoretically made this data available. But practically, the data was unusable — buried in multi-terabyte MRFs across thousands of hospital websites, with inconsistent schemas, decaying URLs, and no centralized registry.

The client needed an expert partner who could turn regulatory compliance files into decision-ready intelligence.

The Challenge: Why Most Employers Can’t Use MRF Data

When the client explored the problem space, they quickly understood why their peer companies had largely ignored price transparency data:

1. Volume Is Overwhelming

A single large payer’s Transparency in Coverage (TiC) file can exceed 1 TB uncompressed. Processing these files at scale requires distributed computing infrastructure most employers don’t have.

2. Schema Chaos

CMS provided a recommended schema. Actual hospital and payer compliance varies dramatically — nested JSON, CSV, XML, custom formats, and deviations from the spec are common.

3. URL Decay

Hospital MRF URLs change without notice. A static list of URLs becomes 30-40% stale within six months without active monitoring.

4. Code Translation Is Specialized

Raw MRF data contains CPT, HCPCS, DRG, NDC, and revenue codes. Converting these to plain-English service descriptions requires clinical and billing expertise most employers lack.

5. Non-Compliance Is Widespread

Despite the CMS mandate, an estimated 30-40% of hospitals are partially non-compliant — missing files, blocked URLs, or data of limited utility. Navigating this requires ongoing effort.

6. In-House Engineering Is Expensive

Peer employers who had attempted in-house pipelines reported $800K-$1.5M of engineering cost with limited results. The client wanted to avoid that path.

The Solution: Custom Employer-Focused MRF Data Pipeline

Actowiz designed a turnkey hospital price transparency data platform specifically optimized for large self-insured employer use cases.

Component 1: Comprehensive MRF Discovery & Extraction

• Continuous monitoring of 6,000+ US hospital websites for MRF availability
• Automated URL validation with weekly freshness checks
• Compliance flagging — identifying hospitals out of compliance for optional escalation to CMS
• Multi-TB file processing with distributed computing infrastructure
• Full coverage of the client’s network footprint: 2,100+ hospitals across their employee geographies

Component 2: Payer Transparency in Coverage (TiC) Processing

• 47 major payers processed monthly (including the client’s existing TPA)
• Full in-network rate files normalized to standard schema
• Historical archiving — every month of data retained for trend analysis

Component 3: Normalization & Enrichment

• Canonical schema — all hospital and payer data mapped to a unified data model
• Code translation — CPT, HCPCS, DRG, NDC joined to human-readable service descriptions
• Procedure grouping — individual codes grouped into clinically meaningful bundles (joint replacement, MRI imaging, colonoscopy, etc.)
• Geographic enrichment — every facility linked to ZIP, county, CBSA, and HRR for market-level analysis
• NPI and corporate mapping — facility-level data rolled up to health system parent level

Component 4: Employer-Specific Analytics Layer

Beyond raw data delivery, Actowiz built custom dashboards for the client’s benefits team:

• Network competitiveness scorecard — how their TPA’s negotiated rates compared to market 25th, 50th, and 75th percentiles
• High-cost procedure analysis — top 50 procedures by spend with pricing variation mapped
• Steering opportunity identifier — facility-level cost differentials for procedures where employees have choice
• Centers of Excellence candidate identification — facilities with best quality scores AND competitive pricing
• Reference-based pricing simulator — model the impact of capping reimbursement at various market percentiles

Implementation Timeline

Month 1: Scope definition, facility prioritization, TPA coordination Month 2-3: Initial data pipeline deployment, first hospital set processed Month 4: Full facility coverage achieved, payer TiC processing activated Month 5-6: Normalization, enrichment, and analytics layer deployed Month 7: Benefits team training and initial insights review Month 8: Plan design changes approved by executive committee Month 9-12: Plan year implementation with ongoing data monitoring Month 13-14: First-year results measurement and Year 2 planning

Results: Quantified Outcomes

Financial Impact

• $6.2M in first-year plan savings, representing 4.1% reduction in total medical spend
• Projected $9-$11M in Year 2 as more plan design changes compound
• ROI of 18x on the data engagement (engagement cost represented less than 6% of realized savings)

Specific Savings Drivers

Orthopedic Centers of Excellence Program ($2.4M): The data revealed that knee and hip replacements varied by 35-42% between in-network hospitals in the same metros. The benefits team launched a Centers of Excellence program, steering elective orthopedic procedures to lower-cost, high-quality facilities with bundled pricing. Employee-facing incentives (waived copays, travel reimbursement for distant COE facilities) ensured high adoption.

Imaging Steering ($1.1M): MRI costs varied from $400 to $3,100 across in-network providers for identical procedures. Enhanced benefit navigation tools guided employees to cost-effective imaging centers, reducing imaging spend by 28% with zero quality degradation.

Reference-Based Pricing for Outpatient Surgery ($1.8M): For a specific set of outpatient surgical procedures where the data showed consistent overpayment, the plan introduced reference-based pricing at the 60th percentile of market rates. Legal review ensured compliance; employee communications were managed carefully to limit disruption.

TPA Renegotiation Leverage ($900K): Armed with facility-level comparative data, the benefits team renegotiated specific contract terms with their TPA — eliminating outlier overpayments in 8 facilities where their TPA’s rates were above the 90th market percentile.

Operational Metrics

• 100% of targeted facilities processed within 4 months (vs. 18+ months of DIY attempts at peer companies)
• 0.4% data quality error rate on delivered records
• Monthly refresh cadence maintained throughout the engagement
• Zero employee complaints attributed to data-driven plan design changes (due to careful change management)

Use Case Deep Dive: How Centers of Excellence Was Built

The Centers of Excellence (COE) design exemplifies how the data engagement drove specific programmatic decisions.

Step 1: Pricing Discovery Analysis of hospital MRF data across 14 metros where the client had employee concentrations revealed that knee replacement total-episode costs varied from $28,000 to $51,000 across in-network facilities.

Step 2: Quality Filtering The team cross-referenced pricing data with publicly available CMS quality metrics — readmission rates, complication rates, patient satisfaction scores — to ensure steering didn’t sacrifice outcomes.

Step 3: Candidate Facility Identification 24 facilities across the client’s geographies were identified as COE candidates — below 50th percentile pricing AND above 75th percentile quality scores.

Step 4: Benefit Design Employees electing COE facilities received: - Waived in-network deductible - Travel reimbursement up to $1,500 for cross-state COE selection - Concierge benefit navigator support

Step 5: Outcome Measurement In the first plan year: - 41% of elective joint replacements occurred at COE facilities (vs 6% baseline) - Average episode cost decreased 28% - Patient satisfaction scores remained equivalent

Net savings from the program: $2.4M in Year 1, with projected $3.1M in Year 2.

Lessons Learned

1. MRF Data Has Massive ROI — But Only If Operationalized

Many employers access raw MRF data but never translate it into plan decisions. The value comes from analytics, not raw files.

2. Change Management Determines Success

The data created opportunities; the benefits team’s careful change management realized them. Employee communications, navigator programs, and incentive design were as important as the underlying data.

3. Quality Data Must Accompany Cost Data

Steering purely on cost would have been reputationally and medically risky. Integrating public quality metrics was essential.

4. TPA Partnership Is Complex But Necessary

The client’s TPA was initially defensive about rate transparency analysis. Building a collaborative working relationship — framing the data as mutual optimization, not adversarial — was critical.

5. Outsourced Data Infrastructure Outperforms In-House

Peer companies who tried to build internal pipelines reported delays, quality issues, and 3-5x higher costs than this engagement.

About Actowiz Solutions

Actowiz Solutions operates one of the most comprehensive hospital price transparency data platforms in the US. We serve self-insured employers, health plans, healthtech startups, hospital systems, and academic researchers with enterprise-grade MRF discovery, extraction, normalization, and analytics.

Our healthcare data specializations: Hospital Price Transparency (HPT) MRF processing - Transparency in Coverage (TiC) payer file processing - Prescription drug pricing data - Provider directory and credentialing data - CMS quality metrics integration - Geographic and demographic data enrichment

Client Feedback

“The data showed us that two in-network hospitals charged 40% different prices for the same orthopedic surgery. Once we saw that, the savings opportunity was undeniable.”

— VP, Total Rewards & Benefits