Sales Compensation & Financial Modelling Analyst

S&P Global; Washington (District of Columbia); Remote; USD 71,000 - 125,000; Full time

Benefits offered by this job

Health care

Flexible downtime

Continuous Learning

Invest in Your Future

Family Friendly Perks

Beyond the Basics

Job summary

S&P Global is seeking a Sales Compensation Analyst – Financial Modelling And Planning to design and run simulation models that govern incentive spend across the global sales force. You will stress-test plan structures, forecast commission accruals, and deliver predictive analytics to align compensation with divisional targets.

The role requires expertise in Python, SQL, Excel, and Power BI, with a track record of producing executive-ready insights.

Qualifications

• 5+ years in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organisation.
• Advanced Financial Modelling with nested logic, dynamic arrays, and Monte Carlo/sensitivity simulations for forecasting.
• Hands-on coding using Python (Pandas/NumPy) or Alteryx and advanced SQL across large datasets.
• Experience building Power BI dashboards with advanced DAX and star-schema architectures.
• Ability to translate modelling outputs into clear recommendations for senior executives.

Responsibilities

• Build and execute dynamic forecasting models using Python and Excel to simulate compensation expense.
• Perform multi-variable stress-testing and sensitivity analyses on proposed compensation structures.
• Design and compute plan effectiveness metrics linking expense to profitability and ACV.
• Develop and maintain automated Power BI dashboards tracking global commission expenses and quota attainment.
• Create scenario calculators with Python/SQL/Alteryx for rapid mid-year plan adjustments.
• Partner with Data Architecture to automate data ingestion into modelling workspaces.

Skills

Financial modelling

Python (Pandas/NumPy) or Alteryx

Power BI Development

SQL querying

Strategic Communication

Tools

Python

Alteryx

Power BI

SQL

Job description

S&P Global is seeking a Sales Compensation Analyst – Financial Modelling And Planning to design and run simulation models that govern incentive spend across the global sales force. You will stress-test plan structures, forecast commission accruals, and deliver predictive analytics to align compensation with divisional targets.

The role requires expertise in Python, SQL, Excel, and Power BI, with a track record of producing executive-ready insights.