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)