Sales Compensation Analyst, Financial Modeling – Planning

This is a fully remote position, open to applicants in Colorado, +8 more states.

📋 Description

• Create and manage simulation and scenario models that regulate incentive expenditures across the international sales team.

• Anticipate commission accruals and provide predictive analytics that align with departmental financial objectives.

• Develop and implement dynamic financial forecasting models utilizing Python, NumPy, Pandas, advanced Excel, and Power Query.

• Model sales compensation expenses, simulate global commission accruals, and assist with FP&A alignment and month-end payout projections.

• Conduct multi-variable stress tests and sensitivity analyses on compensation frameworks.

• Project risk boundaries and tail-risk exposure while identifying plan distortions, unexpected payouts, and quota cliffs.

• Design and calculate metrics for plan effectiveness.

• Analyze the correlations between compensation expenses, product line profitability, and net new ACV.

• Assess the ROI and behavioral impact of SPIFFs, strategic account bonuses, and multipliers for multi-year contracts.

• Create and sustain automated Power BI executive dashboards.

• Convert quantitative modeling results into executive presentations and briefing materials for Commercial and Finance leadership.

• Develop reusable scenario calculators utilizing Python, SQL, and Alteryx.

• Facilitate quick simulations of mid-year crediting and plan modifications.

• Maintain version-controlled mathematical repositories for longitudinal baseline comparisons.

• Collaborate with Data Architecture teams to automate data ingestion from enterprise data warehouses.

• Ensure the integrity of pipelines, data freshness, and accuracy in modeling.

⛳️ Requirements

• Over 5 years of experience in financial modeling, quantitative compensation analysis, corporate FP&A, or incentive strategy within a multinational organization.

• Proven experience in constructing nested logic models, dynamic array models, and Monte Carlo or multi-variable sensitivity simulations for extensive compensation expense forecasting and risk quantification.

• Proficient in using Python (Pandas/NumPy) or Alteryx for data manipulation and programmatic financial modeling.

• Advanced SQL querying skills across large, multi-table datasets.

• Experience in developing complex Power BI data visualization models employing advanced DAX measures and star-schema architectures.

• Ability to synthesize intricate quantitative modeling outputs into structured recommendations for senior Finance and Commercial executives.

• Must have the legal right to work indefinitely in the United States.

• Preferred: experience with Adaptive Insights, Anaplan, or Workday Adaptive.

• Preferred: familiarity with Monte Carlo simulation or probabilistic modeling techniques.

• Preferred: experience in constructing attainment distribution analyses and assessing quota cliffs.

• Preferred: experience in analyzing compensation expense ratios, product line profitability, or net new ACV in a B2B SaaS or subscription-based sales environment.

• Preferred: experience maintaining version-controlled financial modeling repositories.

• Preferred: collaboration experience with Data Architecture or Data Engineering teams on automated data ingestion pipelines.

• Preferred: experience using Python SciPy, Statsmodels, or R for advanced statistical modeling.

🏝️ Benefits

• Annual incentive plan.

• Health care coverage.

• Generous time off.

• Continuous learning resources.

• Competitive pay.

• Retirement planning.

• Continuing education program.

• Company-matched student loan contributions.

• Financial wellness programs.

• Family benefits.

• Retail discounts.

• Referral incentive awards.