HR Data Analyst

Vestis is hiring an HR Data Analyst to build reliable, scalable workforce reporting that HR and business leaders can use to make data-driven decisions. This onsite role in Roswell, GA focuses on turning HR, organizational, financial, and compensation data into dashboards, analytical models, and insights.

What you’ll do

• Develop, maintain, and enhance Human Resources dashboards, reports, and analytical tools using Power BI, Microsoft Excel, and other reporting technologies.
• Build and maintain workforce and organizational data models to support headcount reporting, labor cost analysis, and workforce planning.
• Create interactive Power BI dashboards and visualizations for workforce trends, organizational metrics, and key HR performance indicators.
• Develop advanced Excel models using complex formulas, pivot tables, Power Query, and other analytical capabilities.
• Analyze workforce data, including headcount, turnover, hiring, employee movement, organizational structures, employee demographics, and labor costs.
• Integrate compensation data into reporting models to provide visibility into payroll costs, compensation expenditures, and related workforce metrics.
• Support the Compensation team by creating and maintaining data extracts, reporting tools, and dashboards aligned to established compensation definitions and requirements.
• Standardize reporting through data definitions, calculations, and methodologies to keep HR dashboards consistent.
• Extract, transform, validate, and consolidate data from HR information systems, payroll systems, compensation platforms, and other sources.
• Automate recurring reporting, data preparation, and dashboard updates to improve efficiency, accuracy, and accessibility.
• Perform data validation, reconciliation, and quality reviews; investigate discrepancies, identify root causes, and coordinate corrections with system or process owners.
• Prepare recurring and ad hoc analyses and presentations for HR leadership and business stakeholders.
• Maintain documentation covering reporting processes, data sources, calculations, model assumptions, and dashboard functionality.
• Ensure appropriate handling of confidential employee and compensation information according to company policies and established information security practices.
• Perform other duties as needed.

What you bring

• 2+ years of experience in data analytics, business intelligence, HR reporting, workforce analytics, or related work.
• Strong knowledge of data analysis, reporting, business intelligence, and data visualization.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, lookup functions, Power Query, data modeling, and analytical reporting.
• Strong Power BI experience, 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 HR metrics, workforce data, organizational structures, and employee lifecycle information.
• Ability to work with compensation and payroll data as inputs to 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, including trend identification and discrepancy investigation.
• Ability to interpret business requirements and translate them into reporting tools, dashboards, and analytical models.
• Strong attention to detail for validation, reconciliation, and data accuracy.
• Clear communication of complex insights through dashboards, visualizations, written summaries, and presentations.
• Ability to manage multiple requests, analytical projects, and deadlines independently.
• Strong proficiency with Microsoft Outlook, Word, Excel, and PowerPoint for professional presentations and communication.
• Ability to maintain confidentiality with sensitive employee, compensation, and organizational information.
• Bachelor’s degree in Business Analytics, Data Analytics, Human Resources, Finance, Information Systems, Mathematics, or a related field preferred.
• Preferred: experience developing dashboards and analytical reports with Power BI and Excel; 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 transformation and modeling tools.

Tools you’ll use

• Power BI
• Microsoft Excel
• Power Query
• SQL
• Microsoft Outlook, Microsoft Word, PowerPoint
• HR information systems, payroll systems, compensation platforms

Work environment

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