Hourly Advanced Excel Jobs (NOW HIRING)

Essential Utilities, Inc. delivers safe, clean, reliable services that improve quality of life for individuals, families, and entire communities.

Operating as the Aqua (water and wastewater services) and the Peoples and Delta (natural gas) brands, Essential serves approximately 5.5 million people across 10 states. We are committed to sustainable growth, operational excellence, a superior customer experience, and premier employer status - including a competitive and comprehensive benefits package as well as a commitment to career growth opportunities.

We are advocates for the communities we serve and are dedicated stewards of natural lands, protecting more than 7,600 acres of forests and other habitats throughout our footprint.

Our company is one of the most significant publicly traded water, wastewater service and natural gas providers in the U.S.

Are you looking for a fantastic career at Aqua?

The Payroll Analyst plays a critical role in preparing, analyzing, and ensuring the accurate distribution of payroll for an assigned division. This position relies heavily on strong Excel skills, data analysis, and payroll experience. Using the Lawson Financial Reporting system, the Payroll Analyst supports multistate union and nonunion payrolls while ensuring accuracy, compliance, and data integrity across all payroll processes.

ESSENTIAL DUTIES

Processes and analyzes weekly and biweekly 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 against company policies, union contracts, and SOX controls.
Audits timesheet data to identify inconsistencies and resolve exceptions before payroll processing.
Responds promptly to payroll questions, providing clear guidance and resolving discrepancies.
Updates payroll procedures and maintains accurate documentation of payroll processes.
Performs general ledger reconciliation, identifies discrepancies, and prepares supporting documentation for Accounting and Finance.
Assists with payroll tax activities, including monthly, quarterly, and annual filings processed through the payroll vendor.
Processes voluntary employee deductions such as 401(k), ESPP, and United Way.
Generates standard and ad hoc payroll reports to support Finance, HR, and Operations in labor cost analysis.
Supports system enhancements, testing, and process automation initiatives.
Partners closely with Finance, Accounting, Benefits, and IT to resolve issues and manage special requests.
Maintains uptodate knowledge of federal, state, and local payroll regulations.
Assists with special projects, such as W2 reconciliation, internal/external audits, and yearend processing.
Ensures payroll documents, records, and reports meet audit and compliance standards.

QUALIFICATIONS

Associate's degree in Finance, Accounting, Business, or related field required
Bachelor's degree preferred
Minimum of 5 years of payroll experience, preferably in a multistate environment
Advanced Excel proficiency (pivot tables, VLOOKUP/XLOOKUP, formulas, data analysis)
Experience with general ledger reconciliation and payroll reporting
Familiarity with payroll systems (Lawson preferred) and timekeeping tools
Strong analytical and problemsolving skills
Excellent accuracy, attention to detail, and organizational skills
Strong communication and customer service orientation

KNOWLEDGE, SKILLS AND ABILITIES: (Examples below)

• Familiarity with payroll processing systems such as Lawson, ADP, PeopleSoft, SAP, etc.
• Expert knowledge of payroll, payroll deductions and payroll taxes
• Excellent Excel or spreadsheet software skills with extensive knowledge of Microsoft office applications, HRIS, and other vendor interface protocols
• Excellent written and verbal communications skills; communicate effectively (clearly, concisely and professionally) with internal customers
• Strong customer service skills
• Ability to work well under pressure and meet weekly payroll deadlines
• Ability to work on multiple projects simultaneously and adapt to changing priorities in a fast-paced environment
• Ability to work independently with minimum
• A team player able to work effectively in a team fostered multi-tasking environment

WORKING CONDITIONS/PHYSICAL DEMANDS:

• Perform deskbound work- exerting up to 20 pounds of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects, including the human body. Desk work involves sitting/standing most of the time.
• See, hear, talk, and perform tasks requiring manual dexterity.
• Operate standard office equipment.

The physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This is not an all-inclusive document. Additional duties, expectations, demands, etc. may be added or changed to this document on an as-needed basis in order to meet organizational needs.

Essential Utilities, Inc., is an Equal Opportunity/Affirmative Action employer. Equal employment opportunity is provided to all employees and applicants for employment without regard to the following legally protected characteristics: race, color, religion, sex, national origin, age, pregnancy (including childbirth and related medical conditions, including medical conditions related to lactation), physical or mental disability, covered-veteran status, genetic information (including testing and characteristics), sexual orientation, gender identity or expression or any other characteristic protected by applicable local, state or federal law.
Essential Utilities is committed to providing reasonable accommodation to individuals with disabilities. If you have a condition that may prevent you from applying for a job online or need to request an accommodation during the interview process, please call (1-877-271-9012).
To maintain the integrity of the recruitment process and to avoid real or perceived conflicts of interest due to employment and/or assignment of family members and personal referrals, specific guidelines apply to the hiring and assignment of these individuals including, but not limited to:

• Family members cannot result in a supervisor/subordinate reporting relationship
• Family members cannot work in the same department.