Sales Compensation Analyst: Modelling & Forecasting

S&P Global; Greater London; Vor Ort; GBP 53.000 - 93.000; Vollzeit

Benefits dieser Stelle

Health & Wellness

Flexible Downtime

Continuous Learning

Retirement planning

Education program + loan contribution

Family friendly perks

Zusammenfassung

S&P Global Market Intelligence is seeking a Sales Compensation Analyst – Financial Modelling and Planning to design and run simulation models that govern global incentive spend and forecast accruals. You will translate data into decisions that align compensation with divisional targets.

The role emphasizes Python/Excel modelling, Power BI dashboards, and automated scenario tools, with close collaboration across FP&A, Commercial leadership, and Data Architecture to ensure data integrity and

Qualifikationen

• 5+ years in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organisation.
• Advanced Financial Modelling: dynamic, nested logic, and Monte Carlo or multi-variable simulations for large-scale forecasting.
• Coding and Automation: Python (Pandas/NumPy) or Alteryx with SQL across large datasets.
• Power BI Development: sophisticated data visualisation with DAX in executive reporting.
• Strategic Communication: translate modelling outputs into clear recommendations for senior executives.

Aufgaben

• Build and execute dynamic forecasting models using Python and advanced Excel/Power Query to simulate compensation expense and validate run-rate against seasonality.
• Perform multi-variable stress-testing and sensitivity analyses on proposed incentive structures to forecast risks and distortions.
• Design and compute plan effectiveness metrics linking compensation expense to profitability and ACV.
• Develop automated Power BI dashboards tracking commission expense ratios, realization rates, and quota attainment.
• Build script-based scenario calculators with Python, SQL, and Alteryx for rapid mid-year adjustments and governance.
• Collaborate with Data Architecture to automate data ingestion from data warehouses into modelling workspaces.

Kenntnisse

Python (Pandas/NumPy)

Excel/Power Query

SQL

Power BI / DAX

Alteryx

Monte Carlo simulations

Statistical modelling (SciPy/Statsmods

Data manipulation

Tools

Adaptive Insights

Anaplan

Workday Adaptive

Jobbeschreibung

S&P Global Market Intelligence is seeking a Sales Compensation Analyst – Financial Modelling and Planning to design and run simulation models that govern global incentive spend and forecast accruals. You will translate data into decisions that align compensation with divisional targets.

The role emphasizes Python/Excel modelling, Power BI dashboards, and automated scenario tools, with close collaboration across FP&A, Commercial leadership, and Data Architecture to ensure data integrity and