Commissions Analyst - RevOps

What You'll Do

Commission Administration & Analysis

• Own and maintain the organization's commission calculator and supporting models in Microsoft Excel.
• Calculate monthly sales commissions across all regions in accordance with approved compensation plans and policies.
• Validate commission calculations through detailed quality assurance checks to ensure accuracy.
• Perform audits, reconciliations, and data validations to maintain high standards of commission accuracy.
• Prepare and communicate finalized commission payouts to Finance and Payroll within established timelines.

Data Management & Process Improvement

• Maintain commission-related data structures, mappings, and source data required for accurate calculations.
• Update and enhance commission calculation logic as business requirements evolve.
• Investigate and resolve commission discrepancies, calculation exceptions, and data quality issues.
• Document commission processes, controls, assumptions, and calculation methodologies.
• Identify opportunities to automate and improve commission administration processes for greater scalability and efficiency.

Cross-Functional Collaboration

• Partner with Revenue Operations, Sales Leadership, Finance, Payroll, HR, and regional stakeholders to resolve commission-related inquiries.
• Communicate data inconsistencies and recommend process improvements to relevant teams.
• Support month-end and quarter-end commission reporting, reconciliations, and audit requests.
• Serve as a trusted point of contact for commission calculations, validations, and payout inquiries.

What It Takes

Technical & Functional Expertise

• Bachelor's degree in Finance, Accounting, Business, Economics, Analytics, or a related discipline, or equivalent professional experience.
• 2 to 5 years of experience in commissions administration, sales operations, revenue operations, finance, payroll, or other analytical roles.
• Advanced proficiency in Microsoft Excel, including complex formulas, lookups, pivot tables, data validation, and financial modeling.
• Strong analytical and problem-solving skills with experience working with large datasets.
• Experience performing reconciliations, audits, and data validation with a high degree of accuracy.