Authored by Talona Felix, Government Strategist, UKG (United Kronos Group)
City governments are operating in an environment that demands precision.
Municipal leaders are expected to optimize public funds (ensure responsible fiscal stewardship), maintain service levels, support employee wellbeing and demonstrate measurable results to their communities. At the center of it all is the municipal workforce. Yet in many cities, workforce data remains fragmented across systems, limiting visibility into the very trends that shape performance.
The City of Rancho Cordova, Calif. chose to approach this challenge differently.
Through the National League of Cities Capstone Challenge, UKG partnered with Rancho Cordova — alongside PayTech — to explore a defining leadership question:
What becomes possible when a municipality brings all of its workforce data together into one clear, meaningful view?
Rather than treating HCM (HR, Payroll and Workforce Management) data as a collection of disconnected reports, the team integrated human capital analytics into a unified framework designed to support executive decision-making. The result wasn’t simply better reporting — it was greater clarity, stronger governance and a foundation for long-term municipal success.
What emerged is a replicable model that other municipalities can adopt. Here’s how you can bring these lessons into your own community.
You can hear directly from the team via a recording of our recent webinar.
From Data Collection to Data Clarity
Most cities already collect workforce data across HR, payroll and timekeeping systems. The challenge is not access. It is alignment.
When information lives on separate platforms, leadership receives reports rather than insight. Trends are hard to see, viewed in isolation and from a reactive position. In turn, making decisions reactively or with partial visibility.
Rancho Cordova’s initiative focused on bringing those data sources together in a meaningful way. By integrating workforce data into a unified analytical framework, city leadership gained a clearer understanding of patterns that influence budgeting, staffing and operational effectiveness.
This shift from fragmented reporting to integrated visibility is foundational. It turns workforce data into a strategic resource rather than an administrative byproduct, empowering municipal leaders to manage their budgets with precision, enhance service levels, support employee wellbeing and demonstrate measurable results for their community.
Building a Baseline for Better Decisions
A critical early step in the project was establishing and then analyzing measurable baseline “workforce indicators” — turnover trends, overtime usage, fatigue signals tied to workload patterns and compliance metrics related to scheduling and labor policies.
Looking at these indicators together provided municipal leaders, including the City Manager and the HR Director, with a more complete picture of organizational health. Where was overtime consistently concentrated? Which departments were experiencing greater staffing strain? Were there emerging compliance risks that required attention?
When those patterns are visible, leaders can act earlier and more confidently.
Instead of responding after issues escalate, the city is better positioned to plan proactively, align workforce strategies with policy priorities and allocate resources with greater precision.
Transforming Insight into Ongoing Leadership Visibility
Data integration alone is not enough. The true value lies in sustained visibility.
Through the Capstone Challenge partnership, the project advanced to the development of an interactive trend analysis dashboard that enables leadership to monitor workforce patterns in an ongoing, visual format.
Rather than relying on static reports, city leaders now have access to dynamic views of key workforce indicators. This supports more informed conversations about staffing models, overtime management and long-term workforce planning.
Equally important, the project emphasized sustainability. City staff were equipped to continue refining and expanding analytics capabilities over time, ensuring that workforce intelligence remains embedded in governance practices.
A Scalable Model for Forward-Thinking Cities
What makes Rancho Cordova’s experience particularly relevant for other municipalities is its practicality.
This was not a sweeping technology overhaul. It was a focused effort to maximize the value of existing human capital data and align it with executive priorities. Through structured collaboration under the National League of Cities Capstone Challenge, UKG and Paytech worked alongside city leadership to create a disciplined and measurable approach to innovation.
Cities across the country are navigating similar pressures: managing overtime costs, improving retention, supporting employee wellbeing and maintaining compliance in a complex regulatory environment.
The ability to see workforce trends clearly and act on them strategically is becoming a defining characteristic of high-performing local governments.
Why Workforce Intelligence Matters Now
Human capital represents one of the largest investments in any municipal budget. Treating workforce data as a leadership asset rather than a reporting function changes how cities plan and govern.
Rancho Cordova’s Capstone Challenge project illustrates how cities can move beyond fragmented reporting and toward integrated workforce intelligence. It shows what becomes possible when data is aligned with leadership strategy and supported by the right partnership.
As cities nationwide look for ways to operate more strategically, initiatives like this demonstrate that meaningful innovation does not always require starting from scratch. It requires clarity, alignment and the ability to translate workforce data into actionable insight.
UKG continues to work with municipalities across the country to help transform human capital data into executive intelligence that supports stronger governance and sustainable performance.
Cities that prioritize workforce insight as a strategic advantage are redefining what effective government looks like — starting with employee excellence and extending to resident satisfaction. The path forward is clear: build stronger communities by investing in the people who serve them.
Visit the NLC Strategic Partnerships page to learn more about the organizations like UKG dedicated to making NLC the premier resource for local governments.
What City HR Leaders Can Learn from Rancho Cordova’s Workforce Transformation
Learn more by listening to a recording from UKG’s recent webinar.
Skills-Based Local Government in Action
From the Event: Legacy Forward Information Session
What Does “Efficiency” Really Mean for Cities Right Now?
- NLC Partnerships
The Hidden Workforce Engine: How Local Partnerships Build Skills and Community
- NLC Partnerships
Legacy Forward Information Session
Increasing Opportunity: Economic Mobility in Rural Communities
- Justin Chu