Program Analyst, Vegetation Management (Hybrid Schedule)

Eversource Energy; Berlin (NH); On-site; USD 85,000 - 94,000; Full time

Job summary

Eversource Energy is seeking a detail-oriented administrator to manage contractor timesheets, invoices, and data reporting within the Vegetation Management department. You will work with arborists and field supervision to ensure accurate billing and timely payments.

You will build KPI dashboards in Power BI, automate reports with Power Automate, and support regulatory reporting. A Bachelor's degree and at least three years in finance or data analytics are required, with experience in Maximo and

Qualifications

• Bachelor’s degree in Finance, Business Administration, Data Analytics, Information Systems, Project Management or the equivalent.
• Minimum of three years related professional experience; utility industry experience preferred.

Responsibilities

• Manage timesheet approvals and corrections to ensure timely contractor payments.
• Reconcile contractor invoices in Maximo with POs, work orders, and totals.
• Extract data and create reports from multiple databases to aid in invoice tracking; weekly status updates.
• Identify opportunities to streamline and automate manual reporting processes.
• Maintain accurate, organized records of timesheets, invoices, and documentation.
• Monitor outstanding invoices and follow up with contractors as needed.

Skills

Data analysis

Excel advanced

Power BI

Power Automate

SQL

Maximo experience

Data integrity

Communication

Education

Bachelor’s degree in Finance, Business Administration, Data Analytics, Information Systems, Project Management or the equivalent

Tools

Maximo

Power BI

Power Automate

SQL

Excel

Job description

Eversource will not offer immigration-related sponsorship for this position (e.g., H-1B, O-1, J-1, TN, E-3, etc.). Applicants requiring visa sponsorship to start employment with Eversource will not be considered.

Individual will be responsible for contractor timesheet and invoice-related tasks for the Eversource Connecticut Vegetation (VM) Department. Core responsibilities will include financial administration, invoice auditing, data reporting, and process improvement. The individual will work closely with Eversource arborists and supervisory teams to identify any timesheet or invoice discrepancies, resolve invoice errors or billing with contractor home office personnel, and will track recurring errors. Regular monitoring of the volume of invoices and payment status by contractor will be required. The role will create all desktop requisitions for purchase orders and manage any increase requests needed. The individual will be meticulous in keeping proper records of timesheets and invoices. The role will involve daily communication with the Eversource vegetation management team, contractor home office staff, and/or contractor field supervision.

In addition to timesheet and invoice responsibilities, the individual will track and perform analytics related to contractor performance KPIs and weekly production metrics. The role will maintain daily contractor crew locations to distribute to the team and monitor an email inbox for customer inquiries. The individual will assist with regulatory reporting including creating summary tables, charts, or producing large mailings and will leverage the Microsoft Power Platform (Excel, Power BI, and Power Automate) to transform raw production metrics into automated workflows and interactive dashboards. The role will assist with any future transitions to work management or timesheet management software.

Essential Functions:

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

Technical Knowledge/Skill/Education/Licenses/Certifications:

Technical Knowledge/Skill:

• 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. Experience with Maximo is a plus.
• 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.
• Demonstrated experience building and maintaining interactive dashboards in Microsoft Power BI is preferred.
• Experience with Microsoft Power Automate or SQL is a plus.

Education:

• Bachelor’s degree in Finance, Business Administration, Data Analytics, Information Systems, Project Management or the equivalent in combined education and experience is required.

Experience:

• Minimum of three (3) years related professional experience. Experience within the utility industry is preferred but not required.

Working Conditions:

• The physical demands described here are representative of those that must be met by the employee to successfully perform the essential functions of the job.Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.
• Work is performed primarily in an office environment. Travel to office location in Berlin, Connecitcut, and occasionally to MA and NH, will be required.
• Must be available to work emergency storm assignment as required.
• Work is performed primarily in an office environment and requires standing, sitting, walking, climbing stairs, writing, typing, speaking, and presenting to individuals and groups.
• Work involves extensive use of a computer and significant interaction with individual at all levels of the organization.

Competencies:

Build trusting relationships

Manage and develop people

Foster teamwork and cross-functional collaboration

Lead change

Communicate strategic vision

Create an engaged workforce

Focus on the customer

Take ownership & accountability

Eversource offers a competitive total rewards program.Check out our careers site for an overview of our benefits programs. Salary is commensurate with your experience. This position is eligible for a potential incentive. The annual salary range for this position is:

$84,520.00-$93,910.00

Worker Type:

Regular

Number of Openings:

1

Emergency Response:

Responding to emergency situations to meet customers’ needs is part of every employee’s role. If employed, you will be given an Emergency Restoration assignment. This means you may be called to assist during an emergency outside of your normal responsibilities, work hours and location.

#LI-ES3

#LI-Hybrid

#engajd

EEO Statement

Eversource Energy is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, sexual orientation, gender identity, national origin, religion, disability status, or protected veteran status.

VEVRRA Federal Contractor