Program Analyst, Project Control (Hybrid Schedule)

Eversource will not offer immigration-related sponsorship for this position.  Applicants who require immigration sponsorship—either now or in the future—should not apply.  This includes, but is not limited to, direct company sponsorship, listing Eversource as the employer of record on immigration documents, or any work authorization that requires company involvement or documentation (e.g., H-1B, OPT, STEM OPT, CPT, TN, J-1, O-1, etc.).

Eversource supports work-life balance by offering hybrid schedules for certain roles. Eligibility is based on job responsibilities, operational needs, nature of work and team dynamics. Current guidelines require employees to work at least three days in the office, including Tuesdays and Wednesdays, with the third day set by the employee and supervisor based on department needs. These guidelines apply to roles approved for remote work and are subject to change, based on managerial discretion and work performance. All applicants must be able to work up to five days in the office if needed (for example: emergencies, training, or other business needs) or should the policy change.

Eversource is seeking a motivated Program Analyst, Project Control in Hartford, CT.  In this role the candidate will play a critical role in transforming data into strategic insights that drive efficiency, performance, and decision-making, across our Transmission and Engineering organizations. This is a hands-on role responsible for developing and implementing Data Analytics solutions and automated workflows, to enhance project execution, supplier performance, and financial transparency. Ideal candidates will have extensive experience in Power BI and Data Analysis.

This position requires an analytical, solutions-focused professional with proficiency in Power BI, Power Automate, and SQL who can independently design and implement real-time dashboards, executive scorecards, and automated workflows that optimize business operations. The Program Analyst will work cross-functionally with internal stakeholders including Engineering, Project Controls (e.g. Planning & Scheduling and Cost Controls), Contract Controls, Project Management, Procurement, Project Services, Investment Planning, Operations, Safety, Human Resources, and Information Technology to identify automation opportunities, streamline reporting processes, and develop actionable insights that drive business decisions. This role will also help support and mentor Associate Program analysts, champion process improvements, and ensure data-driven insights can help to transform the organization's future growth and success.

Essential Functions: 

• Leads the design, development, and deployment of medium to high complexity Power BI Reports and Dashboards within Transmission and Engineering Project Controls, which will demonstrate the overall effectiveness and performance of internal Organizations & external Suppliers. 

• Navigates various systems to extract and transform data into meaningful and interactive visualization tools.  Systems may include Maximo, Power Plan, Access, Oracle Primavera, Workday, SIMS and Fieldglass.

• Possesses deep knowledge and understanding of stakeholder needs combined with data analysis techniques and tools, to ensure insights generated are relevant and actionable.

• Responsible for the entire lifecycle of analytical projects, from defining problems and requirements to data exploration, analysis, modeling, QA/QC review & data validation, and presenting insights.

• Determines needs, gathers requirements, and develops solutions for reporting, in alignment with corporate goals and strategies, including but not limited to Transmission, Engineering, Project Controls (e.g. Planning & Scheduling, Cost Controls), Contract Controls, Planning & Scheduling, Contract Administration, Project Management, Procurement, Project Services, Operations, Safety and Human Resources.

• Applies strong functional knowledge and requirements gathering techniques necessary to draw out data and analytics business requirements completely and accurately from stakeholders.

• Acquires and effectively translates verbal requirements from business users in meetings and implements programming and development of Business Intelligence Reports, in accordance with associated requests.

• Enhances existing methods and procedures to support continuous improvement program.

• Analyze business problems and recommend areas for automation. 

• Designs, develops, and implements medium complexity automated workflows, to improve business processes, using Microsoft Power Automate and associated product suites.

• Performs requirements planning, monitoring and requirements management.

• Independently performs data analysis, data discovery and data profiling using industry standard querying tools (SQL), to support business requirements development that are complete, clear, unambiguous, well written and appropriate to the audience.

• Produces a variety of Power BI Reports for various stages of a project such as initiating, planning, scheduling, contracting, executing, controlling, compliance and close-out, within Eversource’s Transmission and Engineering organizations.

• Reviews, evaluates, and reports on data trends and their impact on project lifecycle.

• Develops key Transmission & Engineering metrics which drive efficiency and transparency.  These include, but are not limited to, Contracted Spend, Requisition Lifecycle, Safety Incidents, Contract Approval Process Times, Change Order Reasons, Aging Approval Requests, Contractor KPIs, Transmission Staffing, Schedule Adherence and DCMA-14 Point Assessment.

• Develops Supplier Engineering & Construction project level KPIs and project statistics reports, to evaluate and compare Contractor Performance.  These KPIs should drive desired behaviors in key areas of Contract Compliance, RFPs, Change Orders, Quality, Schedule Adherence and Safety. 

• Develops Engineering KPIs, to evaluate the performance of Engineering Organizations, both internally and externally.

• Helps guide decision making, driving organizational performance improvement. 

• Interacts with Information Technology to resolve complex technical issues.

• Responsible for assisting Associate Program Analysts within the group.

• Stays informed of industry best practices and drives implementation of reporting tools that are in alignment.

• Provides support and consulting by answering questions, researching possible solutions to complex problems, and fostering open communication with the stakeholders.

• Identifies improvement opportunities to better align work, with the direction and strategic priorities of the broader organization.

• Conducts root cause analysis on identified issues and helps to resolve data quality problems.

• Maintains data mapping documents and processes, business matrix and/or other data design artifacts, which define business data requirements and transformation rules.

Technical Knowledge/Skill/Education/Licenses/Certifications:

Technical Knowledge/Skill: 

• Advanced knowledge of Industry Standard querying tools (SQL).

• Advanced knowledge of Microsoft Power BI and Power Automate is required.

• Knowledge of Microsoft Word, Excel, Power Point, Access, Outlook, Teams, OneNote, SharePoint, Visio and CoPilot is required.

• Self-reliant, with a powerful sense of self-motivation.

• Excellent analytical thinking, critical thinking, problem solving and business process optimization skills.

• Advanced business acumen with technical aptitude.

• Self-motivated to quickly learn new applications, processes, and procedures.

• Proven ability to manage competing priorities, support diverse needs and a track record of following through on commitments.

• Detailed oriented, with excellent written and verbal communication skills; excellent persuasion skills.

• Previous experience working in team environments, as well as supporting process improvements and group facilitation.

• Experience with working in an Agile team environment.

• Requires a good understanding of corporate strategies and initiatives along with a thorough understanding of the Transmission industry.

• Demonstrated high competence in past assignments and ability to influence group culture.

• Forward looking and focused on continuous improvement.

• Demonstrated ability to work with all levels of the organization.

• Ability to independently develop, present, and execute new projects and initiatives through collaboration with other departments.

• Ability to read and understand contracts.

Education:    

• Bachelor’s Degree in Business Analytics, Information Systems, Computer Science or equivalent experience required

• MBA or equivalent Master’s degree education strongly preferred

Experience:  

• 3-5 years of experience is required, including:

• Experience with Data Visualization Tools, such as Power BI and Tableau.

• Sound knowledge of Power BI Desktop, Power BI Service and working knowledge of Power Automate.

• Knowledge of SQL, Database Management, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

• Familiarity with DAX programming language.

• Knowledge of Data preparation, data gateway and data warehousing projects.

• Business Data Analyst experience preferred.

• Experience in managing large, complex multi-year projects.

Licenses & Certifications:  

• Must hold a valid motor vehicle operator’s license.

• Microsoft Power BI Data Analyst or equivalent certification highly desired.

• Microsoft Power Automate RPA Developer or equivalent certification highly desired.

• Power BI Data Modeling with DAX preferred.

• Databases and SQL knowledge required.

• Project Management certification (PMP) is highly desirable.

Working Conditions:

• Must be available to work emergency restoration assignment as required.

• Must be available to travel between MA/CT/NH as necessary.

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

• Travel will be required to Eversource engineering office locations, project sites and contractor locations.

• Work is performed primarily in an office environment which requires sitting, standing and general movement throughout the office area.

#LI-BC1

#transajd

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

Compensation and Benefits:

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,600.00-$94,000.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. 

EEO Statement:

Eversource Energy is an Equal Opportunity and Affirmative Action 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