Portfolio Reporting & Analysis - Fall 2024 University Co-Op Student

at  Hydro One Networks Inc

49505 - Toronto - Temporary -
Hydro One is proud to be the largest electricity transmission and distribution provider in Ontario, serving nearly 1.4 million customers. We have a long history in the industry with our roots dating back over 110 years to 1906. Since then, we have worked to grow and evolve to meet the changing needs of our customers and communities across Ontario. Today, we’re focused on providing exceptional customer service and ensuring we are building safe communities where we live, work and play.
It’s an exciting time to join the team at Hydro One!

Role: Reporting to the Sr Programs Process Specialists/Supervisors, the primary duties of the coop student in the Portfolio Reporting & Analysis team will be to help the Portfolio & Financial Analysts support program & project managers by:

• Running & analyzing life-to-date cost reports
• Develop and update reports using Excel (pivot tables) and SAP as required
• Assisting with developing and uploading project forecasts
• Compiling explanations for variance to budget
• Preparing journals
• Managing status of cost objects in SAP
• Data reconciliation, support and updating data in tracking systems and SAP
• Assist in resource management and capacity planning of project and program work
• Creating resource requirements for projects
• Requesting resources and creating reports for outstanding requests
• Assist in User Acceptance Testing for system upgrade / reconfiguration of various softwares
• Preparing reports of equipment in-service
• Preparing insurance claim submissions
• Producing admin cost reports and maintaining related forecasts
• Assist in documenting data and actions/minutes during portfolio review meetings
• Assisting with other department initiatives, ad-hoc requests, and additional reporting requests as assigned

During their term the students can expect to learn technical skill such as:

• how to use SAP (mainly Controlling module, Project Systems, Plant Maintenance, Accounts Payable, BIBW)
• advanced Excel (functions, pivot tables, macros, some Visual Basic)
• knowledge of Project Management (planning, scheduling, control and reporting)
• practical management accounting, financial and data analysis skills
• assist in documenting data, attending portfolio review meetings

Job Requirements:

• Academic Level: 3rd year Business/Commerce, Finance/Accounting, Engineering/Computer Science, Mathematics stream

Hydro One requires that all students applying for student opportunities be enrolled in post-secondary level studies and be returning to full-time studies upon the completion of their work term. Exceptions will be made in cases where students require a work term in order to graduate. Only applications submitted via Hydro One’s career page will be accepted.
If you are an international student, please ensure you have obtained a proper work permit and a Social Insurance Number (SIN). Speak with your school’s career centre if you have any questions about acquiring this documentation.
At Hydro One we understand that the success and strength of our business rests with our people. When we develop their skills, we are investing in both their success and ours. To secure the best talent, we seek to create a workforce that reflects the diverse populations of the communities where we live and work and to create a culture based on safety, innovation and inclusiveness.

• Running & analyzing life-to-date cost reports
• Develop and update reports using Excel (pivot tables) and SAP as required
• Assisting with developing and uploading project forecasts
• Compiling explanations for variance to budget
• Preparing journals
• Managing status of cost objects in SAP
• Data reconciliation, support and updating data in tracking systems and SAP
• Assist in resource management and capacity planning of project and program work
• Creating resource requirements for projects
• Requesting resources and creating reports for outstanding requests
• Assist in User Acceptance Testing for system upgrade / reconfiguration of various softwares
• Preparing reports of equipment in-service
• Preparing insurance claim submissions
• Producing admin cost reports and maintaining related forecasts
• Assist in documenting data and actions/minutes during portfolio review meetings
• Assisting with other department initiatives, ad-hoc requests, and additional reporting requests as assigne