Sales Compensation Strategist: Financial Modelling

S&P Global; Oregon; Hybrid; 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

Retail Discounts

Job summary

S&P Global is seeking a Sales Compensation Analyst to design and run financial models that govern global incentive spend. You will stress-test plan structures, forecast accruals, and deliver analytics for executive decision-making across FP&A and Commercial teams.

The role emphasizes Python, SQL, and Power BI to create dashboards and KPI insights, with a focus on data-driven design of compensation plans and performance metrics.

Qualifications

• 5+ years in financial modelling, quantitative compensation analysis, or FP&A within a multinational organisation.
• Advanced financial modelling: nested logic models, dynamic arrays, Monte Carlo or multi-variable simulations.
• Coding and automation with Python (Pandas/NumPy) or Alteryx and strong SQL across large datasets.
• Power BI development with DAX measures and star-schema architectures for executive reporting.
• Ability to translate modelling results into clear recommendations for senior Finance/Commercial leadership.

Responsibilities

• Build and run dynamic forecasting models using Python and advanced Excel to simulate sales compensation expense and accruals.
• Perform multi-variable stress-testing and sensitivity analyses on compensation structures to forecast risk boundaries.
• Develop plan effectiveness metrics and KPI analyses linking compensation to profitability and ACV.
• Create automated Power BI dashboards tracking compensation metrics and present insights to executives.
• Develop script-based calculators (Python/SQL/Alteryx) for rapid scenario analysis across fiscal cycles.

Skills

Financial modelling

Python (NumPy/Pandas)

Alteryx

SQL

Power BI

Tools

Excel

Power Query

Job description

S&P Global is seeking a Sales Compensation Analyst to design and run financial models that govern global incentive spend. You will stress-test plan structures, forecast accruals, and deliver analytics for executive decision-making across FP&A and Commercial teams.

The role emphasizes Python, SQL, and Power BI to create dashboards and KPI insights, with a focus on data-driven design of compensation plans and performance metrics.