Magna Legal Services Logo

Magna Legal Services

Commissions Analyst

Posted One Month Ago
Be an Early Applicant
Remote
Hiring Remotely in USA
90K-120K Annually
Mid level
Remote
Hiring Remotely in USA
90K-120K Annually
Mid level
Administers and analyzes sales commission programs, including plan configuration, payout calculations, reconciliations, discrepancy resolution, reporting, and plan modeling in CaptivateIQ. Partners with Sales, Finance, HR, and Revenue Operations to implement compensation plans, validate data, explain payouts, and improve controls and data quality. Builds spreadsheet models, queries SQL data, maintains documentation, and manages commission cycles from calculation through payment readiness.
The summary above was generated by AI

Magna Legal Services is a trusted nationwide partner to law firms, corporations, insurance carriers, and government agencies, delivering comprehensive legal support at every stage of a case. From court reporting and record retrieval to jury consulting, investigations, litigation graphics, and language services, we help our clients navigate complex legal challenges with confidence. Our reputation is built on the expertise, dedication, and professionalism of our team, and we’re proud to foster a culture where talented people can do meaningful work and grow their careers.


Magna Legal Services is seeking a detail-oriented Commissions Analyst to support the administration, calculation, and analysis of sales commission programs for our revenue-generating teams. Partnering with Sales, Finance, and HR, this role will help ensure commission payouts are accurate, timely, transparent, and aligned with plan terms.

The ideal candidate combines advanced spreadsheet skills, working SQL knowledge, and a strong understanding of incentive compensation mechanics. This individual will translate plan documents into repeatable calculations, reconcile data across systems, resolve discrepancies, and explain complex payout questions clearly to sales representatives and business leaders. Success in this role requires strong ownership, sound judgment, and a low tolerance for unexplained variances.

Primary Responsibilities

  • 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 so that plan logic remains consistent and traceable.
  • 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 clear, timely explanations to sales representatives and managers.
  • Verify attribution changes, including corrections made by other teams, against source documentation before they reach commission statements.
  • Partner with Sales, Finance, and Revenue Operations to implement new or revised compensation plans, test calculation logic, and communicate the impact of plan changes.
  • Support plan modeling by building plan scenarios in CaptivateIQ and presenting them to Sales, Finance, and HR.
  • Build and maintain reports, dashboards, and self-service tools that improve visibility into commission performance and expected payouts.
  • Recommend process, control, and data-quality improvements that strengthen the accuracy and efficiency of commission administration.

Desired Background

  • 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.

Magna Legal Services provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
 
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Similar Jobs

21 Days Ago
Easy Apply
Remote
United States of America
Easy Apply
100K-115K Annually
Mid level
100K-115K Annually
Mid level
Cloud • Information Technology
Manage worldwide monthly commission calculations, statements, disputes, CRM account reassignments, and CaptivateIQ administration. Develop commission plans, support quota planning, estimate regional and role-based quotas, align rules of engagement with plans, and evaluate sales performance through KPIs. The role partners with Sales leadership and Enablement while handling sensitive compensation discussions and improving SaaS commission processes.
Top Skills: CaptivateiqExcelSalesforce
5 Days Ago
Remote
United States
93K-150K Annually
Mid level
93K-150K Annually
Mid level
Information Technology • Software
Administer sales commission programs by validating calculations, reconciling discrepancies, maintaining quota and commission data, preparing Finance accruals and Payroll submissions, and responding to compensation inquiries. The role supports commission-plan implementation, quota assignments, incentive adjustments, reporting, participant approvals, audit-ready documentation, and process improvements through automation and controlled use of AI tools. It partners with Sales, Customer Success, Revenue Operations, Finance, and Payroll while handling confidential compensation data.
Top Skills: Ai ToolsCaptivateiqEverstageGoogle SheetsExcelQuotapathSalesforceXactly
7 Days Ago
Remote
United States
92K-130K Annually
Mid level
92K-130K Annually
Mid level
Software • Appliances
Administer monthly sales commissions, bonuses, and incentive payouts; reconcile sales, employee, and compensation data; maintain payout records; support compensation plan modeling and updates; resolve employee inquiries; and improve calculation tools, workflows, reporting, and data quality. The role partners with Sales Operations, Finance, HR, and payroll while protecting confidential compensation information.
Top Skills: ExcelNetSuiteSales Compensation Management ToolsSalesforce

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account