Commissions Analyst (Hybrid)

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