Sales Compensation Forecasting & Modelling Lead

S&P Global; City of Albany (NY); 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 is seeking a Sales Compensation Analyst – Financial Modelling And Planning to join a high-accountability, globally connected team. The role focuses on designing and running simulation models that govern incentive spend across the global sales force, stress-testing plan designs, and delivering predictive analytics to align compensation with financial targets.

The position requires 5+ years in financial modelling and FP&A, plus strong Python/SQL and Power BI capabilities.

Qualifications

• 5+ years in financial modelling, quantitative compensation analysis, FP&A, or incentive strategy within a multinational organisation.
• Proven nested logic models, dynamic array models, and Monte Carlo or multi-variable sensitivity simulations for large-scale compensation expense forecasting and risk quantification.
• Hands-on experience using Python (Pandas/NumPy) or Alteryx for data manipulation and programmatic financial modelling, with advanced SQL querying across large datasets.
• Power BI data visualisation with advanced DAX and star-schema architectures for executive reporting.
• Synthesis of complex modelling outputs into clear, structured recommendations for senior Finance and Commercial leaders.

Responsibilities

• Build and run dynamic forecasting models for sales compensation.
• Stress-test compensation structures and forecast risk boundaries.
• Design plan effectiveness metrics and evaluate ROI and behavioural impact of incentive programs.
• Develop and maintain automated Power BI dashboards tracking compensation metrics for exec leadership.
• Create reusable script-based scenario calculators using Python/SQL/Alteryx and maintain version-controlled repos.
• Collaborate with Data Architecture to automate data ingestion from warehouses into modelling workspaces.

Skills

Financial modelling

Quantitative analysis

Python/Alteryx coding

Power BI

Strategic communication

Tools

Adaptive Insights

Anaplan

Workday Adaptive

Job description

S&P Global is seeking a Sales Compensation Analyst – Financial Modelling And Planning to join a high-accountability, globally connected team. The role focuses on designing and running simulation models that govern incentive spend across the global sales force, stress-testing plan designs, and delivering predictive analytics to align compensation with financial targets.

The position requires 5+ years in financial modelling and FP&A, plus strong Python/SQL and Power BI capabilities.