Compensation Analyst

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

Job Title: Compensation Analyst

Location (city, state): Irving, TX

Work Schedule: M - F, 8 am - 5 pm

Type of Employment: Long-Term Contract

Compensation: $35 - $50 / hour

Industry: Professional Services

Benefits: This position may be eligible for medical, dental, vision, and 401(k) benefits, depending on individual selections and applicable work‑hour factors.

Job Description:

Addison Group is hiring a Compensation Analyst for our client. This position will support compensation analysis, salary benchmarking, incentive administration, job architecture, and reporting initiatives. The ideal candidate has strong analytical skills, advanced Excel expertise, and the ability to manage highly confidential compensation data with accuracy and discretion.

Key Responsibilities:

• Compare internal positions against relevant 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.

Qualifications:

• One to two years of professional compensation experience, preferably in an analytical role.
• Advanced Microsoft Excel skills, including PivotTables, VLOOKUP, XLOOKUP, Power Query, and experience combining and manipulating large datasets.
• Experience working 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.

Addison Group is an Equal Opportunity Employer. Addison Group provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Addison Group complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. Reasonable accommodation is available for qualified individuals with disabilities, upon request.