Sales Commission Analyst

MW Partners is currently seeking a Sales Commission Analyst to work for our client who is a global leader in multimedia and creativity software products.

Responsibilities and duties:

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 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 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

Requirements:

• Must be highly proficient with Excel Salesforce Power BI Anaplan and SQL.
• Must be highly analytical
• 2-3 years of relevant experience expected
• Background of cross functional interaction with internal organizations a plus
• 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

For a further discussion or to find out more contact Amit Kumar on or apply now.