Total Rewards & Compensation Analyst

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

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.