Description
We are seeking a Sales Compensation Analyst – Financial Modelling and Planning to join our high-accountability, globally connected Sales Compensation team.
As S&P Global Market Intelligence's financial engine for sales compensation planning, you will design and run simulation and scenario models that govern incentive spend across the global sales force , stress-testing plan structures, forecasting commission accruals, and delivering predictive analytics that keep compensation spend aligned with divisional financial targets.
Responsibilities and Impact:
- Build and execute dynamic financial forecasting models using Python (NumPy/Pandas) and advanced Excel/Power Query
- Perform multi-variable stress-testing and sensitivity analyses on proposed compensation structures
- Design and compute plan effectiveness metrics , analysing the correlation between compensation expense, product line profitability, and net new Annual Contract Value (ACV)
- Develop and maintain automated Power BI executive dashboards tracking global commission expense ratios and quota attainment curves
- Build reusable, script-based scenario calculators using Python, SQL, and Alteryx
- Partner with Data Architecture teams to automate data ingestion from enterprise data warehouses into financial modelling workspaces
Compensation and Benefits (US Candidates Only):
- The anticipated base salary range for this position is $70,817 to $125,091
- This role is eligible for an annual incentive plan and additional S&P Global benefits
What We Are Looking For:
- 5+ years in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organisation
- Advanced Financial Modelling: Proven experience building nested logic models, dynamic array models, and Monte Carlo or multi-variable sensitivity simulations
- Coding and Automation: Hands-on experience using Python (Pandas/NumPy) or Alteryx for data manipulation and programmatic financial modelling
- Power BI Development: Demonstrated experience building sophisticated Power BI data visualisation models using advanced DAX measures and star-schema architectures
- Strategic Communication: Demonstrated experience synthesising complex quantitative modelling outputs into clear, structured recommendations for senior Finance and Commercial executives