Job Overview:
The HR Data Analyst develops and maintains Human Resources business intelligence dashboards, reporting tools, and data models to support workforce analytics and data-driven decision-making. This role integrates and analyzes HR, organizational, financial, and compensation data to deliver accurate reporting, meaningful insights, and scalable analytical solutions for Human Resources and business stakeholders.
Responsibilities/Essential Functions:
Develops, maintains, and enhances Human Resources dashboards, reports, and analytical tools using Power BI, Microsoft Excel, and other reporting technologies.
Builds and maintains workforce and organizational data models to support headcount reporting, labor cost analysis, workforce planning, and operational decision-making.
Creates interactive Power BI dashboards and visualizations that communicate workforce trends, organizational metrics, and key Human Resources performance indicators.
Develops advanced Excel models using complex formulas, pivot tables, Power Query, and other analytical capabilities to support workforce reporting and analysis.
Analyzes workforce data, including headcount, turnover, hiring, employee movement, organizational structures, employee demographics, and labor costs.
Integrates compensation data into workforce dashboards and reporting models to provide visibility into payroll costs, compensation expenditures, and related workforce metrics.
Supports the Compensation team by developing and maintaining data extracts, reporting tools, and dashboards based on established compensation definitions and requirements.
Develops standardized reporting methodologies, data definitions, and calculations to ensure consistency across Human Resources dashboards and analytical tools.
Extracts, transforms, validates, and consolidates data from HR information systems, payroll systems, compensation platforms, and other sources.
Creates and maintains data models that integrate multiple sources of Human Resources and workforce information to support comprehensive analysis.
Partners with HR, Compensation, Talent Acquisition, Talent Management, and other stakeholders to understand reporting requirements and develop effective analytical solutions.
Automates recurring reports, data preparation activities, and dashboard updates to improve efficiency, accuracy, and accessibility of HR information.
Performs data validation, reconciliation, and quality reviews to ensure the accuracy and integrity of workforce and organizational information.
Investigates data discrepancies, identifies root causes, and coordinates corrections with appropriate system and process owners.
Develops analytical models to evaluate workforce trends, staffing changes, organizational movements, and potential impacts of proposed workforce actions.
Prepares recurring and ad hoc analyses, dashboards, and presentations for Human Resources leadership and business stakeholders.
Translates complex data into clear visualizations, summaries, and insights that support business decisions.
Maintains documentation of reporting processes, data sources, calculations, model assumptions, and dashboard functionality.
Supports improvements to HR reporting infrastructure, business intelligence capabilities, and data management processes.
Ensures appropriate handling of confidential employee and compensation information in accordance with company policies and established information security practices.
Performs other duties as needed.
Knowledge/Skills/Abilities:
Strong knowledge of data analysis, reporting, business intelligence, and data visualization practices.
Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, lookup functions, Power Query, data modeling, and analytical reporting.
Strong proficiency in Power BI, including dashboard development, data modeling, report design, and data visualization.
Ability to develop and maintain complex workforce and organizational data models, including…