Payroll Systems & Data Coordinator

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

The Payroll Data Analyst 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.

Key Responsibilities

Payroll Data Accuracy & Auditing

• 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.

Data Analysis & Reporting

• 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.

Compliance & Regulatory Support

• 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.

Qualifications & Requirements

Education & Experience

• Bachelor's degree in Accounting, Finance, HR, Data Analytics, or related field.
• 2-5 years of payroll or HRIS data experience.
• CPP or FPC certification preferred.
• Advanced Excel including Pivot Tables and XLOOKUP/VLOOKUP.
• SQL and payroll data analysis experience.
• Knowledge of ADP, Workday, SAP, or similar payroll systems.
• Strong attention to detail, communication, and confidentiality.
• PTO
• 401K Matching Plan
• Vision, Dental, Medical Benefits
• Sick leave

About us:

ES Foundry is the only US-based pure play solar foundry that provides Domestic Content Bonus ITC compliant product solutions for US end customers. The company's manufacturing facility is in South Carolina. Our founding members have accumulated experience of over 40GW+ of module sales and 30GW+ of manufacturing operation expansion.

ESF offers excellent career growth opportunities and is expanding its talented workforce to meet rising demand. By joining ESF, you'll learn from industry experts and discover your potential while being part of a team committed to our shared values: Safety, Integrity, Teamwork, Accountability, Customer Focus, and Entrepreneurial Spirit.