Payroll Systems & Data Coordinator

ES Foundry Corp•Greenwood, SC

About The Position

The Payroll Systems & Data Coordinator ensures the accuracy, integrity, and compliance of payroll data by auditing payroll runs, reconciling large datasets, and generating analytical reports that support HR, Finance, and business leadership. This role serves as the bridge between payroll operations and data analytics, transforming payroll information into actionable insights that improve efficiency, reduce risk, and support compliance.

Requirements

Bachelor’s degree in accounting, Finance, HR, Data Analytics, or related field.
2-5 years of payroll or HRIS data experience.
Advanced Excel experience, including Pivot Tables and XLOOKUP/VLOOKUP.
SQL and payroll data analysis experience.
Power BI or Tableau experience.
Knowledge of ADP, Paylocity, or similar payroll systems.
Strong attention to detail, communication, and confidentiality.

Nice To Haves

CPP or FPC certification preferred.

Responsibilities

Audit payroll data each cycle using variance analysis, outlier detection, tax withholding validation, and deduction reconciliation.
Validate, clean, and reconcile payroll datasets across HRIS, timekeeping, and financial systems.
Investigate discrepancies between payroll records and general ledger entries and resolve issues with Accounting.
Build dashboards and reports using Excel, SQL, and BI tools.
Identify trends, anomalies, and compliance risks and recommend corrective actions.
Provide analytical support for audits, compliance reviews, and leadership reporting.
Ensure compliance with federal, state, and local wage and hour laws.
Validate tax codes, deductions, garnishments, and multi-state payroll rules.
Assist with quarterly and annual payroll tax filings and year-end W-2 and 1099 processes.