How to Prepare:
To prepare for this restructuring, understand your agency or program’s data: know it inside and out.
Start by exploring your workforce data. Import everything into Qlik—demographics, pay grade, job title, job function, training, etc.—and start asking tough questions.
For example, can you reduce wage expenses without reducing headcount? One agency, The Architect of the Capital, used Qlik to do just that. By examining their overtime spend, they realized that by providing managers with a daily view of tasks and work orders, they reprioritized and significantly reduced overtime spend.
To do the same analysis at your agency, look at time and attendance, overtime rates, department, location, hire date, etc.
Other key questions to explore include:
For inspiration, check out this HR app.
The next step, which I’ll explore in next month’s blog, is to pull in budget and performance data. A good place to start is with the new DATA Act data your agency is required to submit quarterly.
Oh, and as for the colleague I laid off, he almost immediately found a great role at another company and is still happily employed there today, almost 7 years later. I love happy endings. :)