Commissions Analyst

Magna Legal Services

. Serve as administrator and business owner of CaptivateIQ, including plan configuration, user access, and system changes.

Posted 10/6/2026full-timeRemote • United StatesJuniorMid-Level💰 $90,000 - $120,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in commission administration, including plan configuration and accurate calculation of payouts. Proficient in data analysis and reconciliation, with strong communication skills to convey complex information effectively.

Highest-signal resume keywords

CaptivateIQ AdministrationCommission CalculationAdvanced Excel SkillsSQL Data ValidationIncentive Compensation Understanding

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Commission Payout ProcessingData ReconciliationComplex Model AuditingPlan ConfigurationAnalytical Problem-Solving

Soft Skills

Clear CommunicationAttention to DetailProject OwnershipSound Judgment

Tools & Technologies

CRM PlatformsERP SystemsBusiness Intelligence ToolsCommission-Management Platforms

Industry Keywords

FP&ASales OperationsSales CompensationFinanceData Analytics

Tech Stack

Tools & technologies

ERPSQL

About the role

Key responsibilities & impact

Serve as administrator and business owner of CaptivateIQ, including plan configuration, user access, and system changes.
Calculate, validate, and process commission payouts accurately and on time each pay cycle, identifying and resolving discrepancies before they reach payroll.
Translate commission plan terms, including quotas, tiers, accelerators, eligibility rules, splits, and adjustments, into accurate and auditable calculations in CaptivateIQ and supporting models.
Maintain CaptivateIQ plan configurations, commission models, calculation templates, supporting documentation, and version control.
Query and reconcile data across relevant systems to validate commissionable revenue, performance inputs, and payout results.
Investigate commission questions and discrepancies, trace issues to their source, and provide explanations to sales representatives and managers.
Verify attribution changes against source documentation before they reach commission statements.
Partner with Sales, Finance, and Revenue Operations to implement compensation plans, test calculation logic, and communicate plan changes.
Build plan scenarios in CaptivateIQ and present them to Sales, Finance, and HR.
Build and maintain reports, dashboards, and self-service tools for commission performance and expected payouts.
Recommend process, control, and data-quality improvements for commission administration.

Requirements

What you’ll need

Bachelor’s degree in finance, accounting, business, economics, data analytics, or a related field.
2-4 years of experience in FP&A, sales operations, sales compensation, finance, analytics, or a comparable analytical role.
Advanced Excel or Google Sheets skills, including experience building and auditing complex, multi-tab models using lookups, pivot tables, and conditional formulas.
Working SQL skills and the ability to pull, reconcile, and validate data across multiple sources are preferred.
Strong understanding of incentive compensation concepts and the ability to interpret plan documents and translate them into accurate calculations.
Excellent analytical and problem-solving skills, with close attention to detail and a disciplined approach to reconciliation and quality control.
Clear written and verbal communication skills, including the ability to explain complex calculations to non-technical audiences.
Demonstrated project ownership and the ability to manage a commission cycle or plan rollout from start to finish.
Sound judgment and discretion when handling confidential employee and compensation information.
Experience with CRM, ERP, business intelligence, or commission-management platforms is preferred.