Commission Analyst at Englewood

The Commission Analyst will be responsible for calculating commissions on a weekly basis for indirect sales channels; coordinating with regional sales organizations and internal sales support to maintain correct rep to territory alignment for the commission tracking. This includes understanding all variations of commission plans and tracking changes. Will support the various tracking systems and ensure systems reflect all commission changes; problem solving as needed to resolve questions on invoice assignments and commissions payments. Create reports through various software tools to support the commission process. Strong Microsoft Excel skill required.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Commission Calculation/Payroll Reporting:

  Develops and regularly produces commission status reports for individual sales representatives and appropriate aggregated reports for the various levels of sales management.
  Administers all activities necessary to calculate commissions weekly and provide reports to external sales channel for accurate and efficient weekly payroll processing.
  Provides support to external sales channel to address questions and concerns regarding commission payments.
  Maintains and enhances commission databases and works within Excel; develops complex formulas for the commission calculations.
  Analyzes sales and commission data, as requested.
  Analyzes commission and incentive expense variances and ensures sales management is constantly informed of material variances, real or anticipated. 
  Analyzes commission payouts and quota/target achievements to identify issues and provides explanations to payout trends and accrual variances. 
  Resolves and communicates any issues with sales management.
  Administers and implements sales incentive plan design and process.
  Coordinates with Human Resources to track employee status change paperwork and agreements (i.e. new hires, transfers, salary adjustments, FMLA, or termination agreements).

SKILLS AND REQUIREMENTS:

Qualifications:
  Education:  BA/BS or equivalent work experience
  Experience:  1+ years of sales compensation experience including analysis and evaluation, and experience with calculation concepts and processing

Skills and Knowledge:
  Requires strong analytical skills including advanced MS Excel formula building including IF statements, v-lookups, and pivot tables
o  Knowledge of PowerPivot is a plus but not required
  Fundamental problem-solving skills
  Proficiency with analyzing and interpreting data
  Excellent interpersonal skills with both customers and colleagues

$40,000 annual salary with strong bonus potential. Medical, dental and visions insurance offered. Exceptional growth potential in a high paced, exponential growth environment.
Country: USA, State: Colorado, City: Englewood, Company: Turfwalker.