Creating a Single Source of Truth for Portfolio HR Data
A multi-fund investment management firm unified HR data across 14 portfolio companies into a single source of truth—enabling real-time workforce analytics and consolidated compliance reporting for the first time.
The Challenge
“The investment firm managed a portfolio of 14 operating companies across three sectors. Each portfolio company had its own HR system (a mix of Workday, BambooHR, ADP, and custom HRIS implementations), its own HR policies, and its own data definitions for common HR metrics. Producing consolidated workforce analytics for the portfolio required manual data extraction from 14 systems, weeks of reconciliation to normalize inconsistent definitions, and the resulting reports were outdated by the time they were produced. The HR leadership team had no real-time visibility into headcount, attrition, or compensation trends across the portfolio.”
The Solution
Eficens deployed FLAIR's portfolio HR data integration layer—a unified data aggregation platform that connects to all 14 portfolio company HR systems via API, normalizes data to a common HR data model, and provides real-time consolidated analytics through a portfolio-level dashboard. Company-level data remains in each company's native HR system; FLAIR's layer provides the consolidated view without requiring system consolidation across the portfolio.
Implementation
Multi-System API Integration Architecture
FLAIR's integration layer established API connections to all 14 portfolio company HR systems, using each vendor's native API with system-specific authentication and rate limiting configuration. For the two portfolio companies using custom legacy HRIS implementations without modern APIs, FLAIR deployed lightweight data export agents that generated standardized data exports on a configurable schedule. All data flows are encrypted in transit and at rest, with data isolation maintained between portfolio companies to prevent cross-company data access.
Common Data Model and Metric Normalization
The most significant technical challenge was normalizing 14 different approaches to common HR metrics—headcount, attrition, FTE, and compensation—into consistent definitions. FLAIR's common data model included documented calculation specifications for each metric, and transformation logic that converted each company's native data into the standard definitions. Metric reconciliation documentation was shared with each company's HR team, enabling them to validate that the consolidated figures accurately represented their workforce data before the portfolio dashboard went live.
Portfolio Analytics Dashboard
The portfolio analytics dashboard provided the investment firm's HR leadership with real-time visibility into headcount trends, attrition rates, compensation distributions, and hiring velocity across all 14 portfolio companies—with drill-down to company level and comparison views across comparable companies within the portfolio. Automated monthly reports generated consolidated workforce snapshots for board reporting, replacing the manual multi-week assembly process that had previously delayed portfolio-level HR reporting by 3-4 weeks after period close.
Related Resources
View allIntegrated HRM: Centralizing Onboarding, Recruitment, and Billing
Fragmented HR systems—an ATS here, an onboarding tool there, a payroll system that doesn't talk to either—create data silos, manual reconciliation work, and compliance gaps. Integrated HRM closes these gaps with a unified data layer.
Democratizing HR Data: Conversational Query Interfaces for Non-Tech Users
HR analytics dashboards answer the questions their designers thought to ask. Conversational query interfaces answer the questions HR leaders actually have—in plain language, without a data analyst intermediary.
The Future of Managed Workplace Intelligence: VisiQ and Beyond
A vision for the intelligent workplace: where physical access, visitor management, space utilization, and employee experience data converge into a single operational intelligence layer—and what it takes to build it.