HR Data Analyst

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 headcount projections, labor cost reporting, and scenario analysis.
• Working knowledge of Human Resources metrics, workforce data, organizational structures, and employee lifecycle information.
• Ability to work with compensation and payroll data as inputs to broader workforce analytics while applying established data definitions and reporting requirements.
• Ability to extract, combine, transform, and analyze large datasets from multiple systems and sources.
• Strong analytical and problem-solving skills with the ability to identify trends, investigate discrepancies, and develop meaningful insights.
• Ability to interpret business requirements and translate them into effective reporting tools, dashboards, and analytical models.
• Strong attention to detail with the ability to validate calculations, reconcile information, and maintain data accuracy.
• Ability to communicate complex analytical findings clearly through dashboards, visualizations, written summaries, and presentations.
• Ability to manage multiple reporting requests, analytical projects, and deadlines independently.
• Strong proficiency in Microsoft Outlook, Word, Excel, and PowerPoint, including the ability to develop professional presentations and communicate analytical findings.
• Ability to maintain confidentiality and appropriately manage sensitive employee, compensation, and organizational information.

Experience/Qualifications:

• Bachelor’s degree in Business Analytics, Data Analytics, Human Resources, Finance, Information Systems, Mathematics, or related field preferred.
• 2 to 4 years of experience in data analytics, business intelligence, Human Resources reporting, workforce analytics, or related experience.
• Experience developing dashboards and analytical reports using Power BI and Microsoft Excel preferred.
• Experience working with HR, payroll, workforce, or organizational data preferred.
• Experience developing data models, automating reporting processes, and integrating information from multiple data sources preferred.
• Experience with SQL, Power Query, or related data transformation and modeling tools preferred.

Competencies:

• Applies strong analytical thinking to evaluate complex data, identify patterns, and develop meaningful insights that support Human Resources decisions.
• Demonstrates technical proficiency by developing accurate, efficient, and user-friendly dashboards, models, and analytical tools.
• Takes ownership of assigned reporting and analytical activities, ensuring accuracy, completeness, and timely delivery.
• Solves data and reporting challenges by investigating underlying issues, evaluating available information, and implementing practical solutions.
• Collaborates effectively with Human Resources and business stakeholders to understand analytical needs and deliver relevant reporting solutions.
• Communicates data findings clearly and translates technical information into understandable business insights.
• Maintains a high level of accuracy and attention to detail when developing models, validating data, and preparing reports.
• Identifies opportunities to automate reporting, improve data quality, and enhance analytical capabilities.
• Adapts to changing business requirements, reporting priorities, and analytical needs while maintaining quality and reliability.

Working Environment/Safety Requirements/Physical Requirements:

Performs work primarily in a standard office environment and must be able to remain seated for extended periods while working on a computer, with occasional standing, walking, and lifting of light office materials.