Bringing Real-Time Workforce Visibility to a High-Growth Insurance Organization
When people think about operational rigor in insurance, they often think about underwriting, risk models, and financial controls. But for high-growth insurance companies, operational excellence increasingly depends on something else: workforce visibility.
As Hippo Insurance (Hippo) scaled its business, expanded geographically, and hired highly specialized talent, the People team needed to answer increasingly complex questions around hiring effectiveness, workforce planning, location strategy, and organizational performance.
But like many fast-growing organizations, their people data lived across multiple systems, reporting processes had become heavily manual, and HR analytics priorities often fell behind broader enterprise BI initiatives.
What began as a reporting challenge quickly became something much larger: how to give the right leaders access to the right workforce insights at the right time.
The Challenge: Scaling Workforce Visibility in a Rapidly Changing Organization
When we began working with Hippo, the People team had already built an impressive reporting process internally. But maintaining it had become increasingly difficult as the organization evolved.
As Hippo grew:
Hiring velocity increased across distributed and remote teams
Leadership needed more frequent and more sophisticated workforce insights
Data lived across systems like Greenhouse and ADP
Organizational changes, integrations, and divestitures increased the need for accurate workforce visibility
HR needed to support business decisions with the same level of rigor expected across the rest of the organization
Quarterly reporting cycles often turned into “all hands on deck” efforts to consolidate and validate workforce data before leadership reviews.
As one stakeholder described it:
“I’m doing the best I can on regular reporting without being a data scientist.”
The challenge wasn’t a lack of effort. It was that the People team had been forced to build increasingly complex reporting processes without the tooling, automation, or data infrastructure needed to scale sustainably.
At the same time, HR analytics needs frequently fell behind other enterprise BI priorities, leaving the People function without the support required to operate at the speed of the business.
The result:
Manual reporting workflows
Static slide-based QBRs
Significant time spent reconciling data
Limited self-service access for leaders
Difficulty aligning teams around shared workforce goals
And in a high-growth environment, static reporting quickly becomes outdated.
Leadership needed ongoing visibility into questions like:
Are we hiring effectively for specialized skill sets?
Is our location strategy creating the workforce density we need for the future?
Are recruiting processes driving long-term productivity?
Are we retaining top performers?
Are we on track against headcount and budget goals?
How do organizational changes impact workforce planning and execution?
The Solution: From Manual Reporting to Self-Serve Workforce Intelligence
Illoominus partnered with Hippo to connect and operationalize workforce data across the organization, transforming reporting from a reactive quarterly exercise into an ongoing decision-making capability.
By integrating systems like Greenhouse and ADP, Hippo was able to move from fragmented reporting toward a centralized and continuously updated view of the workforce.
This enabled several key transformations:
Automated weekly and quarterly reporting workflows that previously required extensive manual effort
Interactive dashboards that replaced static slide decks and enabled leaders to explore workforce trends in real time
Role-based visibility so each stakeholder could access the level of detail most relevant to their decisions
Standardized workforce metrics that aligned recruiting, HR, and leadership teams around shared goals
Ongoing visibility into organizational changes, helping maintain cleaner and more aligned workforce data through periods of transition
Most importantly, the organization moved away from a one-size-fits-all reporting model.
Different teams required fundamentally different views into the business:
Talent Acquisition teams gained visibility into:
Historical recruiting process effectiveness
Hiring productivity and pipeline conversion
Weekly hiring pipeline progress against goals
Department-level recruiting updates for business leaders
HR Business Partners and People Operations teams gained visibility into:
Retention and workforce movement
Organizational health trends
Headcount alignment
Workforce planning support
Executive leadership gained visibility into:
Workforce strategy and talent density
Headcount and budget tracking
Location strategy effectiveness
Organizational performance trends
By putting the right information into the hands of the right people, Hippo was able to increase both operational efficiency and overall data literacy across the People function.
What started as an initiative focused on making reporting easier evolved into something much more strategic:
a scalable workforce intelligence capability embedded into the organization’s daily operating rhythm.
The Impact: Operational Efficiency and Better Workforce Decisions
With Illoominus in place, Hippo transformed how workforce data was accessed, shared, and used across the organization.
What was previously a reactive reporting process became an ongoing, self-serve decision-making system that supported leaders at every level of the business.
By the numbers:
16 dashboards built across recruiting, workforce planning, and executive reporting
4 weekly automated reports delivered directly to leaders
70% reduction in manual reporting preparation time
300 hours saved annually by eliminating manual reporting and data reconciliation
12 stakeholders actively leveraging workforce dashboards and reporting
Workforce reporting integrated into regular operational and leadership workflows
Automated QBR and weekly reporting processes replacing manual slide-based updates
Most importantly, Hippo created a stronger operational foundation for workforce planning in a rapidly evolving business.
Instead of spending time pulling data together, the People team could focus on helping leaders make faster, more informed decisions about hiring, retention, organizational design, and future workforce strategy.