Commisions Analyst

Mondo; South Carolina; On-site; USD 80,000 - 90,000; Full time

Benefits offered by this job

Health, Dental, Vision insurance

401(k) Match

PTO & holidays

Job summary

Mondo in Fort Mill, SC is seeking a Sales Commission Analyst to join our team onsite. You will analyze and administer incentive payouts, verify data integrity, and partner with sales and finance to ensure accurate commissions.

You will investigate discrepancies, maintain commission data hierarchies, and prepare dashboards for leadership. A strong Excel background, attention to detail, and ability to work cross-functionally are essential.

Qualifications

• 2-5 years of experience in sales commission analysis or related analytical role.
• Strong proficiency in Microsoft Excel including XLOOKUP, VLOOKUP, pivot tables, and SUMIFS.
• Ability to work with large datasets and identify discrepancies.
• Excellent written and verbal communication for stakeholder discussions.

Responsibilities

• Analyze and validate commission data during monthly/quarterly payout cycles.
• Investigate unusual changes or discrepancies and identify root causes.
• Maintain and validate sales hierarchy, crediting and quota data for accurate payouts.
• Prepare commission reports and dashboards for leadership and payroll.
• Explain calculations and rationale to sales leaders and finance.

Skills

Excel

Pivot tables

XLOOKUP

SUMIFS

Stakeholder mgmt

Data analysis

Education

Bachelor's degree (Finance/Accounting/Business/ Economics/ Mathematics)

Tools

Oracle

Xactly

Varicent

CaptivateIQ

Anaplan

SQL

Power BI

Salesforce

Job description

Job Title

Sales Commission Analyst

Location-Type

Onsite, Fort Mill, SC (5 days/week onsite; flexibility to 3 days/week after 6-month ramp period)

Start Date

ASAP

Duration

Permanent

Compensation Range

$80-90k/yr on W2

Benefits

• Health, Dental, and Vision plans; 401(k) Match; PTO (12-25 vacation days depending on years of service, 5 sick days, 6 holidays, 2 half-day holidays, 2 floating holidays, 1 inclusion day, 1 volunteer day); Short-term and long-term disability; Accident, Life, and Travel insurance; Flexible spending; Tuition Reimbursement; Employee Assistance Program (EAP); Length of Service Awards. Benefits eligible on the first of the month following 30 days from start date.

Visa Sponsorship

Not eligible for visa sponsorship

Job Description

This role is responsible for sales commission analysis and administration, partnering with sales and business leaders to ensure accurate payouts, identify discrepancies, and proactively drive process improvements across incentive compensation operations.

Job Summary

• Analyze and validate commission data during monthly and quarterly calculation and payout cycles, reviewing for completeness, accuracy, and adherence to plan rules.
• Investigate unusual changes or discrepancies in commission payouts, determine root cause, and recommend solutions rather than simply escalating issues.
• Maintain and validate sales hierarchy, crediting, quota, and other commission-related data in support of accurate payout processing.
• Prepare commission reports and dashboards for sales leadership, finance, and payroll, and assist with period-end close activities related to incentive compensation.
• Explain commission calculations and payout rationale clearly to sales leaders and internal stakeholders, including in situations involving disagreement or ambiguity.
• Identify opportunities to improve existing commission processes and proactively bring forward recommendations to streamline workflows.
• Partner with payroll, finance, and cross-functional stakeholders to support timely and accurate incentive compensation administration.

Minimum Requirements

• 2-5 years of experience in sales commission analysis, financial analysis, sales operations, or a comparable analytical business role.
• Strong proficiency in Microsoft Excel, including XLOOKUP/VLOOKUP, pivot tables, and SUMIFS.
• Demonstrated ability to work with large datasets, identify discrepancies and anomalies, and investigate issues to root cause.
• Strong communication and stakeholder management skills, including comfort explaining analytical findings to business leaders.
• Comfortable operating in ambiguous, gray-area situations requiring judgment and independent problem-solving.
• Detail-oriented and highly organized, with strong time management skills.
• Bachelor's degree in Finance, Accounting, Business, Economics, Mathematics, or a related field, or equivalent practical experience.

Preferred Qualifications

• Prior experience with sales commission or incentive compensation management (ICM/SPM) platforms such as Oracle, Xactly, Varicent, CaptivateIQ, Anaplan, or similar.
• Familiarity with SQL or Power BI for data querying and reporting.
• Experience with advanced Excel functions including macros.
• Exposure to CRM systems such as Salesforce.
• Background in sales operations or compensation analysis with demonstrated process improvement contributions.