OPM EHRI Data Warehouse

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 2.0 million Executive Branch employees on a bi-weekly basis, supporting agency and governmentwide analytics. In addition, the system provides Federal workforce data to other Government systems and processes dependent upon the integrated data. The OPM Data Warehouse architecture provides a flexible, scalable, and secure environment for current and future Government requirements, and expansion is planned 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, and training data
• Processes to integrate data from the various sources to provide a comprehensive view of a federal employee's career
• Framework for reporting data quality including reports available to agencies and providers to identify data errors and inconsistencies with Federal regulations
• Flexible and extensible architecture to allow the addition of data elements and interfaces to support new business processes
• Core set of standard reports with custom report development capability provided through an industry best-practices reporting and analysis tool
• Workforce planning, analysis and forecasting tools to meet the Federal workforce planning requirements
• Individual employee lookup tool to view history across the employee's Federal career
• Secure systems environment that meets Federal data standards and certification requirements

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

• Expansion of data collection to the agencies in the Judicial and Legislative Branches to provide a Federal-wide view of employees
• Development of interfaces to other federal employee-related data sources such as entrance-on-duty, retirement processing, benefits systems, training, certification, and so forth
• Enhancements to data quality and integration tools to support a complete and accurate view of records across an employee's Federal career
• Deployment of a Service-Oriented Architecture (SOA) to provide access by external systems to OPM Data Warehouse data and processes via common services and interfaces