Program Analyst, Vegetation Management (Hybrid Schedule)

Eversource Energy•Berlin, CT

1d•$84,520 - $93,910•Hybrid

About The Position

This role is responsible for contractor timesheet and invoice-related tasks for the Eversource Connecticut Vegetation (VM) Department. Core responsibilities include financial administration, invoice auditing, data reporting, and process improvement. The individual will work closely with Eversource arborists and supervisory teams to identify and resolve timesheet or invoice discrepancies, track recurring errors, and monitor invoice volume and payment status. The role will create desktop requisitions for purchase orders, manage increase requests, and maintain meticulous records of timesheets and invoices. Daily communication with the vegetation management team, contractor home office staff, and contractor field supervision is expected. Additionally, the individual will track and analyze contractor performance KPIs and weekly production metrics, maintain daily contractor crew locations, monitor an email inbox for customer inquiries, and assist with regulatory reporting. The position will leverage the Microsoft Power Platform (Excel, Power BI, and Power Automate) for data transformation, workflow automation, and interactive dashboards, and will assist with future transitions to work management or timesheet management software.

Requirements

Highly organized with a strong commitment to data integrity and administrative accuracy
Effective communication and interpersonal skills.
Experience with electronic invoicing applications and invoice processing procedures.
Ability to collaborate effectively with colleagues internal and external to Eversource.
Experience processing, cleaning, manipulating, and analyzing programs or administrative datasets.
Ability to adapt and apply innovative technologies and workflows.
Advanced proficiency in the Microsoft Suite; advanced Excel skills (complex formulas, Power Query, pivot tables, and data modeling) are preferred.
Bachelor’s degree in Finance, Business Administration, Data Analytics, Information Systems, Project Management or the equivalent in combined education and experience is required.
Minimum of three (3) years related professional experience.

Nice To Haves

Experience with Maximo is a plus.
Demonstrated experience building and maintaining interactive dashboards in Microsoft Power BI is preferred.
Experience with Microsoft Power Automate or SQL is a plus.
Experience within the utility industry is preferred but not required.

Responsibilities

Manage timesheet approvals and corrections alongside VM program coordinators to ensure timely contractor payments.
Review and reconcile contractor invoices in Maximo with proper purchase orders, work order numbers and accounting totals.
Extract data and create reports from multiple databases to aid in department invoice tracking.
Run a weekly report on Maximo invoices that have been paid and the status of those pending payment by contractor.
Identify opportunities to streamline and/or automate manual reporting processes to reduce administrative cycle times.
Maintain accurate, organized records of timesheets, invoices, and associated documentation.
Monitor and track outstanding invoices and follow up with contractors to resolve issues.
Respond to inquiries from contractors about accounts receivable reports.
Develop monthly, quarterly, and annual KPI reports for internal management.
Track and update weekly contractor production metrics.
Support all regulatory reporting requirements including the creation of summary charts and tables.
Create desktop requisitions for purchase orders.
Oversee customer email inbox and forward inquiries to the appropriate Eversource representative.
Assist with implementing and managing any future work management system or timesheet system integrations.
During storm restoration, assist with the validation and upload of contractor tree crew rosters and the reconciliation of crew counts in the system.