Challenge 

A PE-backed provider of occupational safety and health (OSH) monitoring solutions experienced data and process integrity issues related to monthly close and financial reporting. Due to frequent acquisitions over time and historically lengthy data integration processes, achieving a successful exit was more arduous than anticipated. 

Although the company had a sufficiently robust technology ecosystem to support effective reporting, the processes, data flows, and integrations required weren’t as effective. 

A year+ before the exit, CrossCountry Consulting stepped in to assess the company’s tech stack, KPIs, and reporting efficacy to more quickly make progress on a sale. 

How We Helped 

CrossCountry’s Data Transformation & Analytics team conducted comprehensive discovery sessions with key management, technology, financial, and operational stakeholders to understand the current state. This initial phase led to a series of transformation initiatives, including: 

  • Assessing reporting gaps and pain points to design a more effective target state. 
  • Documenting detailed data architecture designs and data flows required to facilitate reporting needs in Snowflake. 
  • Establishing and prioritizing KPIs and an automated monthly reporting package. KPIs included dealer profitability, retention metrics, and trended financials inclusive of pro-forma entries/acquired entities. 
  • Bringing greater visibility and accuracy into the business, which previously did not exist, such as detailed breakouts by location, segment, products, and more. 
  • Layering in pro-forma data from acquired entities to create a portfolio data book using Alteryx and Power BI. 
  • Developing an expense allocation methodology and profitability model for new insights into the profitability of individual dealers, segments, and products. 

“We’ve never had this level of insight into the performance of the business before.” – PE sponsor 

Results 

As the sponsor prepared the company for a sale, these enhancements soon compounded and materialized into critical achievements that helped accelerate the process. Benefits included: 

  • Value-driven insights for sell-side bankers. 
  • 2 weeks saved every month on financial reporting due to automated data compilation from disparate sources. 
  • Enhanced performance visibility across all acquisitions, including pre- and post-integration data. 
  • Data cleanup and backfilling for even greater data quality and reporting integrity. 

“This allows us to make practical decisions,” the CFO noted. “The CrossCountry team just gets it and were absolute rockstars.” 

The company was successfully taken to market and sold, a testament to the work and commitment of all stakeholders and parties. The company expects to continue growth across several markets and advance its AI-enabled capabilities to serve customers even more effectively in the future.