Sales Commission Operations Analyst

Must be highly proficient with Excel, Salesforce, Power BI, Anaplan, and SQL.
Must be highly analytical
2-3 years of relevant experience expected
Excellent communication skills, written and verbal and social skills required
Quick learner with ability to achieve successful results with limited supervision often under tight deadlines. Attention to detail, problem solving, judgment, and initiative, critical for success.

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 PowerBI and continuously review models and identify areas of potential improvement
Administer and update Excel and PowerBI 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 utilize Excel, Python, Power BI, and SQL to drive process improvements, automation, and enhanced reporting
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
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.