HR Data Analyst: Power BI & Compensation Insights

SmithGroup; Detroit (MI); Hybrid; USD 73,000 - 88,000; Full time

Benefits offered by this job

Hybrid work

PTO 3 weeks

Holiday pay

401(k) matching

Tuition reimbursement

Health benefits

Job summary

SmithGroup in Detroit is seeking a Human Resources Analyst to join our Corporate Office. You will collect and analyze HR, payroll, and compensation data, build reports and dashboards, and support compensation programs including market pricing and salary benchmarking.

Ideal candidates have a Bachelor's in HR or related field, 3–5 years of HR analytics, and strong Excel and Power BI skills. We offer hybrid work, generous PTO, benefits, 401(k) matching, and a clear path for professional development.

Qualifications

• Bachelor's degree in HR, business, data analytics, or related field.
• 3-5 years in HR analytics or compensation roles.
• UKG Pro experience preferred.
• Advanced Excel and data preparation skills.

Responsibilities

• Collect, validate, and analyze HR, payroll, compensation, and workforce data.
• Create recurring and ad hoc reports using HRIS tools and Excel.
• Develop, maintain Power BI dashboards and analytics.
• Support compensation programs through market pricing and benchmarking.
• Assist with merit reviews and compensation cycles.
• Audit HR and compensation data for accuracy.
• Present findings to stakeholders.

Skills

Advanced Excel

Power BI

Data analysis

Stakeholder communication

Education

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

Tools

UKG Pro

HRIS systems

SQL

Job description

SmithGroup in Detroit is seeking a Human Resources Analyst to join our Corporate Office. You will collect and analyze HR, payroll, and compensation data, build reports and dashboards, and support compensation programs including market pricing and salary benchmarking.

Ideal candidates have a Bachelor's in HR or related field, 3–5 years of HR analytics, and strong Excel and Power BI skills. We offer hybrid work, generous PTO, benefits, 401(k) matching, and a clear path for professional development.