At a global pharmaceutical company, HR leadership was spending over 600 hours each quarter manually compiling workforce KPI reports. This time-consuming process kept leaders focused on spreadsheets instead of strategy, limiting their ability to act proactively on trends within their teams.

To address this, I led the end-to-end redesign of workforce analytics reporting. Collaborating closely with HR Business Partners, I conducted working sessions to understand what data they actually used to drive decisions. Through these conversations, it became clear that weekly rollups were far more valuable than the existing monthly and quarterly views. In response, I designed a dynamic weekly rollup feature that accelerated reporting workflows and met immediate business needs.

As the chief data product designer, I built the report from the ground up in Qlik, creating intuitive visualizations that aligned with leadership’s decision-making priorities. I calculated and validated critical workforce metrics – including compa ratio, manager-to-employee ratio, and years of service – working closely with HR analytics subject matter experts to ensure accuracy and relevance.

Recognizing data quality limitations, I identified upstream issues impacting reporting reliability and partnered with a Data Engineer to implement targeted data quality fixes within existing pipelines. This improved trust in the insights and reduced time spent reconciling discrepancies.

The solution was rolled out to over 1,000 users globally, equipping HR leaders with real-time, interactive dashboards that allowed them to track workforce trends, identify flight risks among top talent, and make data-informed decisions with confidence. The CHRO described the tool as a “gamechanger,” transforming HR’s ability to be proactive rather than reactive.