Associate Program Analyst, Project Control (Hybrid)
03/12/2024Locations East Berlin, Connecticut
Job Description
Associate Program Analyst, Project Control (Hybrid)
03/12/2024Locations: East Berlin, Connecticut
This is a hybrid role with the first three months in the office.
Eversource is looking for an Associate Program Analyst, Project Control located in Berlin, CT or Hartford, CT. In this role you are responsible for developing, programming, and maintaining Power BI Reports, to report on the performance of the Transmission and Engineering organizations, to ensure timely and efficient monitoring and analysis of project costs, trends, schedules and transmission and engineering services. Responsible for assisting in the development of visual reports, dashboards and KPI scorecards using Power BI Desktop, connecting to various data sources, importing data and transforming data to be utilized for Business Intelligence. Must exhibit excellence in analytical thinking for translating data into informative visuals and reports as well as perform compliance reviews of data for validation of business requirements.
Essential Functions:
Works within Transmission and Engineering Project Controls for the development of Power BI Reports, for reporting on the overall effectiveness and performance of internal and external organizations, pulling information from various systems such as Maximo, Power Plan, Access, and Oracle Primavera and transforming the data into Power BI desktop tools.
Works with Transmission and Distribution Engineering, Project Planning and Scheduling, Project Management, Operations, Contract Administration, Procurement, to gather requirements for development of Power BI Reports, in alignment with corporate goals and strategies.
Gathers verbal requirements from business users in meetings and implement programming anddevelopment of PowerBI reports as required to support the need of the end users.
Assists in production of a variety of complex reports in support of Eversource’s project initiating, planning, scheduling, contracting, executing, controlling, compliance and close-out initiatives within the Transmission and Engineering organizations.
Responsible for developing Power BI Reports to report out on key Transmission & Engineering metrics including Contracted Spend, Schedule Performance, Resource Loading, Risk Management, Project Productivity, Change Order Management, Subcontracted Vendor Performance, Internal and External Commercial Performance, and other key metrics that will continue to drive efficiency and transparency for execution of the work.
Must be able to independently analyze and validate data based on business knowledge to ensure accuracy prior to publishing reports.
Must be able to assist in the integration of Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
Technical Knowledge/Skill/Education/Licenses/Certifications:
Technical Knowledge/Skill:
Office, Access, Power BI, SQL Coding Language, Oracle Primavera, Power Plan, Maximo, and SharePoint.
Must be detailed oriented to catch and fix data errors during validation and demonstrate self-reliance with a strong sense of self-motivation, good communication skills, and demonstrate the ability to work independently.
Knowledge of financial modeling, accounting, risk management, project management information systems, economics, capital investment analysis techniques, plant accounting, tax and capital budgeting.
Must have the ability to monitor and analyze cost and scheduling information, provide forecasts, make recommendations, and communicate effectively at all levels.
Must have knowledge and experience in prototyping, designing, and requirement analysis.
Must be able to exhibit a professional demeanor and effectively present to other business users.
Adept in developing, publishing and scheduling Power BI Reports as per the business requirements. Able to properly understand the business requirements and develop efficient data models based on the described scope and need.
Must be familiar with DAX programming language and exhibit proficiency in using advance level calculations on the data set. Position will be responsible for design methodology and project documentation.
Education:
Bachelor’s Degree in Business Analytics, Information Systems, related discipline, or equivalent experience
Experience:
Zero (0) - Three (3) years of experience working with a self-service tool, preferably Power BI
SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
DAX programming language
Data preparation, data gateway and data warehousing projects
Compensation and Benefits:
Eversource offers a competitive total rewards program. The annual salary range for this position is $62,800to$72,000,plus incentive. Salary is commensurate with your experience. Check out the career site for an overview of our benefits.
Licenses & Certifications:
Power BI Data Modelling (with DAX) and Databases and SQL for Data Science strongly preferred
#tranajd
Worker Type:
RegularNumber of Openings:
1EEO 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
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.
Overview
Eversource currently operates more than 4,270 circuit miles of transmission lines, 72,000 pole miles of distribution lines, 578 substations, 449,737 distribution transformers and 11,683 miles of natural gas distribution pipelines across our service territory. As an integral member of our transmission team, you'll work in a dynamic and collaborative environment to identify business opportunities and balance risk-mitigation strategies to drive our growth.
Culture
Our goal is to remain the best energy company in the nation, and to be the first with carbon-neutral operations by 2030.
We will achieve this by valuing the diversity of employees who bring different perspectives to the table. We are committed to :
- Creating an inclusive workplace where all employees, customers and stakeholders are respected and valued.
- Leveraging the talent, unique perspectives, cultural and life experiences of every employee to ensure our continued success .
- Attracting, developing and retaining a diverse workforce that can work together to meet the changing needs of the customers we serve while delivering reliable energy and superior customer service.
About us
Success Profile
What makes a successful Transmission team member?
Check out the top traits we're looking for and see if you have the right mix.
- Collaborative
- Customer Focus
- Team Player
- Adaptable
- Detail Oriented
- Positive
Employee Quotes
Job Description
Associate Program Analyst, Project Control (Hybrid)
03/12/2024Locations: East Berlin, Connecticut
This is a hybrid role with the first three months in the office.
Eversource is looking for an Associate Program Analyst, Project Control located in Berlin, CT or Hartford, CT. In this role you are responsible for developing, programming, and maintaining Power BI Reports, to report on the performance of the Transmission and Engineering organizations, to ensure timely and efficient monitoring and analysis of project costs, trends, schedules and transmission and engineering services. Responsible for assisting in the development of visual reports, dashboards and KPI scorecards using Power BI Desktop, connecting to various data sources, importing data and transforming data to be utilized for Business Intelligence. Must exhibit excellence in analytical thinking for translating data into informative visuals and reports as well as perform compliance reviews of data for validation of business requirements.
Essential Functions:
Works within Transmission and Engineering Project Controls for the development of Power BI Reports, for reporting on the overall effectiveness and performance of internal and external organizations, pulling information from various systems such as Maximo, Power Plan, Access, and Oracle Primavera and transforming the data into Power BI desktop tools.
Works with Transmission and Distribution Engineering, Project Planning and Scheduling, Project Management, Operations, Contract Administration, Procurement, to gather requirements for development of Power BI Reports, in alignment with corporate goals and strategies.
Gathers verbal requirements from business users in meetings and implement programming anddevelopment of PowerBI reports as required to support the need of the end users.
Assists in production of a variety of complex reports in support of Eversource’s project initiating, planning, scheduling, contracting, executing, controlling, compliance and close-out initiatives within the Transmission and Engineering organizations.
Responsible for developing Power BI Reports to report out on key Transmission & Engineering metrics including Contracted Spend, Schedule Performance, Resource Loading, Risk Management, Project Productivity, Change Order Management, Subcontracted Vendor Performance, Internal and External Commercial Performance, and other key metrics that will continue to drive efficiency and transparency for execution of the work.
Must be able to independently analyze and validate data based on business knowledge to ensure accuracy prior to publishing reports.
Must be able to assist in the integration of Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
Technical Knowledge/Skill/Education/Licenses/Certifications:
Technical Knowledge/Skill:
Office, Access, Power BI, SQL Coding Language, Oracle Primavera, Power Plan, Maximo, and SharePoint.
Must be detailed oriented to catch and fix data errors during validation and demonstrate self-reliance with a strong sense of self-motivation, good communication skills, and demonstrate the ability to work independently.
Knowledge of financial modeling, accounting, risk management, project management information systems, economics, capital investment analysis techniques, plant accounting, tax and capital budgeting.
Must have the ability to monitor and analyze cost and scheduling information, provide forecasts, make recommendations, and communicate effectively at all levels.
Must have knowledge and experience in prototyping, designing, and requirement analysis.
Must be able to exhibit a professional demeanor and effectively present to other business users.
Adept in developing, publishing and scheduling Power BI Reports as per the business requirements. Able to properly understand the business requirements and develop efficient data models based on the described scope and need.
Must be familiar with DAX programming language and exhibit proficiency in using advance level calculations on the data set. Position will be responsible for design methodology and project documentation.
Education:
Bachelor’s Degree in Business Analytics, Information Systems, related discipline, or equivalent experience
Experience:
Zero (0) - Three (3) years of experience working with a self-service tool, preferably Power BI
SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
DAX programming language
Data preparation, data gateway and data warehousing projects
Compensation and Benefits:
Eversource offers a competitive total rewards program. The annual salary range for this position is $62,800to$72,000,plus incentive. Salary is commensurate with your experience. Check out the career site for an overview of our benefits.
Licenses & Certifications:
Power BI Data Modelling (with DAX) and Databases and SQL for Data Science strongly preferred
#tranajd
Worker Type:
RegularNumber of Openings:
1EEO 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
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.
Benefits
Eversource employees are committed to providing reliable energy and superior customer service—and that's why we are committed to providing our employees with a highly competitive total rewards package. In addition to wages and salaries, the benefit programs Eversource offers its employees and family members are a significant part of the total rewards.
Healthcare, Wellness & Disability Protection for you and your Family
- Comprehensive Medical, Prescription, Dental, and Vision Plans, choose the coverage that is right for you and your family
- High deductible health plan option, with generous health savings account (HSA), employer contribution, ($500 individual; $1,000 employee +1 or more)
- Company-paid employee life and accident insurance and options to purchase additional coverage for you and your family
- An award-winning Wellness Program provides up to $200 annually for employees and spouses to adopt and maintain healthy lifestyles
- Health and Dependent care reimbursement accounts
- Sick Time, Short-Term & Long-Term Disability Plans
Work/Life Balance Benefit Programs
- Employee Assistance Program (EAP)
- Multi-faceted Behavioral Health Program
- Care@Work Program (child/elder care), membership/stipend for emergency services
- Adoption Assistance (eligible employees)
- Tuition Reimbursement, Student Loan Refinancing & Student Debt Counselling
- Voluntary benefits platform to access discounted home & auto, identity protection and pet insurance
- Charity donation gift matching
- Volunteer hours at local charities with rewards to our Wellness Program
- Generous time off
- Business Resource Groups for social connection and career development
Retirement Benefits for a Secure Future
- 401k: Up to 100% Employer Match on first 3% of employee's contributions
- K-Vantage: Additional Employer Contribution to the 401k based on age and years of service (2.5% to 6.5%)
- Med-Vantage HRA: Age 40+, receive annual $1,000 contribution to an HRA for post-employment qualified medical expenses