Multi-State Payroll Analyst (Advanced Excel)

Essential Utilities, Inc.; Lower Merion Township (Montgomery County); On-site; USD 65,000 - 85,000; Full time

Benefits offered by this job

Competitive benefits package

Career growth opportunities

Job summary

Essential Utilities, Inc. is seeking a Payroll Analyst to join our finance team. The role focuses on accurate payroll distribution for assigned divisions using Lawson, with emphasis on Excel data analysis and compliance.

You will process weekly and bi-weekly payroll for union, hourly, and salaried staff, validate data, and maintain SOX controls while collaborating with Finance, HR, and IT to resolve issues.

Qualifications

• Associates degree required; bachelor’s preferred.
• Minimum 5 years of payroll experience, multi-state.
• Advanced Excel proficiency with pivots, lookups, formulas.
• Familiarity with Lawson payroll system and payroll reporting.

Responsibilities

• Processes and analyzes weekly and bi-weekly payroll for assigned divisions, including union, hourly, and salaried staff.
• Enters and validates payroll data, including timesheets, work orders, adjustments, and corrections.
• Uses advanced Excel skills - pivot tables, lookups, advanced formulas, data auditing to analyze, validate, and reconcile payroll data.
• Prepares final pay for terminated employees, ensuring federal and state compliance.
• Ensures accuracy and compliance by verifying pay rates, deductions, and employee classifications.

Skills

Advanced Excel

Multi-state payroll

Data analysis

SOX controls

Analytical skills

Communication

Education

Associate’s degree in Finance/Accounting

Bachelor’s degree preferred

Tools

Lawson

ADP

PeopleSoft

SAP

HRIS

Job description

Essential Utilities, Inc. is seeking a Payroll Analyst to join our finance team. The role focuses on accurate payroll distribution for assigned divisions using Lawson, with emphasis on Excel data analysis and compliance.

You will process weekly and bi-weekly payroll for union, hourly, and salaried staff, validate data, and maintain SOX controls while collaborating with Finance, HR, and IT to resolve issues.