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

Disability coverage

Spending account

Paid time off

OMERS pension

Tuition reimbursement

Engagement events

Job summary

Toronto Hydro is hiring an Asset Investment Analyst to support data management, analytics, and reports for customer connections requests. The role emphasizes data quality, trends analysis, and formal reporting to inform decisions about expansion projects and settlements under OEB rules.

The position requires a degree in engineering with GIS/IS focus and 3 years in data management, analytics, and process improvements.

Qualifications

• Engineering degree or equivalent.
• 3 years in data management, process optimization, and business analysis.
• Knowledge of Distribution system code, OEB regulations, conditions of service.
• GIS, Alteryx, SQL, Tableau; RPA is a plus.
• Strong communication and project management skills.

Responsibilities

• Serve as primary contact for customer connections analytics requests.
• Identify gaps, root causes, and develop data-driven solutions.
• Automate workflows using Alteryx and related tools.
• Enhance analytics via Tableau visuals and dashboards.
• Support OTC reviews for expansion projects and ensure standards.
• Analyze power consumption for expansion projects and settlements.
• Create centralized reporting repository for OTC requests and data quality.
• Collaborate with stakeholders on data analysis initiatives.

Skills

Data management

Data analysis

Process optimization

Business analysis

Leadership

Stakeholder engagement

Education

Engineering degree (Electrical/IS/GIS) or related

Tools

Alteryx

SQL

Tableau

GIS

RPA

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.

T his 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 .