HR Data Analyst

Role overview

Core responsibilities

• Develop and maintain HR dashboards, reports, and analytical tools using Power BI, Excel, and other reporting technologies.
• Build workforce data models for headcount reporting, labor cost analysis, workforce planning, and operational decisions.
• Create interactive Power BI dashboards showing workforce trends, organizational metrics, and HR performance indicators.
• Develop advanced Excel models with complex formulas, pivot tables, and Power Query.
• Analyze headcount, turnover, hiring, employee movement, organization structures, employee demographics, and labor costs.
• Integrate compensation data into workforce dashboards and reporting models.
• Support Compensation with data extracts, reports, and dashboards based on established definitions.
• Standardize reporting methodologies, data definitions, and calculations.
• Extract, transform, validate, and consolidate data from HR, payroll, compensation, and other systems.
• Maintain integrated data models drawing on multiple workforce information sources.
• Partner with HR, Compensation, Talent Acquisition, Talent Management, and other stakeholders on reporting needs and analytical solutions.
• Automate recurring reports, data preparation, and dashboard updates.

Additional responsibilities

• Perform data validation, reconciliation, and quality reviews; investigate discrepancies and coordinate corrections with system and process owners.
• Develop models to evaluate workforce trends, staffing changes, organizational movements, and possible impacts of proposed workforce actions.
• Prepare recurring and ad hoc analyses, dashboards, and presentations for HR leadership and business stakeholders.
• Translate complex data into clear visualizations, summaries, and insights for business decisions.
• Document reporting processes, data sources, calculations, model assumptions, and dashboard functionality.
• Support improvements to HR reporting infrastructure, business intelligence, and data management processes.
• Handle confidential employee and compensation information according to company policies and information security practices.
• Perform other duties as needed.

Knowledge, skills, and abilities

• Strong knowledge of data analysis, reporting, business intelligence, and data visualization practices.
• Advanced Excel skills, including complex formulas, pivot tables, lookup functions, Power Query, data modeling, and analytical reporting.
• Strong Power BI skills in dashboard development, data modeling, report design, and visualization.
• Ability to develop complex workforce models, headcount projections, labor cost reporting, and scenario analysis.
• Working knowledge of HR metrics, workforce data, organizational structures, and employee lifecycle information.
• Ability to work with compensation and payroll data using established definitions and reporting requirements.
• Ability to extract, combine, transform, and analyze large datasets from multiple systems and sources.

Requirements

• Strong knowledge of data analysis, reporting, business intelligence, and data visualization practices.
• Advanced Microsoft Excel proficiency, including complex formulas, pivot tables, lookup functions, Power Query, data modeling, and analytical reporting.
• Strong Power BI proficiency, including dashboard development, data modeling, report design, and data visualization.
• Ability to develop and maintain complex workforce and organizational models, including headcount projections, labor cost reporting, and scenario analysis.
• Working knowledge of HR metrics, workforce data, organizational structures, and employee lifecycle information.
• Ability to use compensation and payroll data within workforce analytics while following established definitions and reporting requirements.
• Ability to extract, combine, transform, and analyze large datasets from multiple systems and sources.