Commissions Analyst - RevOps

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.

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.

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.

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.