Human Resources Compensation Specialist

Collabera; North Chicago (IL); On-site; USD 41,000 - 52,000; Full time

Job summary

Collabera in North Chicago, IL seeks a Total Rewards Business Partner to lead compensation analysis, market benchmarking, and HR data validation. The role stresses advanced Excel, data integrity, and cross-functional collaboration to support total rewards programs.

The candidate will develop compensation recommendations for hires, promotions, and transfers, maintain reports and dashboards, and assist with annual cycles and salary structure updates in a fast-paced environment.

Qualifications

• Bachelor's degree or equivalent in HR, business, finance, analytics or related field.
• 2–4 years of experience supporting compensation, total rewards, HR analysis, or related programs.
• Advanced Microsoft Excel skills including Pivot Tables, VLOOKUP, INDEX MATCH, SUMIFS, AVERAGEIFS, and complex formula development.

Responsibilities

• Develop compensation recommendations for new hires, promotions and internal transfers while ensuring market competitiveness and internal equity.
• Analyze compensation and rewards data to identify trends, opportunities, and potential issues.
• Conduct audits and validations to ensure accuracy of employee compensation data across HR systems.
• Maintain compensation tools, reports, dashboards, and related tracking mechanisms.
• Support job evaluations, salary benchmarking, and market pricing activities.

Skills

Advanced Excel

Analytical thinking

Data interpretation

Independent work

Education

Bachelor's degree in HR/Business/Finance/Analytics

Tools

Workday

Power BI

Job description

Job Summary

The Total Rewards Business Partner supports compensation and rewards programs for a leading global organization. This role is responsible for compensation analysis, market benchmarking, HR data validation, reporting, and providing guidance on total rewards practices. The ideal candidate will possess advanced Excel expertise, strong analytical capabilities, and experience working with compensation programs and HR systems.

Key Responsibilities

• Develop compensation recommendations for new hires, promotions, and internal transfers while ensuring market competitiveness and internal equity.
• Analyze compensation and rewards data to identify trends, opportunities, and potential issues.
• Conduct audits and validations to ensure accuracy of employee compensation data across HR systems.
• Maintain compensation tools, reports, dashboards, and related tracking mechanisms.
• Support job evaluations, salary benchmarking, and market pricing activities.
• Assist with annual compensation cycles, salary structure maintenance, and rewards program administration.
• Serve as a resource for routine total rewards and compensation-related inquiries.
• Prepare reports and analyses to support business decisions and compensation initiatives.
• Collaborate with cross-functional teams to ensure consistency and compliance with compensation guidelines.
• Support additional compensation projects and ad hoc analyses as needed.

Required Qualifications

• Bachelor's degree in Human Resources, Business Administration, Finance, Analytics, or a related field.
• 2-4 years of experience supporting compensation, total rewards, HR analysis, or related programs.
• Advanced Microsoft Excel skills including Pivot Tables, VLOOKUP, INDEX MATCH, SUMIFS, AVERAGEIFS, and complex formula development.
• Strong analytical and problem-solving skills with the ability to interpret complex datasets.
• Experience working with HRIS platforms such as Workday or similar systems.
• Excellent attention to detail and commitment to data integrity and accuracy.
• Strong written and verbal communication skills.
• Ability to work independently in a fast-paced and evolving environment.

Preferred Qualifications

• Experience with compensation benchmarking and salary surveys.
• Knowledge of Power BI or other data analytics and reporting tools.
• Experience supporting annual compensation planning processes.
• Familiarity with total rewards program administration.

Benefits

The Company offers the following benefits for this position, subject to applicable eligibility

requirements

medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, paid time off, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, and paid holidays annually - as applicable.

Pay Range

$30/hr to $38/hr