Strategic Compensation Analyst: Excel Expert

Gosnaphop; Irving (TX); On-site; USD 91,000 - 117,000; Full time

Job summary

Addison Group is seeking a Compensation Analyst in Irving, TX to support compensation analysis, benchmarking, incentive administration, job architecture, and reporting. Strong analytical skills and discretion with confidential data are essential.

The ideal candidate will have advanced Excel expertise (PivotTables, VLOOKUP, XLOOKUP, Power Query) and experience with compensation surveys and market data; familiarity with Power BI is a plus.

Qualifications

• 2+ years of compensation experience or analytical role.
• Advanced Excel with PivotTables, VLOOKUP, XLOOKUP, Power Query.
• Experience with compensation surveys, market-pricing resources, and job architecture.
• Ability to handle confidential information with discretion.

Responsibilities

• Compare internal positions to market benchmarks and develop compensation recommendations.
• Assist with short-term incentive programs: eligibility, data gathering, awards, auditing, payouts.
• Maintain and revise salary structures, ranges, and pay scales during reviews.
• Evaluate positions for job levels, grades, and salary ranges.
• Maintain job architecture information: functions, families, career levels, categories, and pay bands.
• Coordinate compensation survey participation and ensure data accuracy.
• Prepare recurring and ad hoc compensation analyses for leadership.
• Research competitor pay practices across titles, departments, locations.
• Maintain salary range spreadsheets and calculate labor-cost metrics.
• Support bonus and incentive processes monthly, quarterly, and annually.
• Assist with upcoming compensation projects and salary-structure development.
• Create and organize complex Excel reports using PivotTables, VLOOKUP, XLOOKUP, Power Query.

Skills

Advanced Excel

Data analysis

Confidential data handling

Market benchmarking

Tools

Power BI

PivotTables

VLOOKUP

XLOOKUP

Power Query

Job description

Addison Group is seeking a Compensation Analyst in Irving, TX to support compensation analysis, benchmarking, incentive administration, job architecture, and reporting. Strong analytical skills and discretion with confidential data are essential.

The ideal candidate will have advanced Excel expertise (PivotTables, VLOOKUP, XLOOKUP, Power Query) and experience with compensation surveys and market data; familiarity with Power BI is a plus.