Sales Compensation Modeling Lead

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

Benefits offered by this job

Health & Wellness

Flexible Downtime

Continuous Learning

Invest in Your Future

Family Friendly Perks

Beyond the Basics

Job summary

S&P Global Inc. is seeking a quantitative specialist to design and run simulations for sales compensation planning, forecast commission accruals, and deliver predictive analytics. You will model stress scenarios, test plan changes, and translate results into actionable guidance for global sales leadership.

The role emphasizes Python, SQL, Alteryx, and Power BI capabilities, with a focus on cross-functional collaboration across Commercial and Finance. 5+ years in related fields are preferred.

Qualifications

• 5+ years of experience in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organisation.
• Advanced financial modelling: nested logic models, dynamic arrays, Monte Carlo or multi-variable simulations for forecasting and risk quantification.
• Coding and automation: Python (Pandas/NumPy) or Alteryx with SQL querying across large datasets.
• Power BI development: building sophisticated dashboards with DAX and star-schema architectures for executives.
• Strategic communication: translating modelling outputs into structured recommendations for senior leadership.

Responsibilities

• Build and maintain dynamic forecasting models for sales compensation expense and commission accruals.
• Perform stress-testing and sensitivity analyses on compensation structures to identify risks and distortions.
• Develop plan effectiveness metrics linking compensation to product profitability and ACV.
• Create automated Power BI dashboards tracking global compensation metrics for leadership.
• Develop and maintain script-based scenario calculators using Python, SQL, and Alteryx.
• Collaborate with Data Architecture to automate data ingestion from data warehouses into modelling workspaces.

Skills

Financial modelling

Quantitative analysis

Monte Carlo simulation

Data manipulation

Executive communication

Tools

Python (Pandas/NumPy)

SQL

Alteryx

Power BI

Excel (Power Query)

Job description

S&P Global Inc. is seeking a quantitative specialist to design and run simulations for sales compensation planning, forecast commission accruals, and deliver predictive analytics. You will model stress scenarios, test plan changes, and translate results into actionable guidance for global sales leadership.

The role emphasizes Python, SQL, Alteryx, and Power BI capabilities, with a focus on cross-functional collaboration across Commercial and Finance. 5+ years in related fields are preferred.