OPM EHRI Data Warehouse Overview

The Office of Personnel Management (OPM) Enterprise Human Resources Integration (EHRI) Program's Data Warehouse is the Government's premier source for integrated Federal workforce information. The system currently collects, integrates, and publishes data for 1.8 million Executive Branch employees on a bi-weekly basis, supporting agency and Governmentwide analytics. In addition, the system provides data to other Government systems and processes dependent upon integrated Federal workforce data. The OPM Data Warehouse architecture provides a flexible, scalable, and secure environment for current and future Government requirements, and continues to grow in the breadth and depth of data that is collected, and in data integration and data sharing capabilities. The OPM Data Warehouse will expand through the addition of new Federal employee populations, new data elements, improved data integration and data quality processes, and by enabling new system interfaces that utilize industry best-practice architectures.

Benefits of the OPM Data Warehouse include:

• Standardized collection of Federal employee data, reducing the number of data calls made to agencies and providers for common employee data
• Centralized focus on data quality and integration to one system, reducing costs for replicating this work in multiple sources
• Consistent, timely, and secure source for other programs requiring integrated Federal employee data, such as the Retirement Systems Modernization program.
• Integrated reporting across the Federal workforce in addition to capabilities for advanced analysis by agencies and operating units

Components of the OPM Data Warehouse include:

• Standard data interfaces for the collection of human resources (HR), payroll, training, and military service deposit data
• Processes that integrate data from these various sources to provide a comprehensive view of the Federal employee's career
• Data quality reporting framework including reports available to agencies and providers to identify data errors and inconsistencies with Federal regulations
• Flexible and extensible architecture that allows additional data elements and interfaces to be added to the warehouse to support new business processes.
• Core set of standard reports with custom report development capabilities through an industry best-practices reporting and analysis tool
• Workforce planning and analysis and forecasting tools that meet the Federal workforce planning requirements
• Individual employee lookup tool with history across the employee's Federal career
• Secure systems environment that meets Federal data standards and certifications

Future capabilities to leverage the investment in the OPM Data Warehouse include:

• Expansion of data collection outside the current Executive Branch agencies to provide a truly Federal-wide view of employees
• Development of additional interfaces to Federal employee-related data sources, including systems that support entrance-on-duty, retirement processing, benefits systems, training and certification, etc.
• Enhancements to data quality and integration tools to support a more complete and accurate view of the employee across their Federal career.
• Deployment of a Service-Oriented Architecture (SOA) to provide external systems access to OPM Data Warehouse data and processes via common services and interfaces