Sales Operations Analyst

Adobe•Austin, TX

2d•Remote

About The Position

This role focuses on the execution of the commissions process, including monthly calculations and analytical audits for all sales teams. The analyst will provide timely and accurate accrual information to the accounting team. A key part of the role involves maintaining and improving Excel and Power BI models to ensure transparency for the sales team. The analyst will also partner with payroll and accounting to ensure accurate payments and collaborate with management on projects utilizing Excel, Python, Power BI, and SQL to drive process improvements, automation, and enhanced reporting. The role also involves planning by understanding compensation plans, quotas, and results, and assisting in the analysis of plan efficiency. Support functions include ensuring accurate employee data and compensation plan details in systems, performing ad-hoc analysis, tracking key performance metrics, ensuring controls for accurate commission payouts, and resolving commission-related inquiries from field employees.

Requirements

Proficiency in Excel and Power BI.
Experience with Excel, Python, Power BI, and SQL for process improvements, automation, and reporting.
Understanding of compensation plans, quotas, and results.
Ability to ensure complete and accurate employee data and compensation plan details.
Skills in ad-hoc analysis and tracking key performance metrics.
Ability to ensure controls for accurate commission payouts.
Collaboration with payroll for accurate and timely payments.
Ability to resolve commissions questions/disputes.
Experience in development, maintenance, and updates to systems, processes, and analytics reporting.

Responsibilities

Perform the entire commissions process focusing on the monthly commission calculations and analytical audits across all sales teams.
Provide timely and accurate accrual information to the 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.
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.