Program Analyst, Project Control (Hybrid Schedule)

Eversource Energy-posted 2 days ago

Full-time • Mid Level

Hybrid • Hartford, CT

5,001-10,000 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

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.

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.

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.
Bachelor’s Degree in Business Analytics, Information Systems, Computer Science or equivalent experience required
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.
Must hold a valid motor vehicle operator’s license.

MBA or equivalent Master’s degree education strongly preferred
Business Data Analyst experience preferred.
Experience in managing large, complex multi-year projects.
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.

Eversource offers a competitive total rewards program.
Check out our careers site for an overview of our benefits programs.
This position is eligible for a potential incentive.

Track Jobs with Teal

Job Search Resources

•

Resume Builder

•

Program Analyst Resume Examples

•

Program Analyst Cover Letter Examples

Program Analyst, Project Control (Hybrid Schedule)

Job Search Resources

Tools

Career Hubs

Guides

Company