Payroll & Commissions Analyst

Payroll & Commissions Analyst

Payroll & Commissions Analyst

This job has been filled or expired, so you can no longer apply for it.

You can browse our current jobs in this category here or view the old job below.

Accentuate Staffing is currently recruiting for a Direct Hire Payroll & Commissions Analyst for our well established & growing client headquartered in Cary, NC.

 

Responsibilities:

Payroll & Compensation Calculations

  • Ensure accuracy of  payroll recordkeeping spreadsheet.
  • Input updates based on new hires, terminations, and transfers.
  • Each day, review the spreadsheets for accuracy/completion of the store managers’ inputs (e.g. clock hours, billable hours, commission sales data, etc.).
  • On a weekly basis, generate payroll import data for 250 employees.
  • Ensure accuracy and resolve issues with individual store location tracking sheets.
  • Compile employee inputs into a master Excel data sheet.
  • Payroll is calculated in a complex spreadsheet, based on multi-variable commission-based pay plans.
  • Finalized pay data is imported to ADP Workforce Now for processing.

Reporting & Analysis

  • Generate weekly sales and operations reports each Monday morning
  • Provide ad hoc compensation information and payroll analytics

Requirements:

  • Excellent MS Excel skills, including IF/THEN, VLOOKUP formulas, conditional formatting, and Pivot Tables
  • Associates Degree
  • Quick ability to customize formulas for various compensation plans
  • Payroll experience is preferred, but not required
  • Experience using ADP Workforce Now is preferred but not required
  • Strong phone communication skills – able to discuss issues across multiple store locations and district managers
  • Dependable, honest, and confidential
  • Willing to work with standard weekly process
  • Can-do attitude to resolve data input questions and issues
  • MS Excel Data Analysis: 5 years (Required)

Coronavirus (COVID-19) Information

You will find some resources regarding COVID-19 below:

Skip to content