Commissions Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Act as the administrator and business owner of CaptivateIQ, overseeing plan configuration, user access, and system modifications.

• Accurately calculate, validate, and process commission payouts on time for each pay cycle, proactively identifying and resolving discrepancies prior to payroll submission.

• Convert commission plan terms—such as quotas, tiers, accelerators, eligibility criteria, splits, and adjustments—into precise and verifiable calculations in CaptivateIQ and supporting models.

• Maintain CaptivateIQ's plan configurations, commission models, calculation templates, related documentation, and version control.

• Query and reconcile data across relevant systems to confirm commissionable revenue, performance metrics, and payout outcomes.

• Investigate commission-related inquiries and discrepancies, tracing issues back to their origin, and providing clear explanations to sales representatives and managers.

• Confirm attribution changes against source documentation before they are reflected in commission statements.

• Collaborate with Sales, Finance, and Revenue Operations teams to implement compensation plans, test calculation logic, and communicate updates to plans.

• Develop plan scenarios in CaptivateIQ and present them to Sales, Finance, and HR teams.

• Create and maintain reports, dashboards, and self-service tools that reflect commission performance and anticipated payouts.

• Suggest enhancements for processes, controls, and data quality related to commission administration.

⛳️ Requirements

• A bachelor’s degree in finance, accounting, business, economics, data analytics, or a related discipline.

• 2-4 years of experience in FP&A, sales operations, sales compensation, finance, analytics, or a similar analytical role.

• Advanced proficiency in Excel or Google Sheets, with experience in constructing and auditing complex, multi-tab models using lookups, pivot tables, and conditional formulas.

• Preferred working knowledge of SQL, with the capability to extract, reconcile, and validate data across diverse sources.

• Strong comprehension of incentive compensation principles and the ability to interpret plan documents and convert them into accurate calculations.

• Exceptional analytical and problem-solving abilities, with meticulous attention to detail and a structured approach to reconciliation and quality assurance.

• Clear written and verbal communication skills, including the capacity to explain intricate calculations to non-technical audiences.

• Proven project ownership skills, with the ability to manage a commission cycle or plan rollout from inception to completion.

• Good judgment and discretion in handling confidential employee and compensation information.

• Experience with CRM, ERP, business intelligence, or commission-management platforms is preferred.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health, dental, and vision insurance plans.

• Generous paid time off and flexible working hours.

• Opportunities for professional development and career advancement.

• Collaborative and inclusive work environment.