Sales Compensation Analyst – Commercial Modeling, Governance Automation

This is a fully remote position, open to applicants in United States, +10 more locations.

📋 Description

• Transform and engineer intricate commercial deal structures into structured algorithmic logic and standardized business rules.

• Model and analyze the financial implications of proposed changes to compensation plans and crediting rules.

• Execute Python and SQL scenario analyses on historical payout data.

• Collaborate with Revenue Operations and Legal/Deal Desk on unique transaction structures.

• Develop and maintain automated reconciliation engines utilizing Python, Alteryx, and SQL.

• Conduct cross-comparisons of ledger revenues, CRM bookings, and computed commissionable revenue.

• Create variance detection models to identify revenue double-counting, territory misalignment, unassigned account credits, and clawback discrepancies.

• Design and uphold governance control frameworks and manual-adjustment approval processes.

• Oversee quarterly and annual SOX audit documentation.

• Execute automated control test queries for comprehensive calculation traceability.

• Design and manage enterprise Power BI reporting suites utilizing DAX and Power Query M.

• Create real-time dashboards for data health and anomaly monitoring.

• Present variance summaries, root cause analyses, and actionable insights to Finance and Commercial leadership.

• Transform legacy workflows into structured Standard Operating Procedures (SOPs) with defined Service Level Agreements (SLAs).

• Act as the senior technical point of contact for Commercial and Finance stakeholders.

• Perform technical peer reviews of queries, code updates, and configuration changes prior to production deployment.

⛳️ Requirements

• Minimum of 5 years in sales compensation analytics, financial modeling, or commercial data governance within a multinational company.

• Advanced proficiency in SQL for data modeling, validation, and complex multi-table reconciliation.

• Practical experience with Python/Pandas or Alteryx for developing automated reconciliation workflows, variance detection models, and data pipeline scripts.

• Advanced expertise in Power BI, including data modeling, star schema design, complex DAX measures, and Power Query M transformations.

• Demonstrated experience working within SOX-compliance frameworks.

• Experience in designing audit-ready controls, executing automated control test queries, and creating end-to-end calculation traceability documentation.

• Background in B2B SaaS or subscription-based sales compensation environments.

• Experience in presenting complex data logic and compensation model results to Finance and Commercial executive leadership.

• Ability to translate intricate commercial contract mechanics into structured algorithmic logic.

• Experience collaborating with Revenue Operations and Legal/Deal Desk.

• Proven experience in building real-time dashboards for data health and anomaly monitoring.

• Experience in designing and maintaining standardized adjustment protocols.

• Demonstrated capability in conducting technical peer reviews.

• Indefinite right to work in the United States.

🏝️ Benefits

• Annual incentive plan.

• Health care coverage.

• Generous time off.

• Continuous learning resources.

• Competitive pay.

• Retirement planning.

• Continuing education program.

• Company-matched student loan contribution.

• Financial wellness programs.

• Family benefits and perks.

• Retail discounts.

• Referral incentive awards.