HR Data Portal

About the Program

Category: Information Technology (Best in Category)

Year: 2017

The County of Orange HR Data Portal is an enterprise personnel data warehouse developed by Orange County Information Technology (OCIT) in collaboration with the County’s Human Resource Services (HRS) department. The portal has drastically improved the County’s ability to gain insights into workforce transactions, practices, and historical trends while increasing accuracy and significantly reducing staff time on manual data processing. In building the portal, the County transformed a labor-intensive, inefficient legacy system into one that provides quick and easy access to accurate data, supports analytics, and meets management’s need to support evidence-based decision making. The portal’s ease of use and robust features, combined with dashboards and graphical visualization, have made it an outstanding tool for conducting efficient analyses. In addition, the portal has reduced the time needed to prepare data for analysis from a full workday to just one hour. HR Data Portal features include:  Standard Reports that provide insights into the County’s workforce structure and capacity and facilitate compliance with County policies, state laws, and federal regulations. These reports also help to ensure that employee job classifications and wages align with standards outlined by collective bargaining. Users can review the reports to ensure that work assignments are distributed equitably across business units.  Exception Reports that allow users to identify errors in data entry as well as to provide periodic reviews of personnel transactions. For example, by alerting data analysts of errors prior to completing a payroll cycle, these reports ensure that employees are paid correctly and on time.  Ad Hoc Analysis, which allows users to process data and produce visualizations that help departments anticipate staffing needs and maintain a consistent employee workload, thereby reducing departmental reliance on overtime hours or contingency staffing. The feature enables managers to quickly identify compensation gaps in specific job classifications that may require adjustments in recruitment and retention strategies.