Sales Compensation Architect - Financial Modeling & Planning

Remote Jobs; New York (NY); On-site; 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

Job summary

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

The role requires advanced modelling, Python/SQL/Alteryx coding, and Power BI expertise, with the ability to translate complex results into 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 or multi-variable simulations for large-scale forecasting and risk quantification.
• Hands-on experience using Python (Pandas/NumPy) or Alteryx for data manipulation and programmatic modelling, plus SQL querying across large datasets.
• Power BI development with advanced DAX measures and star-schema architectures for executive reporting.
• Experience synthesising modelling outputs into clear recommendations for senior Finance and Commercial executives.

Responsibilities

• Build and execute dynamic forecasting models using Python and advanced Excel/Power Query to simulate compensation expenses.
• Perform multi-variable stress-testing and sensitivity analyses on compensation structures to forecast risk and identify distortions.
• Design and compute plan effectiveness metrics linking compensation to profitability and ACV.
• Develop and maintain automated Power BI dashboards tracking expense ratios, realization rates, and quota attainment curves.
• Create reusable scenario calculators using Python, SQL, and Alteryx for rapid mid-year plan adjustments.
• Collaborate with Data Architecture to automate data ingestion from warehouses into modelling workspaces.

Skills

Quantitative analysis

Financial forecasting

Strategic communication

Tools

Python

SQL

Alteryx

Power BI

Excel

Job description

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

The role requires advanced modelling, Python/SQL/Alteryx coding, and Power BI expertise, with the ability to translate complex results into executive-ready insights.