Sales Commission Analyst

Job ID: 24-05847
Job Title: Financial Analyst (Sales Commission Analyst)
Location: Lehi, UT 84043 (Hybrid)
Duration: 12 months
Contract Type: W2 only
Pay Rate: $38.73/Hour

Duties:

• This role is responsible for end-to-end commission payment support and analysis and as such will undertake a variety of roles to ensure timely and meticulous completion of the monthly and quarterly payment cycle.
• As a Sales Commission Analyst, your role will be to handle the complete commission process for sales team members located globally. This will include commission calculation audits, sending timely data to payroll, responding to commission queries, and a heavy focus on working on team projects that will drive process improvements and analytics reporting for our business partners.

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 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 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
• Collaborate with Sales Ops to 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

Required Skills:

• Must be highly proficient with Excel, VBA, Power BI, SQL, and Python.
• 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

Education: BS in Business related field required