Sales Compensation Analyst (Financial Modeling & Planning)
Core
Design and run simulation and scenario models governing incentive spend across the global sales force, stress-testing plan structures and forecasting commission accruals to align compensation spend with financial targets.
Role type
Senior quantitative financial modeling analyst (sales compensation)
Builds
Dynamic financial forecasting models, automated Power BI executive dashboards, and script-based scenario calculators
Domain
Financial services / Sales compensation planning
Deliverable
production ML models
Required skills
Python (NumPy/Pandas), Advanced Excel/Power Query, SQL, Power BI (DAX), Monte Carlo simulation, Multi-variable sensitivity analysis, Statistical attainment distributions
Preferred skills
Adaptive Insights/Anaplan/Workday Adaptive, Python SciPy/Statsmodels/R, Regression analysis, Data pipeline automation
Technologies
Python, NumPy, Pandas, Excel, Power Query, Power BI, SQL, Alteryx, Adaptive Insights, Anaplan, Workday Adaptive
Responsibilities
Build dynamic financial forecasting models for sales compensation expense; Perform multi-variable stress-testing and sensitivity analyses on compensation structures; Design and compute plan effectiveness metrics linking expense to profitability; Develop automated Power BI dashboards for executive reporting; Build reusable scenario calculators using Python and SQL; Partner with Data Architecture teams to automate data ingestion pipelines
Seniority
Senior, hands-on IC
