Temp Compensation Analyst

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

Type of Employment: Long-Term Contract

Compensation: $35.00 - $50.00 / Per hour

Benefits: This position is eligible for medical, dental, vision, and 401(k).

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 three 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 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. Reasonable accommodation is available for qualified individuals with disabilities upon request.