Reporting Specialist

Reporting Specialist

Job Requirements*

We are looking for a Reporting Associate People Analytics to support the delivery,

maintenance, and validation of workforce reports and dashboards for Global and

U.S. employee populations. This role focuses on data accuracy, report generation,

dashboard support, and user assistance across people metrics such as headcount,

hiring, attrition, diversity, learning, and employee movement.

The role works closely with People Analytics Leads, HRBPs, COEs, HRIS, and IT

teams to ensure timely, accurate, and consistent reporting outputs.

Key

Responsibilities*

Support preparation and refresh of key HR metrics dashboards using

Power BI for Leadership, HRBPs, and COE users

Use SQL queries to extract and validate data supporting dashboards and

standard HR metrics

Assist in reporting on:

o Employment cost metrics

o Employee attrition by job band and population

o Workforce headcount and hiring metrics

o Learning and training metrics

o Gender diversity metrics

Ensure reports follow defined metric definitions, SQL logic, and Power BI

reporting standards

People Trends & Reporting

Generate quarterly and monthly trend dashboards and visuals in Power

BI for workforce, hiring, attrition, learning, and diversity metrics

Utilize SQL-based data extraction and transformations to support trend

analysis

Perform basic variance analysis, sanity checks, and data validation

between SQL outputs and Power BI visuals

Workforce Planning & Organizational Reports

Prepare workforce planning reports using Power BI dashboards and SQL

datasets, including:

o Headcount by region, function, job band, and tenure

o Employee generation and demographic views

Support organizational structure reporting using Power BI visuals:

o Pyramid visuals

o Average level grade views

o Geographic workforce distribution

Assist with plant-level workforce and role distribution reports using SQL-

driven data models

Hiring, Movement & Learning Reporting

Generate recruiting and onboarding reports using Power BI reports

sourced via SQL, including:

o New hires by region, role, gender, age, and function

Support employee movement reporting:

o Promotions, transfers, and role changes

o Movement distribution by job band, function, and gender

Prepare learning and development reports using Power BI dashboards,

covering training hours, participation, and course-level analysis

Attrition & Turnover Reporting

Support attrition dashboards in Power BI by:

o Attrition type (voluntary / involuntary)

o Region, function, gender, tenure, and job band

Use SQL calculations to support rolling 12-month and annualized attrition

metrics

Maintain detailed attrition drill-down reports with validated SQL logic

Data Validation & System Support

Run routine data validation and reconciliation using SQL across

PeopleSoft, OBIEE, WFA, and OneStream

Support root-cause analysis and resolution of data discrepancies in

coordination with HRIS or IT teams

Maintain employee-level datasets and reports (headcount, turnover,

movement) using secure SQL views

Support PeopleSoft and OneStream validation outputs and Power BI data

model accuracy

Dashboard Maintenance & User Support

Support maintenance, refresh, and optimization of Power BI dashboards,

including:

o Workforce Analytics (WFA)

o Office Occupancy

o Managerial Span of Control

o Competency and Skills reports

Provide day-to-day user support for OBIEE and Power BI reports, including

navigation support, data explanation, and basic troubleshooting