HR Data Analyst

Colonial Group; Roswell (GA); On-site; USD 70,000 - 100,000; Full time

Job summary

Colonial Group is seeking an HR Data Analyst in Roswell, GA. The role focuses on developing and maintaining HR dashboards and data models to support workforce analytics and data-driven decisions.

You will analyze headcount, turnover, hiring, compensation, and labor costs, while integrating data from HR, payroll, and finance systems. Strong Power BI and Excel skills are essential, with experience automating reports and maintaining data quality.

Qualifications

• Bachelor's degree preferred in relevant field.
• 2–4 years in data analytics or HR reporting.
• Experience building Power BI dashboards and Excel reports.
• Experience with HR/payroll data is a plus.
• Experience integrating data from multiple sources.

Responsibilities

• Develops and maintains HR dashboards and reports.
• Builds workforce data models for headcount and cost reporting.
• Creates Power BI dashboards to show workforce trends and metrics.
• Develops advanced Excel models for workforce reporting.
• Analyzes headcount, turnover, hires, and labor costs.
• Integrates compensation data into analytics and dashboards.
• Automates recurring reports and dashboard updates.
• Ensures data accuracy and maintains documentation.

Skills

Power BI

Excel

Data modeling

HR analytics

SQL

Data validation

Education

Bachelor's degree in Business Analytics, Data Analytics, HR, Finance, IS, Math, or related field

Tools

Power Query

Job description

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.