Human Resources Analyst

SmithGroup’s Corporate office is hiring a Human Resources Analyst in Detroit, MI (hybrid) to turn HR and compensation data into actionable reporting and Power BI insights.

Responsibilities

• Collect, validate, and analyze HR, payroll, compensation, and workforce data from HR systems and internal and external sources
• Build recurring and ad hoc reports using HRIS reporting tools, Excel, Power BI, and other analytics platforms
• Analyze compensation, turnover, workforce planning, demographics, and other key HR metrics to surface trends and opportunities
• Develop, maintain, and improve Power BI dashboards, reports, and analytics tools focused on workforce and compensation insights
• Support compensation programs using market pricing, benchmarking, salary survey participation, salary structure administration, and compensation analysis
• Assist with annual merit review and compensation cycles, including data preparation, auditing, reporting, testing, and issue resolution
• Conduct regular audits of HR and compensation data to support accuracy, consistency, and reliable reporting
• Help maintain and optimize HR systems through testing, upgrades, reporting support, user assistance, and process improvements
• Share analytical findings and recommendations via reports, dashboards, visualizations, and stakeholder-ready summaries
• Create documentation, procedures, and training materials for HR systems, reporting, and compensation processes

Requirements

• Bachelor’s degree in Human Resources, Business, Data Analytics, or a related field
• 3-5 years of experience in human resources, HR analytics, compensation, HR systems, or a related analytical role
• 3-5 years working with HRIS platforms; UKG Pro experience is preferred
• Hands-on experience supporting compensation programs, including salary structures, market benchmarking, salary surveys, and compensation analysis
• Advanced Microsoft Excel skills, including complex formulas, PivotTables, lookup functions, and data cleaning or transformation
• Experience building reports, dashboards, and visualizations using Power BI or similar business intelligence tools
• Strong analytical and problem-solving skills with the ability to convert data into practical recommendations
• Exceptional attention to detail, including experience auditing and validating data
• Ability to manage confidential information and collaborate effectively with HR, payroll, and business stakeholders

Technology Focus

• HRIS reporting tools, Excel, Power BI, and business intelligence tools
• Power BI dashboards, Microsoft Excel (PivotTables, lookup functions, data cleaning/transformation)
• UKG Pro, HR systems

Compensation and Location

• Location: Detroit, MI (hybrid)
• Salary: USD 73,000 - 88,000 per year

Benefits

• Flexible scheduling
• Hybrid work environment
• 3 weeks of PTO within your first year, with option to purchase additional time off
• 8 paid federal holidays
• 15 extra Fridays off
• Medical, dental, and vision coverage
• Wellbeing resources
• Paid parental leave
• Flex spending account
• Voluntary insurance options
• 401(k) program with employer matching
• Tuition reimbursement program
• One-on-one career coaching
• Professional development opportunities
• Performance-based bonus each year
• Option of purchasing additional PTO