Sales Compensation Analyst (Financial Modeling & Planning)

Overview

This role is for a quantitative Sales Compensation Analyst focused on financial modeling and planning. You will design, run, and maintain simulation and scenario models that support incentive spend planning across a global sales force, including forecasting commission accruals, stress-testing plan structures, and delivering predictive analytics aligned to divisional financial targets.

Responsibilities and Impact

• Build and execute dynamic financial forecasting models using Python (NumPy/Pandas) and advanced Excel/Power Query, including:
  • Simulating sales compensation expense under variable performance distributions
  • Modelling global commission accruals
  • Cross-referencing run-rate performance with historical seasonality trends to support FP&A alignment and month-end payout estimates
• Perform multi-variable stress-testing and sensitivity analyses on proposed compensation structures, including changes to:
  • Accelerator tiers
  • Commission caps
  • Milestone bonuses
  • Quota changes
  • Produce statistical attainment distributions to surface plan distortions, windfall payouts, and quota cliffs across global sales territories
• Design and compute plan effectiveness metrics, including evaluating:
  • Correlation between compensation expense, product line profitability, and net new Annual Contract Value (ACV)
  • ROI and behavioural impact of non-standard incentive programs such as SPIFFs, strategic account bonuses, and multi-year contract multipliers
• Develop and maintain automated Power BI executive dashboards tracking metrics such as:
  • Global commission expense ratios
  • Average realisation rates
  • CAC/COC ratios
  • Quota attainment curves
  • Translate quantitative modeling 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 to enable rapid simulation of 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 modeling workspaces, ensuring pipeline integrity, data freshness, and modeling accuracy across forecasting and planning outputs

Requirements

Basic Required Qualifications

• 5+ years of experience in financial modelling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organization
• Advanced financial modeling experience, including:
  • Nested logic models and dynamic array models
  • Monte Carlo or multi-variable sensitivity simulations for large-scale compensation expense forecasting and risk quantification
• Coding and automation experience, including:
  • Python (Pandas/NumPy) or Alteryx for data manipulation and programmatic financial modeling
  • Advanced SQL querying across large, multi-table datasets
• Power BI development experience, including:
  • Sophisticated Power BI data visualization models
  • Advanced DAX measures and star-schema architectures for executive-level reporting
• Strategic communication experience synthesizing complex quantitative modeling outputs (forecast results, stress-test findings, attainment analyses) into clear, structured recommendations for senior Finance and Commercial executives

Preferred Qualifications

• Experience using corporate financial planning tools such as Adaptive Insights, Anaplan, or Workday Adaptive in a compensation or revenue planning context
• Experience applying Monte Carlo simulation or probabilistic modeling 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 analyzing 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 modeling 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 modeling workspaces
• Experience using Python SciPy, Statsmodels, or R for advanced statistical modeling, including regression analysis and distribution fitting, in a sales compensation or FP&A context

Right to Work Requirements

• This role is limited to persons with indefinite right to work in the United States.

Compensation & Benefits (US Candidates Only)

• Anticipated base salary range: $70,817 to $125,091
• Final base salary will be based on geographic location and experience level, skill set, and training, licenses, and certifications.
• Eligible for an annual incentive plan.
• Additional benefits are available.

Location

• Virtual, New York, United States

Additional Information

• Posted On: 2026-11-02
• Job ID: 332270
• Grade Level (for internal use): 10