Background
To improve their data management and analytics capabilities, a Medicaid health plan decided to enhance their existing Enterprise Data Warehouse (EDW) by integrating additional data sources and optimizing performance.
Challenge
The health plan faced several challenges in managing and analyzing their diverse data:
- Integrating multiple data sources into the existing EDW
- Meeting strict service level agreements (SLAs) for data load times
- Incorporating additional data sources for comprehensive analysis
- Optimizing performance to handle large volumes of data efficiently
Solution
To address these challenges, the health plan implemented enhancements to their Enterprise Data Warehouse solution with the following features:
-
- Integration of medical claims, pharmacy claims, and membership data
- Performance optimization techniques
- Incorporation of additional data sources
- Improved ETL (Extract, Transform, Load) processes
Implementation
The implementation process involved several key steps:
- Data integration: Medical claims, pharmacy claims, and membership data were successfully integrated into the existing EDW.
- Performance optimization: Collaborative efforts were undertaken to improve runtime efficiency.
- Additional data sources: Capitation, Pharmacy tiers, and Health Risk Assessment data were incorporated into the EDW.
- SLA monitoring: Processes were established to track and meet service level agreements for data load times.
Results:
The enhancement of the EDW yielded significant improvements:
Conclusion:
The enhancement of the Enterprise Data Warehouse for the health plan has significantly improved their data management and analytics capabilities. By successfully integrating diverse data sources, optimizing performance, and consistently meeting SLAs, the health plan has enhanced its ability to make data-driven decisions and improve services for Californians seeking health insurance. The enhanced EDW now serves as a robust foundation for various downstream projects, enabling more comprehensive and efficient healthcare analytics to support their mission of providing affordable, high-quality health insurance options.
