Sales Operations Analyst

What You’ll Do

Execution

• Perform the entire commissions process focusing on the monthly commission calculations and analytical audits across all sales teams and provide timely and accurate accrual information to accounting team
• Maintain models with demonstrated proficiency in Excel and Power BI and continuously review models and identify areas of potential improvement
• Administer and update Excel and Power BI to ensure transparency for our sales team
• Partner with payroll and accounting to ensure proper payments each month
• Work with management on various projects that use Excel, Python, Power BI, and SQL to drive process improvements, automation, and enhanced reporting

Plan

• Gain an understanding of all compensation plans for new and existing sales employees
• Gain an understanding of quota and results
• Assist in analysis of plan efficiency

Support

• Ensure complete and accurate employee data and compensation plan detail across compensation systems
• Assist in ad-hoc analysis and track key performance metrics monthly
• Ensure controls are performed for accurate payout of commissions
• Collaborate with payroll to provide accurate and timely payments to field employees
• Assist with timely and accurate resolution of commissions questions/disputes from field employees
• Assist in the development, maintenance, and updates to systems, processes, and analytics reporting