Commission Analyst

Job Description 9867
COMMISSIONS/PAYROLL ANALYST
Summary / Position Purpose:
The Commissions/Payroll Analyst will play a crucial role in supporting the implementation, administration and analysis of the organizations variable compensation plans. The role will ensure the plans as designed are timely and accurately paid to participating team members based on the achievement of designated sales quotas. As a Commissions Analyst, you will conduct routine audits and consult with the necessary team members to ensure the organization remains compliant in payroll, tax and compensation aspects.
Essential Duties, Functions and/or Responsibilities:
• Calculate commissions based on the designed compensation plan and process through payroll to ensure timely and accurate payments to Reps.
• Support in design, implementation, and administration of variable pay plans. May include creating new plans or modifying existing plans.
• Analyze and evaluate sales program effectiveness recommending improvements based on data and market trends.
• Maintain program data and metrics. This involves collecting, analyzing, and reporting on program data to track performance and identify areas for improvement.
• Develops, implements and manages compensation procedures and practices for maintaining state, federal, and local compliance
• Develop appropriate communication tools for the field to provide a comprehensive understanding of how their incentive plans and award programs work
• Communicate with managers or team members to resolve questions or gather missing payroll related information - Reconcile timecard entries and assist with leave balance inquiries, corrections or calculations
• Collaborate with sales leadership on optimizing sales organization reporting to help drive sales performance
• Review all booked revenue on a weekly basis and verify booked sales reports are sent weekly to the necessary parties
• Successfully navigate HRIS to process commissions
• Responsible for compiling commission data through Salesforce and Great Plains

• Participate in system implementations and process efficiency (HRIS implementation, Commission System implementation

Education and/or Work Experience Requirements:
• Bachelors degree preferred
• 5+ years of experience processing payroll
• Experience with Salesforce and UKG preferred
• Advanced Excel skill set (formula creation, pivot tables, macros)
• Ability to communicate using Microsoft Office
• Excellent written and oral communication skills
• Exceptional critical thinking and problem solving skills
• Strong work ethic and ability to meet tight deadlines
• Ability to safely and successfully perform the essential job functions consistent with ADA and all other applicable federal, state and local standards, including meeting qualitative and/or quantitative productivity standards