Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global

New Jersey

On-site

USD 120,000 - 170,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health care coverage
Generous time off
Retirement planning
Education program with student loan

Job summary

S&P Global Market Intelligence is seeking a Sales Compensation Analyst with deep financial modelling expertise to design and run models that govern global incentive spend. You will stress-test plan structures, forecast commission accruals, and deliver analytics to align compensation with divisional targets.

You will build dynamic forecasting models using Python and advanced Excel and develop Power BI dashboards for executives, translating results into clear recommendations for Finance and

Qualifications

  • Proven experience building nested logic models and dynamic arrays.
  • Experience with Monte Carlo or multi-variable simulations for forecasting.
  • Strong Python (Pandas/NumPy) or Alteryx for data modelling.

Responsibilities

  • Stress-test compensation structures and forecast risk boundaries.
  • Develop plan effectiveness metrics vs profitability and ACV.
  • Build automated Power BI dashboards for global commission expenses.
  • Create script-based scenario calculators using Python, SQL, and Alteryx.
  • Collaborate with Data Architecture to automate data ingestion into modelling workspaces.

Skills

Advanced financial modelling
Python (Pandas/NumPy)
Alteryx
SQL
Power BI development
Monte Carlo simulations
Forecasting
Data storytelling
FP&A

Tools

Adaptive Insights
Anaplan
Workday Adaptive

Job description

10 Sales Compensation Analyst – Financial Modelling and Planning

We are a high-accountability, globally connected Sales Compensation team that values disciplined execution, a strong sense of urgency, and end-to-end ownership. This is a role for a quantitative specialist who thinks in models, simulates before deciding, and translates data into decisions. As S&P Global Market Intelligence's financial engine for sales compensation planning, you will design and run the simulation and scenario models that govern incentive spend across the global sales force — stress-testing plan structures, forecasting commission accruals, and delivering the predictive analytics that keep compensation spend aligned with divisional financial targets. Build and execute dynamic financial forecasting models using Python (NumPy/Pandas) and advanced Excel/Power Query — simulating sales compensation expense under variable performance distributions, modelling global commission accruals, and cross-referencing run-rate performance with historic seasonality trends to support FP&A alignment and month-end payout estimates.

Responsibilities
  • Perform multi-variable stress-testing and sensitivity analyses on proposed compensation structures — including shifts in accelerator tiers, commission caps, milestone bonuses, and quota changes — to forecast risk boundaries and tail-risk exposure, while constructing statistical attainment distributions to surface plan distortions, windfall payouts, and quota cliffs across global sales territories.
  • Design and compute plan effectiveness metrics — analysing the correlation between compensation expense, product line profitability, and net new Annual Contract Value (ACV), and evaluating the ROI and behavioural impact of non-standard incentive programs including SPIFFs, strategic account bonuses, and multi-year contract multipliers.
  • Develop and maintain automated Power BI executive dashboards tracking global commission expense ratios, average realisation rates, CAC/COC ratios, and quota attainment curves — translating complex quantitative modelling outputs into clear, narrative-driven executive presentations and briefing decks for Commercial and Finance leadership.
  • Build reusable, script-based scenario calculators using Python, SQL, and Alteryx — enabling compensation strategists to rapidly simulate mid-year crediting and plan adjustments — while maintaining version-controlled mathematical repositories for longitudinal baseline comparisons across fiscal cycles.
  • Partner with Data Architecture teams to automate data ingestion from enterprise data warehouses into financial modelling workspaces, ensuring pipeline integrity, data freshness, and modelling accuracy across all forecasting and planning outputs.

Final base salary for this role will be based on the individual's geographic location, as well as experience level, skill set, training, licenses and certifications.

Experience: 5+ years in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organisation.

Requirements
  • Advanced Financial Modelling: Proven experience building nested logic models, dynamic array models, and Monte Carlo or multi-variable sensitivity simulations for large-scale compensation expense forecasting and risk quantification.
  • Coding and Automation: Hands‑on experience using 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: Demonstrated experience building sophisticated Power BI data visualisation models using advanced DAX measures and star‑schema architectures for executive‑level reporting.
  • Demonstrated experience synthesising complex quantitative modelling outputs — including forecast results, stress‑test findings, and attainment analyses — into clear, structured recommendations for senior Finance and Commercial executives.
  • Experience using corporate financial planning tools — Adaptive Insights, Anaplan, or Workday Adaptive — in a compensation or revenue planning context.
  • Experience applying Monte Carlo simulation or probabilistic modelling techniques to sales compensation forecasting and tail‑risk exposure quantification.
  • Experience constructing attainment distribution analyses and quota cliff assessments to identify plan design distortions across global sales territories.
  • Experience analysing the correlation between compensation expense ratios — including CAC and COC ratios — and product line profitability or net new ACV in a B2B SaaS or subscription‑based sales environment.
  • Experience building and maintaining version‑controlled financial modelling repositories with longitudinal baseline data for multi‑year compensation plan performance comparisons.
  • Experience partnering with Data Architecture or Data Engineering teams to design automated data ingestion pipelines from enterprise data warehouses into financial modelling workspaces.
  • Experience using Python SciPy, Statsmodels, or R for advanced statistical modelling — including regression analysis and distribution fitting — in a sales compensation or FP&A context.
Advancing Essential Intelligence.

We're more than 35,000 strong worldwide—so we're able to understand nuances while having a broad perspective. Our team is driven by curiosity and a shared belief that Essential Intelligence can help build a more prosperous future for us all.From finding new ways to measure sustainability to analyzing energy transition across the supply chain to building workflow solutions that make it easy to tap into insight and apply it. We are changing the way people see things and empowering them to make an impact on the world we live in. We’re committed to a more equitable future and to helping our customers find new, sustainable ways of doing business. Join us and help create the critical insights that truly make a difference.

Integrity, Discovery, Partnership

Throughout our history, the world's leading organizations have relied on us for the Essential Intelligence they need to make confident decisions about the road ahead. We start with a foundation of integrity in all we do, bring a spirit of discovery to our work, and collaborate in close partnership with each other and our customers to achieve shared goals.

Benefits
  • Health & Wellness: Health care coverage designed for the mind and body.
  • Flexible Downtime: Generous time off helps keep you energized for your time on.
  • Invest in Your Future: Secure your financial future through competitive pay, retirement planning, a continuing education program with a company‑matched student loan contribution, and financial wellness programs.
  • Beyond the Basics: From retail discounts to referral incentive awards—small perks can make a big difference.

S&P Global is an equal opportunity employer and all qualified candidates will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, military veteran status, unemployment status, or any other status protected by law. If you need an accommodation during the application process due to a disability, please send an email to: EEO.202 - Middle Professional (EEO Job Group) (inactive), 20 - Professional (EEO-2 Job Categories-United States of America), FINANC202.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • Washington

Remote
USD 71,000 - 125,000
Health care
Flexible downtime
Continuous Learning
+3
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • Richmond (VA)

Remote
USD 71,000 - 125,000
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • Austin (TX)

Remote
USD 71,000 - 125,000
Health & Wellness
Flexible Downtime
Continuous Learning
+3
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • Cary (NC)

Remote
USD 71,000 - 125,000
Health care
Flexible downtime
Continuous learning
+2
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • Chicago (IL)

Remote
USD 71,000 - 125,000
Health care coverage
Retirement planning
Education & development programs
+2
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global Inc. • New York (NY)

Remote
USD 71,000 - 125,000
Health & Wellness
Flexible Downtime
Continuous Learning
+3
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • Hartford (CT)

Remote
USD 71,000 - 125,000
Sales Compensation Analyst (Financial Modeling & Planning)
Sales Compensation Analyst (Financial Modeling & Planning)

S&P Global • United States

Remote
USD 71,000 - 125,000
Sales Compensation Analyst (Commercial Modeling & Governance Automation)
Sales Compensation Analyst (Commercial Modeling & Governance Automation)

S&P Global • New Jersey

On-site
USD 120,000 - 180,000
Health & Wellness benefits
Flexible time off
Retirement planning & education
Sales Compensation Analyst (Commercial Modeling & Governance Automation)
Sales Compensation Analyst (Commercial Modeling & Governance Automation)

S&P Global • Virginia

On-site
USD 120,000 - 190,000