Sr. Commissions Analyst

About the Role:
Sr. Commissions Analyst

 

Job Summary:

The Sr. Commissions Analyst holds a pivotal role in our Sales Analytics team, taking primary responsibility for the accurate execution and analysis of variable compensation for our Senior division sales agents and sales management. This position is integral to ensuring that compensation plans are executed precisely, timely and as designed.

 

Utilizing advanced technical skills, particularly in SQL coding, coupled with a deep understanding of compensation plan design, financial acumen, and business knowledge, the Senior Analyst will oversee all aspects of compensation calculation and execution. This includes researching and resolving commission escalations, conducting thorough analysis of compensation data, and collaborating cross-functionally to address any issues or discrepancies.

 

The ideal candidate for this role will possess exceptional attention to detail, strong analytical skills, and the ability to work with a sense of urgency. Effective communication and collaboration across departments are crucial for success in this position.

 

Supervisory Responsibilities:

This position has no direct supervisory responsibilities.

 Essential Duties and Responsibilities:

Execute and analyze variable compensation for Senior Division sales agents and sales management

Utilize SQL coding and other technical skills to ensure accurate calculation of compensation plans

Payroll File Completion & Submission:  Ensure the payroll file is complete, accurate, and timely based on all commissions work and analysis throughout the month and submitted to payroll in advance of the submission deadline

Review and research all commission escalations in conjunction with the Commissions Project Manager and determine outcome; provide detailed information to the Commissions Project Manager and/or Commissions Senior

Manager to ensure a timely and accurate response can be provided to the Sales Agent and submitting Manager

Serve as a primary point of contact for the Commissions Senior Manager and Commissions Project Manager as it relates to Commission calculations and escalations

Collaborate cross-functionally with Management, the Commissions Senior Manager, the Commissions Project

Manager, Sales, and IT Partners to address compensation issues

Master the Core Commissions module and efficiently conduct research to determine the nature of compensation issues

Prioritize tasks and deliverables, demonstrating accountability to achieve timelines

Utilize critical thinking skills to continuously evaluate compensation calculations for reasonableness and accuracy; proactive approach for data checks while being able to react quickly when an issue arises

Develop a deep understanding of all commission programs that reside outside of the Core Commissions compensation module and ensure accurately and timely calculations

Develop a process in conjunction with Core Commissions and internal BI/ETL teams to ensure the commission statements are updating accurately and displaying for all agents

Identify potential operational efficiencies, including self-service tools, and work cross functionally to implement and drive overall efficiencies throughout the entire variable compensation process

Assist in designing, performing, and investigating checks for completeness and accuracy and collecting sign-off from multiple parties to submit to Audit board 

Skills/Abilities:

High attention to detail

Strong business and financial acumen  Rate-volume-mix variance analysis

  Deconstructing and re-constructing pro-forma budget based on agent level

Pairing together budget data, performance data, and compensation data via SQL queries, power query in excel, pivot tables and complex excel formulas

Ability to synthesize and summarize data into executive summaries that is easy to consume and clearly relays pertinent points

Strong communication skills (written and verbal) including group presentations

Creative problem solver with the ability to articulate financial and agent experience impacts

Self-motivated with an extremely strong sense of urgency

Robust analytical skills required to understand the impact of commission changes and review datasets for reasonableness and commission plan compliance

Highly organized with a demonstrated ability to prioritize work based on impact to the organization and deadlines

Ability to thrive in a fast paced environment with competing priorities

Ability to review data files for accuracy in comparison to variable commission plans by position and level

Time management skills to adhere to strict deadlines

High level of proficiency in Excel and SQL

Ability to take a result at an aggregate level and trace through multiple detailed views and stored procedures to its ultimate source

Ability to verify rather than taking at face value (i.e. What else can be checked against and being able to determine what is the best “source of truth”)

Education and Experience: 

Bachelor's degree in a related field required

5+ years of related experience required

Physical Requirements:

Work is performed indoors with potential for exposure to safety and health hazards related to office work. Could periodically travel to other office and operational sites. The noise level in the work environment is usually moderate.

Prolonged periods of sitting at a desk and working on a computer.

Travel may be necessary on a monthly basis - quarterly company meetings, occasional team meetings and/or client visits

SelectQuote Core Values:

 

Service: We create positive customer experiences. 

 

Entrepreneurship: We create innovate & take risks. 

 

Leadership: We build & invest in high-performing teams. 

 

Empowerment: We embrace a changing environment. 

 

Courage: We challenge the status quo & drive continuous improvement.

 

Teamwork: We help support & celebrate each other.

 

 

 

Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required.

---