Visualizing Hiring Metrics at OPM During COVID-19
Federal Health and Civilian
AI and Analytics
The U.S. Office of Personnel Management (OPM) manages the government’s civilian workforce. OPM’s stated mission is “to recruit, retain, and honor a world-class force to serve the American people.”
HR Solutions (HRS) at OPM engaged Excella to aid in creating a report that helps track key metrics important to the agency’s overall goals. This report will ultimately help deliver on the mission of HRS at OPM ”to provide exceptional human resources products and services to meet the dynamic needs of the federal government.”
As the COVID-19 pandemic grew in scale and severity, OPM wanted to know how the outbreak was affecting key metrics in the agency’s goal of managing the civilian workforce. OPM was looking for a recurring report that helps them understand how the pandemic is affecting planning activities and their ability to meet other agencies’ needs in hiring high-quality candidates.
This later expanded to monitoring data of specific agencies, helping place recently furloughed staff due to the pandemic and identifying opportunities for selected participants to work at other federal agencies so they can expand their skills and provide needed expertise.
The new Tableau report is now directly distributed every week to 16 stakeholders at OPM and has informed other distributions and communications to senior leaders at the agency. The report is used in collaboration with other federal agencies to help them achieve their goals and view actionable data directly relating to their situation. Previously, the manual data collection process would require at least eight different disparate reports and now the reporting time has decreased significantly, allowing the report to be continually updated and distributed on a weekly basis.