Interim Compensation Analyst

JR United Kingdom; City Of London; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading company is seeking a detail-oriented Interim Compensation Analyst to assist in managing commission processes during a critical transition. This role requires strong Excel skills and involves analyzing complex datasets, while also maintaining manual processes until automation is completed. Ideal candidates should have a proven track record in compensation analysis, excellent attention to detail, and the ability to work independently in a fast-paced environment.

Qualifications

• Experience in commission or compensation analysis in a software/SaaS company.
• Strong Excel skills (pivot tables, formulas, VLOOKUP/XLOOKUP).
• Able to work accurately and reliably.

Responsibilities

• Create commission deal summaries and reconcile discrepancies.
• Extract and analyze data from multiple sales datasets.
• Work with sales managers to resolve commission-related queries.

Skills

Excel

Data analysis

Attention to detail

Problem-solving

Job description

Role: Interim Compensation Analyst

Location: London / Hybrid

Ref: EMC01

We’re looking for a sharp, detail-oriented Interim Compensation Analyst to support our commission processes during a critical transition period. This project is hands-on (Excel-heavy) and involves managing manual processes while automation is being built.

Responsibilities:

1. Create commission deal summaries and reconcile discrepancies between sales data, manager expectations, and payroll outputs.
2. Extract and analyze data across 10–20 sales datasets, covering 120+ reps across 30 entities.
3. Work directly with sales managers to clarify issues and resolve commission-related questions.
4. Maintain and troubleshoot manual processes during the development of automated solutions.
5. Ensure alignment between calculated commissions and payroll processing.
6. Manage ad hoc reconciliation and issue resolution as needed.

Requirements:

1. Experience in commission or compensation analysis within a software/SaaS company.
2. Strong Excel skills (pivot tables, formulas, VLOOKUP/XLOOKUP) and ability to handle messy or incomplete data.
3. Ability to work accurately and reliably with a 'get-it-done' attitude.
4. Excellent attention to detail and high reliability.
5. Empathy and patience, especially when dealing with salespeople’s pay.
6. Comfortable working in a fast-paced environment with minimal supervision.