HR Data Analyst

MAI WEALTH MANAGEMENT; Independence Township (OH); On-site; USD 65,000 - 95,000; Full time

Job summary

MAI WEALTH MANAGEMENT in Ohio seeks an HR Data Analyst to collect, analyze, validate, and report employee data, building reports, dashboards, and insights for the CHRO and HRBPs. The role supports workforce planning, talent management, and engagement initiatives by translating data into actionable recommendations and collaborating with HR, Finance, IT, and business leaders.

A Bachelor's degree and 2–4+ years of HR analytics experience, with proficiency in ADP HRIS, Excel, Power BI, and Tableau,

Qualifications

• 2–4+ years of HR analytics, reporting, and data interpretation experience.
• Experience with HRIS platforms and analytics tools, preferably ADP.
• Advanced Excel skills and experience with reporting/dashboard tools (Power BI/Tableau).
• Relevant HR/people analytics certification preferred (e.g., SHRM-CP, PHR).

Responsibilities

• Collect and maintain HR data from HRIS and other sources for payroll, benefits, and initiatives.
• Develop recurring and ad hoc reports, dashboards, and scorecards for key HR metrics.
• Analyze workforce trends and provide actionable insights to HR leadership.
• Translate data findings into clear recommendations for non-technical stakeholders.
• Support strategic HR initiatives like workforce planning, engagement, and retention strategies.
• Collaborate with HR, Finance, IT and other partners to deliver analytics solutions.
• Identify opportunities to streamline reporting and improve data workflows.

Skills

Data analysis

Advanced Excel

Power BI

Tableau

Data visualization

Stakeholder communication

HR analytics

Education

Bachelor's degree in Human Resources, Business Administration, Business Analytics, Industrial/Organizational Psychology, or related field

Tools

ADP Workforce Now

ADP TotalSource

Power BI

Tableau

SQL

Job description

GENERAL JOB DESCRIPTION

The HR Data Analyst supports data-driven decision-making across Human Resources by collecting, analyzing, validating, and reporting employee and organizational data. This role develops reports, dashboards, and insights that help the CHRO and HRBPs identify workforce trends, measure program effectiveness, improve processes, and support organizational goals.

MAJOR DUTIES AND RESPONSIBILITIES

• Collect and maintain HR data: Gather, organize, and maintain employee and workforce data from HRIS for payroll, benefits, talent acquisition, learning, performance, engagement surveys, and other relevant sources.
• Ensure data accuracy and integrity: Audit, clean, validate, and reconcile HR data to identify errors, inconsistencies, duplicates, or gaps; partner with HR BPs, HR Operations Manager, and other system owners to correct issues.
• Develop reports and dashboards: Create and maintain recurring and ad hoc reports, dashboards, and scorecards that track key HR metrics such as headcount, turnover, retention, hiring activity, time-to-fill, internal mobility, engagement, absenteeism, training completion, and workforce demographics.
• Analyze workforce trends: Interpret HR data to identify patterns, risks, opportunities, and insights related to staffing, turnover, recruiting, employee experience, performance, compensation, learning, and organizational effectiveness.
• Translate data into insights: Present findings in a clear, concise, and actionable format for HR leaders, business partners, managers, and executive stakeholders; explain what the data means and how it can inform decisions.
• Support strategic HR initiatives: Provide analytical support for workforce planning, talent management, employee engagement, retention strategies, performance programs, compensation reviews, organizational design, and diversity-related reporting.
• Partner with stakeholders: Collaborate with HR team members, business leaders, Finance, IT, and other partners to understand reporting needs, define metrics, document requirements, and deliver meaningful analytics solutions.
• Improve HR processes and reporting: Identify opportunities to streamline reporting, automate recurring tasks, standardize metrics, improve data workflows, and increase the efficiency and reliability of HR analytics processes.

EXPERIENCE/CREDENTIALS

• Bachelor's degree in Human Resources, Business Administration, Business Analytics, Industrial/Organizational Psychology, or a related field.
• 2-4+ years of HR experience, preferably with a focus on workforce analytics, employee engagement, HRIS reporting, and data interpretation.
• Experience with HRIS platforms and analytics tools; ADP Workforce Now and/or ADP TotalSource preferred.
• Advanced Microsoft Excel skills and experience required.
• Experience with reporting or dashboard tools such as Power BI or Tableau; SQL or other query language experience a plus.
• Relevant HR or people analytics certification preferred, such as SHRM-CP, PHR, SHRM People Analytics Specialty Credential, or AIHR People Analytics Certificate.

COMPETENCIES

• Strong analytical, organizational, interpersonal, and problem-solving skills.
• Ability to translate complex data into clear, actionable insights for non-technical stakeholders.
• Proficiency with HR analytics, reporting, and visualization tools, including Excel, Power BI, or Tableau.
• Collaborative, adaptable, and able to work effectively in both independent and team-based settings.
• Maintains confidentiality, discretion, professionalism, and a high level of integrity.