Commissions Analyst
Description
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.
Skills
As published by lever · 25 questions · 5 written answers
Basics
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, Twitter URL, GitHub URL, Portfolio URL, Other website, I identify my ethnicity asSelect all that apply, What gender do you identify as?, Voluntary Self-Identification of DisabilityWe are committed to creating an inclusive workplace. To help us monitor and improve our diversity efforts, we invite you to voluntarily self-identify if you have a disability. Completing this section is optional and will not affect your application or employment decision. How do I know if I have a disability? A disability is a physical or mental condition that substantially limits one or more major life activities, or a history of such a condition. Confidentiality Notice: Your response will be kept confidential and used only for internal diversity and inclusion purposes.
Short answers (12)
- Home Address
- If you were referred by an employee of Magna, please list their name here. optional
- Dates Attended
- Role Title
- Company
- Dates of Employment
- Role Title optional
- Company optional
- Dates of Employment optional
- Role Title optional
- Company optional
- Dates of Employment optional
Pick from a list (8)
- Are you legally authorized to work in the United States?
- Will you now or in the future require Magna Legal Services to commence ("sponsor") an immigration case in order to employ you (for example, H-1B or other employment-based immigration case)? This is sometimes called "sponsorship" for an employment-based visa status.
- Are you located in the United States?
- Have you ever been convicted of a felony or misdemeanor (excluding minor traffic violations)?
- How did you hear about us? optional
- What is your highest level of education? optional
- Did you graduate?
- School Attended optional
Written answers (5)
- What are your compensation expectations? Please provide your expected range for base salary, bonus (if applicable), and total annual compensation.
- What makes you a strong fit for this role? Please highlight the skills, experience, and accomplishments that you believe are most relevant.
- Reason for leaving
- Reason for leaving optional
- Reason for Leaving optional
Sign in to read and join the discussion.