Senior Sales Compensation Modelling Analyst

S&P Global; United States; Remote; USD 71,000 - 125,000; Full time

Job summary

S&P Global is seeking a Sales Compensation Analyst to design and run simulation models governing incentive spend for the global sales force. The role focuses on turning data into decisions, stress-testing plan structures, and forecasting compensation outcomes aligned with financial targets.

The position requires advanced financial modelling in Python and Excel, strong SQL/Alteryx skills, and the ability to translate modelling results into executive recommendations for FP&A and Commercial

Qualifications

• 5+ years in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organisation.
• Advanced Financial Modelling: nested logic models, dynamic array models, and Monte Carlo or multi-variable simulations for large-scale compensation expense forecasting and risk quantification.
• Coding and Automation: Python (Pandas/NumPy) or Alteryx for data manipulation and programmatic financial modelling, combined with advanced SQL querying capability across large, multi-table datasets.
• Power BI Development: sophisticated Power BI data visualisation models using advanced DAX measures and star-schema architectures for executive-level reporting.
• Strategic Communication: synthesising complex modelling outputs into clear, structured recommendations for senior Finance and Commercial executives.

Responsibilities

• Build and execute dynamic financial forecasting models using Python and Excel, simulating sales compensation expense.
• Perform multi-variable stress-testing and sensitivity analyses on proposed compensation structures.
• Design and compute plan effectiveness metrics relating compensation expense to product profitability and ACV, including ROI of non-standard incentive programs.
• Develop and maintain automated Power BI dashboards tracking global commission expense ratios, realisation rates, CAC/COC ratios, and quota attainment.
• Create reusable, script-based scenario calculators using Python, SQL, and Alteryx to enable rapid mid-year plan adjustments.

Skills

Financial modelling

Quantitative analysis

Strategic communication

Stress-testing

Forecasting

Tools

Python

SQL

Alteryx

Excel

Power BI

Job description

S&P Global is seeking a Sales Compensation Analyst to design and run simulation models governing incentive spend for the global sales force. The role focuses on turning data into decisions, stress-testing plan structures, and forecasting compensation outcomes aligned with financial targets.

The position requires advanced financial modelling in Python and Excel, strong SQL/Alteryx skills, and the ability to translate modelling results into executive recommendations for FP&A and Commercial