Asset Investment Analyst

Toronto Hydro; Toronto; Hybrid; CAD 91,000 - 114,000; Full time

Benefits offered by this job

Health & dental benefits

Employee assistance program

Life insurance

Spending account

Paid time off

Pension plan

Tuition reimbursement

Employee engagement events

Job summary

Toronto Hydro is seeking an Asset Investment Analyst to provide engineering support for the electrical distribution system. You will manage data, run analyses, assess gaps/trends, and prepare reports related to customer connections requests and settlement processing in line with OEB regulations.

The role involves collaborating across teams, processing OTC reviews for expansion projects, and supporting data quality initiatives. Hybrid work arrangement with Ontario residency required.

Qualifications

• Engineering degree in a related field or equivalent experience.
• 3 years in data management, process optimization and business analysis.
• Knowledge of Distribution system code and OEB regulations.
• GIS knowledge.
• Experience with Alteryx, SQL and Tableau; RPA considered an asset.
• Project management designation is an asset.
• Demonstrated leadership, strategic thinking and communication skills.
• Ability to anticipate technology trends and their business impact.

Responsibilities

• Act as primary contact for customer connections data requests and reports.
• Analyze gaps and trends; recommend solutions.
• Identify automation opportunities using tools and systems (e.g., Alteryx).
• Improve analytics and decision support with visualization tools (e.g., Tableau).
• Provide timely technical support and project management; develop business proposals and processes.
• Profile data quality and assess risks for new applications.
• Collaborate with stakeholders on OTC reviews for expansions.

Skills

Data analysis

GIS

SQL

Tableau

Alteryx

RPA

Project management

Leadership

Education

Engineering degree (Electrical / Information Systems / GIS related)

Tools

Alteryx

SQL

Tableau

Job description

Expected Salary Range

$90810 - $113512 Annually

Target Variable Performance Pay

8%

The salary range shown above reflects the expected compensation for this position.

The final salary offered will be determined based on a holistic assessment of the candidate’s experience, education, training, and alignment with the role’s requirements. For positions covered by a collective agreement, placement within the range will follow the applicable step or classification.

Reporting to the Manager, Customer Connections Planning & Technical Analysis, the Asset Investment Analyst will provide a wide range of engineering support services that will ensure technical soundness, reliability, safety and cost effectiveness of the utility and its Electrical Distribution Power System. The Asset Investment Analyst is responsible for data management, data analytics, identifying gaps and trends as well as producing reports related to the customer connections’ requests. The incumbent will support reviewing offer to connects, running economic evaluation model, and processing yearly settlements as per current OEB regulations, distribution system codes and Toronto Hydro Conditions of Service.

This posting is for an existing vacancy.

Key Responsibilities

• Acts as the primary point of contact to assist with incoming communications from all channels related to customer connections, analysis of ongoing requests, maintain records, develop reports, and support data quality programs to improve the accuracy of asset data
• Identifies gaps and trends and performs analyses to determine root causes and develops recommended solutions
• Identifies workflow automation opportunities utilizing available tools and systems (e.g., Alteryx)
• Identifies opportunities to improve analytics and decision support using visualization software (e.g., Tableau)
• Provide timely technical support and consultation, demonstrate effective project management and process efficiencies; review, develop and/or present business proposals, plans, designs, processes, operational procedures and practices.
• Perform data profiling to produce data quality metrics and assess associated risks involved in integrating or converting data for new applications
• Collaborates with internal and external stakeholders to support the review of offer to connect (OTC) for expansion projects and ensure Toronto Hydro standards and conditions of service guidelines are met
• Conduct thorough analysis of power consumption for past expansion projects to timely process the settlement and release of line of credit
• Creates a repository of centralized reporting to track and maintain records and reports for all customer connections requests. Validate, manipulate and export data related to GIS and EAM systems for quality and completeness
• Runs periodic checks on database tables to ensure that the data is valid and consistent
• Develop process maps and workflow visualizations to support strategic decision making
• Participate and collaborate with various internal stakeholders

Requirements

• Undergraduate degree in Engineering (preferably in Electrical, Information Systems, Geography/GIS, or a related discipline); an equivalent combination of education and experience will be considered.
• Three (3) years of experience in data management, process optimization, and business analysis, including identifying improvement opportunities and developing data quality initiatives.
• Knowledge and application of Distribution system code, OEB regulations, conditions of service
• Knowledge of Geographic Information Systems (GIS)
• Solid understanding of relational database systems, possess the ability to transform raw data in different formats into various analytical reports
• Experience with Alteryx, SQL, Robotics Process Automation (RPA) and Tableau considered an asset
• Project management designation considered an asset
• Demonstrated leadership skills; strategic thinking, openness to new ideas, and strong communication skills
• Ability to predict and understand technological trends and their effect on business or strategic work plans

TOTAL REWARDS

To support the overall well-being and success of our employees, Toronto Hydro provides a comprehensive total rewards package which includes:

• 100% employer paid Health & Dental benefits
• 24/7 access to Employee & Family Assistance Program and Virtual Healthcare
• Company-paid life insurance and long term disability
• Spending account to support fitness goals (e.g. gym memberships)
• Competitive paid time off (including vacation and parental leave)
• Defined Benefits Pension Plan through OMERS
• Career development and tuition reimbursement
• Exciting employee engagement and appreciation events throughout the year

This position is based in a hybrid environment allowing for remote work two days per week, based on business needs. Employees will be required to come onsite Tuesday to Thursday. You are expected to live in Ontario and within reasonable commuting distance of the office.

Toronto Hydro is committed to leveraging new technologies to support an efficient and inclusive recruitment process. As part of this, artificial intelligence (AI) systems may be used to assist in screening, assessing, or selecting applicants for this position. These tools are used in combination with human decision-making to ensure fairness and consistency.

ACCESSIBILITY AND APPLICATION SUPPORT

Toronto Hydro is committed to fostering an inclusive and accessible recruitment process. Thank you for considering a career with Toronto Hydro. We welcome applications from all qualified candidates. If you’re having difficulty using our online application system and require accommodation, please email [e-mail] or call [phone]. Toronto Hydro is pleased to provide reasonable accommodation for qualified individuals throughout the job application process. Please note this email is for accommodation requests only. Resumes sent to this email address will not be considered. Learn more about our commitment to accessibility.