Program Analyst, Project Controls (Hybrid Schedule)

Eversource Energy•Hartford, CT

4d•$87,140 - $96,820•Hybrid

About The Position

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.

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, including:
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.

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.
Databases and SQL knowledge required.
Project Management certification (PMP) is highly desirable.

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.