Contract Compensation Analyst – Excel & Data Analytics

The Addison Group; Irving (TX); On-site; USD 48,000 - 69,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 in Irving, TX for a long-term contract. The role focuses on compensation analysis, salary benchmarking, incentive administration, and job architecture, with strong emphasis on Excel reporting and data integrity.

The ideal candidate will manage confidential compensation data, produce regular and ad hoc analyses, and support survey participation while driving market-aligned pay structures. Strong Excel and Power BI skills are required.

Qualifications

• 1–3 years of professional compensation experience in an analytical role.
• Advanced Microsoft Excel including PivotTables, VLOOKUP, XLOOKUP, and Power Query.
• Experience with compensation surveys, market-pricing resources, salary benchmarking, and job architecture.
• Strong research skills and ability to independently evaluate competitor data.
• Discretion handling confidential information including salaries and incentive calculations.
• General knowledge of total rewards programs; Power BI is a plus.

Responsibilities

• Compare internal positions against market benchmarks and develop compensation recommendations.
• Assist with short-term incentive programs: eligibility, data, awards, auditing, payout files.
• Maintain and revise salary structures, ranges, and pay scales during reviews.
• Evaluate positions for levels, grades, and salary ranges.
• Maintain job architecture info: functions, families, levels, categories, pay bands.
• Coordinate compensation survey participation and validate company data.
• Prepare recurring reports and ad hoc compensation analyses.
• Research competitor pay practices across titles, departments, locations.
• Maintain salary range spreadsheets and labor-cost metrics.
• Support bonus/incentive payment processes monthly/quarterly/annually.
• Contribute to development of consistent salary structures across the organization.
• Create and organize complex Excel reports using PivotTables, VLOOKUP, XLOOKUP, Power Query.
• Review calculations and reporting for accuracy against deadlines.

Skills

Analytical skills

Advanced Excel

Discretion handling confidential data

Research skills

Strong data interpretation

Power BI knowledge

Tools

PivotTables

VLOOKUP

XLOOKUP

Power Query

Power BI

Job description

Addison Group is seeking a Compensation Analyst in Irving, TX for a long-term contract. The role focuses on compensation analysis, salary benchmarking, incentive administration, and job architecture, with strong emphasis on Excel reporting and data integrity.

The ideal candidate will manage confidential compensation data, produce regular and ad hoc analyses, and support survey participation while driving market-aligned pay structures. Strong Excel and Power BI skills are required.