The Commission Analyst is responsible for ensuring the timely and accurate calculation of commission. This individual will work alongside the Corporate Accounting Team to ensure that employee commission plans are properly created, maintained and updated accordingly in the commission system. In addition, this position will troubleshoot exceptions in excel spreadsheets to determine where errors exist and to ensure commission payment reports are accurate and complete. In addition, the individual in this role will be charged with the creation, review, analysis and validation of monthly reports for all commissions accrued and paid.
Responsibilities:

Update the organization’s commission system with employee changes and commission plan changes on an ongoing basis
Develop and test new commission plans in the organization’s commission system
Work with our commission system’s personnel to troubleshoot issues
Ensure accurate responses to inquiries or concerns related to commission and incentives are provided to employees
Review commission payment reports for accuracy and completeness
Ensure accurate and timely commission payouts
Prepare commission expense reports, presentations and recommendations for sales and/or finance management.
Prepare journal entries for payroll-related items, including accruals and departmental breakouts, and resolve any reconciliation issues
Ensure all changes follow SOX guidelines

Minimum Qualifications:

Bachelor’s Degree in Business, Math, Computer Science, Statistics, Accounting or related field preferred
A minimum of 1 year working as a Sales Analyst, Sales Operations Analyst, Order Processor or a similar position a plus
A minimum of 2 years commission/payroll experience preferred (or combination payroll and HR or order processing)
SQL training and some familiarity with general Database functions a plus
Experience with Gmail and Google Docs
Experience with MS Office (Word and Excel, including pivot tables)
Strong verbal and written communications
Excellent time management and organization skills
Superior Excel skills
Ability to work in a team on projects and independently
Strong math and numeracy skills
Customer service and etiquette skills
Discretion involving personal and legal matters