This site uses cookies. To find out more, see our Cookies Policy

Commission Analyst in Costa Mesa at Vaco

Date Posted: 10/25/2018

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Costa Mesa
  • Job Type:
  • Experience:
    At least 4 year(s)
  • Date Posted:
    10/25/2018
  • Job ID:
    5555ca

Job Description

The Commission Analyst will be a key contributor to the Finance team reporting to the Manager of Finance. This position is responsible for calculating, verifying and distributing commission payments to sales representatives, both internal and external, in a timely and accurate manner.

Duties and Responsibilities:

  • Extract files from various sales and accounting systems, standardizing and consolidating the data.
  • Verify data against management reports indicating sales representative assignments, commission splits, commission rates and exceptions to the rules.
  • Interact with several different departments including Customer Service, Accounting and Sales.
  • Interact with external sales representatives and customers.
  • Confer with Sales for final approval and distribute commission reports to the sales representatives as well as some internal associates.
  • Maintain commission data within the company database and other databases.
  • Communicate changes to Sales, tracking exceptions and updating the databases.
  • Responsible for providing the commission accrual on a monthly basis.
  • Upload data files into the company database, auditing for accuracy, calculating of commissions, and reporting the data to divisional and regional controllers.
  • Investigate commission discrepancies.
  • Identifies areas for process improvements in collaboration with finance and other business partners.

Essential Knowledge and Skills:

  • Strong analytical skills, attention to detail, problem-solving, and independent decision-making.
  • Advance Microsoft Excel: macros, vlook-up, pivot tables, etc.; PowerPoint, Microsoft Word & Access
  • A self-starter who is task-oriented and can focus on meeting the needs of various internal & external customers, including management at all levels.
  • Able to prioritize and meet multiple deadlines, work independently and be a team player.
  • Excellent verbal and written communication skills, with ability to interface at all levels throughout the organization.

Education and Experience:

  • Bachelor's degree with emphasis in finance or accounting
  • Minimum 4 years previous job-related experience with emphasis in commission analysis and reporting.
Experience with financial systems software package (Cognos/Oracle/Hyperion Essbase). Commission software is a plus.

Job Requirements

Essential Knowledge and Skills: •Strong analytical skills, attention to detail, problem-solving, and independent decision-making. •Advance Microsoft Excel: macros, vlook-up, pivot tables, etc.; PowerPoint, Microsoft Word & Access •A self-starter who is task-oriented and can focus on meeting the needs of various internal & external customers, including management at all levels. •Able to prioritize and meet multiple deadlines, work independently and be a team player. •Excellent verbal and written communication skills, with ability to interface at all levels throughout the organization. Education and Experience: •Bachelor’s degree with emphasis in finance or accounting •Minimum 4 years previous job-related experience with emphasis in commission analysis and reporting. •Experience with financial systems software package (Cognos/Oracle/Hyperion Essbase). Commission software is a plus.