SelectQuote Insurance Services

Sales Commissions Analyst

SelectQuote Insurance Services

full-time

Posted on:

Location Type: Office

Location: Overland Park • Kansas • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Junior

Tech Stack

SQL

About the role

  • Aggregation – Collecting results by communicating across several groups within the company as our team is the Operations point-of-contact for Accounting and Payroll.
  • Calculation – Calculating variable compensation for the Ancillary Sales Team Sales Manager and Regional Manager payments. Assisting in recalculations for others.
  • Evaluation – Reviewing compensation for errors creating specialized reporting to track new efforts looking for trending used to tweak forecasts.
  • Presentation – Reviewing all aspects of variable compensation for the Director/VP level answering their questions and following up on request/questions.
  • Perform research in SQL Server databases/tables assisted by reviewing/creating Lucid Chart documents.
  • Develop and maintain performance and metrics reporting for the compensation sales and support teams of SelectQuote Senior.
  • Prepare quantitative analysis using Microsoft Excel, SQL, Amazon QuickSight, and other analytics tools to develop meaningful insights into company performance.
  • Provide forward-looking and historical analysis for strategic initiatives through modeling and sensitivity tool usage.
  • Produce clear and concise presentations regarding projects and other assigned tasks.
  • Provide ad hoc analytical support to various teams throughout the business.
  • Create reporting for key performance indicators monitor results and provide analysis of results to company stakeholders.
  • Define benchmarks for success within the division using historical analysis.
  • Collaborate with department leaders to build analyze and defend strategy and business cases for new initiatives workflow enhancements technological enhancements etc.
  • Complete assigned tasks quickly and with a sense of urgency.
  • Develop working knowledge of business processes data generated within each process and flow of data within the database for foundational KPIs.

Requirements

  • Bachelor’s degree required preferably in Finance, Economics, Accounting, Mathematics, Business Analytics or related field
  • 0-2 years’ experience in analyst role (compensation, finance, operations, business or equivalent) preferred
  • Ability to write your own basic SQL Server Code
  • Strong proficiency with Microsoft Excel and at least basic working knowledge of PowerPoint OR Strong proficiency with Google Apps (Drive, Sheets, Docs, Forms etc.)
  • Experience working with technical applications and programming languages such as SQL, Amazon QuickSight, and Lucid Chart etc. are highly preferred
Benefits
  • Health insurance
  • Professional development opportunities
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLMicrosoft ExcelAmazon QuickSightLucid Chartquantitative analysisperformance reportingdata analysisbenchmarkingcompensation analysisfinancial modeling
Soft Skills
communicationcollaborationanalytical thinkingattention to detailtime managementproblem-solvingpresentation skillsurgencyadaptabilityinterpersonal skills