Consolidating Data Sources to Improve HEDIS metrics

The Challenge

Quality metrics for HEDIS reporting are pulling data mainly from administrative sources even though a wealth of information exists internally at the health system. The National Committee for Quality Assurance (NCQA) is pushing for healthcare payers to focus more on data from care management systems, Electronic Health Records (EHR), and Health Information Exchanges (HIE). The shear amount of data available is daunting and many payers are not sure how to incorporate this information into their current HEDIS engines.

The Conflict

A healthcare payer organization needed to pivot from data sources delivering stale data to sources that provide more quality information needed for HEDIS reporting.

The Solution

In conjunction with the organization’s Quality & HEDIS groups, our team examined the data in their EHR, HIE, and care management systems and determined that by leveraging modern ETL technology the information from these sources could be properly transformed and mapped into both the internal HEDIS engine as well as the vended solution. This remedy would also allow for the data to be traced end to end accompanied by detailed metadata of all transformations which was needed for auditors approval.


Transform and trace the information from the various data sources into multiple engines so internal teams can validate and analysis the data for their HEDIS initiatives.

The Result

We successfully integrated EHR, HIE, and care management data into HEDIS data sets over a 3-month period. In doing so, our team ensured that the data was consistent in both systems and accurately represented member encounters. Furthermore, the merger of these data sources was associated with up to a 30% increase in CBP measure rates.

Lastly, we were able to trace and document our ETL process in a way that was comprehensive but also easy to understand. This documentation was used to gain auditor approval for the use of this data which improved the accuracy of the healthcare payer’s HEDIS reports.

Contact Us


What is a Data Strategy & Why is it Important?

In 2023, companies need a data strategy more than ever as the landscape of data management and analysis continues to evolve and become increasingly more complex.
Banking & Financial Services

The Benefits of Data Warehousing in Finance

A data warehouse is a storage system that enables you to track crucial data points over time and analyze them to run your financial operations smoothly and make sound decisions. 
Banking & Financial Services

The Benefits of Data Lakes for Financial Services

Data lakes are centralized repositories of data that are helpful for compliance purposes, performing forecasts, risk assessments, and understanding customer behavior.