Payroll Data Analyst: Insights, Compliance & Analytics

ES Foundry; Greenwood (SC); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

PTO

401K Matching

Vision

Dental

Medical Benefits

Sick leave

Job summary

ES Foundry is seeking a Payroll Data Analyst to ensure accuracy, integrity, and compliance of payroll data. You will audit payroll runs, reconcile large datasets, and build analytical reports for HR, Finance, and leadership.

Responsibilities include data validation across HRIS/timekeeping/finance, creating dashboards with Excel/SQL, and supporting tax filings with multi-state rules. Join a SC-based solar foundry focused on growth and compliance.

Qualifications

• Bachelor's degree in Accounting, Finance, HR, or related field.
• 2–5 years payroll or HRIS data experience.
• CPP or FPC certification preferred.
• Advanced Excel with Pivot Tables and XLOOKUP/VLOOKUP.
• SQL and payroll data analysis experience.
• Familiarity with ADP, Workday, or SAP payroll systems.
• Strong attention to detail and confidentiality.

Responsibilities

• Audit payroll data each cycle using variance analysis, outlier detection, tax validation, and reconciliation.
• Validate and reconcile payroll datasets across HRIS, timekeeping, and financial systems.
• Build dashboards and reports using Excel, SQL, and BI tools.
• Identify trends, anomalies, and compliance risks and recommend corrective actions.
• Assist with quarterly and annual payroll tax filings and year-end W-2 and 1099 processes.

Skills

Advanced Excel

Pivot Tables

XLOOKUP/VLOOKUP

SQL

Data analysis

Communication

Confidentiality

Education

Bachelor's degree in Accounting, Finance, HR, Data Analytics, or related field

CPP or FPC certification preferred

Tools

ADP

Workday

SAP

Job description

ES Foundry is seeking a Payroll Data Analyst to ensure accuracy, integrity, and compliance of payroll data. You will audit payroll runs, reconcile large datasets, and build analytical reports for HR, Finance, and leadership.

Responsibilities include data validation across HRIS/timekeeping/finance, creating dashboards with Excel/SQL, and supporting tax filings with multi-state rules. Join a SC-based solar foundry focused on growth and compliance.