Compensation Analyst: Market Benchmarking & Analytics

Addison Group; Irving (TX); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401(k) plan

Job summary

Addison Group is seeking a Compensation Analyst to support compensation analysis, benchmarking, incentive administration, job architecture, and reporting. The role emphasizes handling highly confidential data with accuracy and discretion, requiring advanced Excel skills and strong analytical abilities.

The ideal candidate will benchmark positions against market data, assist with incentive programs, maintain salary structures, and prepare reports for leadership.

Qualifications

• 3+ years of professional compensation experience.
• Advanced Microsoft Excel skills, including PivotTables, VLOOKUP, XLOOKUP, Power Query.
• Experience with compensation surveys, market-pricing resources, salary benchmarking, and job architecture.
• Strong research skills and the ability to independently evaluate competitor compensation practices and market data.
• Demonstrated discretion when handling confidential information, including employee salaries, incentive calculations, and bonus payments.
• General knowledge of total rewards programs is strongly preferred.
• Experience with Power BI is a plus.

Responsibilities

• Benchmark internal positions against market survey benchmarks and develop compensation recommendations for new positions, job offers, and off-cycle requests.
• Assist with multiple short-term incentive programs, including confirming employee eligibility, gathering data, calculating awards, auditing results, and preparing payout files.
• Maintain and revise salary structures, compensation ranges, and pay scales during annual review cycles and as business needs arise.
• Evaluate positions and provide recommendations regarding job levels, grades, and appropriate salary ranges.
• Maintain job architecture information, including job functions, families, sub-families, career levels, occupational categories, and pay bands.
• Coordinate compensation survey participation by managing deadlines, preparing and validating company data, submitting responses, and reviewing purchased survey results for accuracy.
• Prepare recurring reports and complete ad hoc compensation analyses for leadership and internal stakeholders.
• Research competitor compensation programs and analyze market pay practices across job titles, departments, and geographic locations.
• Maintain detailed salary range spreadsheets and calculate labor-cost and market-related compensation metrics.
• Support monthly, quarterly, and annual bonus and incentive payment processes.
• Assist with upcoming compensation projects and the continued development of consistent salary structures across the organization.
• Create, maintain, and organize complex Excel reports using PivotTables, VLOOKUP, XLOOKUP, Power Query, and other advanced data-management functions.
• Review all calculations and reporting for accuracy while meeting multiple time-sensitive deadlines.

Skills

Analytical skills

Advanced Excel

Power BI

Compensation surveys

Research skills

Discretion with data

Tools

PivotTables

VLOOKUP

XLOOKUP

Power Query

Job description

Addison Group is seeking a Compensation Analyst to support compensation analysis, benchmarking, incentive administration, job architecture, and reporting. The role emphasizes handling highly confidential data with accuracy and discretion, requiring advanced Excel skills and strong analytical abilities.

The ideal candidate will benchmark positions against market data, assist with incentive programs, maintain salary structures, and prepare reports for leadership.