Overview
The organization is seeking a detail-oriented Sales Commission Analyst to manage the monthly commission accrual and payout processes. This role focuses on accurate, consistent, and compliant commission calculations and reporting, while providing Finance and Sales leadership with reliable data and insights.
Responsibilities
Commission Accruals & Reporting
- Consolidate data from multiple systems to prepare accurate monthly commission accrual reports.
- Load, validate, and maintain commission accrual models in partnership with the Accounting team.
- Perform month-over-month variance analysis and identify key drivers, trends, and anomalies.
- Investigate discrepancies and coordinate with relevant stakeholders to resolve data or calculation issues.
Commission Payouts
- Calculate monthly sales commission payouts in accordance with established compensation plans and performance data.
- Review and validate commission calculations for accuracy, completeness, and compliance with company policies.
- Generate and distribute commission statements using automated tools and established processes.
- Maintain accurate records and supporting documentation for commission calculations and payouts.
Data Analysis & Business Support
- Provide ad hoc financial and operational analysis to Finance and Sales leadership.
- Support executive-level reporting, presentations, and analysis for the Executive Leadership Team (ELT) and Sales leadership.
- Maintain detailed process documentation, controls, and standard operating procedures.
- Monitor data integrity across systems, models, and reporting outputs.
- Identify opportunities to improve the efficiency, accuracy, and consistency of commission processes.
Requirements
- Advanced Excel skills, including pivot tables, complex formulas, data analysis, and macro automation.
- Experience with Microsoft Dynamics 365, including Customer Engagement and Finance & Operations.
- Strong understanding of accrual accounting, financial reporting, and variance analysis.
- Exceptional attention to detail with strong data validation and problem-solving skills.
- Highly organized and able to manage recurring monthly deadlines with accuracy and consistency.
- Strong written and verbal communication skills, including the ability to clearly communicate and escalate issues.
- Ability to work with sensitive and confidential compensation and financial information with discretion.
- Self-motivated and analytical, with the ability to independently manage established processes and resolve issues.
- Comfortable working in a structured, process-driven environment with a focus on long-term process ownership.
Preferred Qualifications
- Dependable, analytical, and highly detail-oriented.
- Strong ability to take ownership of recurring monthly responsibilities and maintain accurate, reliable processes.
- Values consistency and accountability, and can serve as a trusted resource to both Finance and Sales teams.
Compensation & Benefits
- Multiple medical plan options to fit you and your family’s needs
- HSA & HRA company contributions
- Dental coverage, including orthodontic benefits, and vision plans
Company-paid Benefits
-
Basic Life, AD&D
-
Short-Term and Long-Term Disability insurance
-
Employee Assistance Program (EAP)
-
Generous paid time off — 3 weeks PTO plus company holidays and floating holidays
-
401k with company match
-
Paid maternity leave
-
Healthcare and Dependent Care Flexible Spending Accounts (FSA)
-
A wide range of voluntary benefits including Critical Illness, Hospital Indemnity, Accident Insurance, Pet Insurance, Homeowners and Auto Insurance, Supplemental Life and AD&D coverage, and Legal Services
-
Commuter benefits
-
Additional benefits