Program Analyst, Project Controls (Hybrid Schedule)

About the position

Eversource is seeking a motivated Program Analyst, Project Controls in Westwood, MA or 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.

Responsibilities

  • 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.
  • Interacts with Information Technology to resolve complex technical issues.
  • Maintains data mapping documents and processes, business matrix and/or other data design artifacts, which define business data requirements and transformation rules.

Requirements

  • 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.
  • Excellent analytical thinking, critical thinking, problem solving and business process optimization skills.
  • 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.
  • Experience with working in an Agile team environment.
  • Forward looking and focused on continuous improvement.
  • Ability to independently develop, present, and execute new projects and initiatives through collaboration with other departments.
  • Ability to read and understand contracts.
  • Bachelor’s Degree in Business Analytics, Data Analytics, Information Systems, Computer Science required
  • 3-5 years of experience is required
  • Experience with Data Visualization Tools: 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 analysis, data gateway and data warehousing projects.
  • Experience in managing large, complex multi-year projects.
  • Must hold a valid motor vehicle operator’s license.
  • Databases and SQL knowledge required.

Nice-to-haves

  • MBA or equivalent Master’s degree education strongly preferred
  • 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.
  • Project Management certification (PMP) is highly desirable.

Benefits

  • competitive total rewards program
  • potential incentive
Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...