Infrastructure Data Analyst

at  City of Markham

The City of Markham is proud to be recognized for the 4th consecutive year as one of Canada’s Best Employers by Forbes and Statista Inc. In 2024, the City of Markham is ranked the top city in Ontario and in the top 10 for Government Services. The recipient of multiple environmental awards, we are recognized for our innovative sustainability and urban planning initiatives as well as our fiscal accountability. More than 357,000 residents call Markham home and benefit from our rich heritage, culturally diverse environment, vibrant local economy and focus on quality of life.
Applications are now being accepted for the regular full-time Infrastructure Data Analyst position in the Environmental Services department in the Community Services Commission. While all applications will be received, current members of CUPE 905 (Inside Workers) will be given first consideration. To apply for this position, please submit your cover letter and resume online by October 13, 2024.
Join us and make a lasting difference!

JOB SUMMARY

Reporting to the Manager of IMS/ Capital Planning in Environmental Services, this position will be responsible for:

• Development and implementation of standard processes for collecting, updating, maintaining and managing the asset infrastructure information; and maintain relevant parts of the infrastructure asset registry
• Analyze and maintain the asset and geomatics database related to various infrastructure assets
• Research and forecast asset management trends, projecting current activities and programs into longer-term needs.
• Update the lifecycle reserve study for all Environmental Services’ assets
• Assist in preparation of annual capital budget requests for all infrastructure assets
• Assist in preparing/ updating the annual capital works programs for all infrastructure assets upgrades, rehabilitations and maintenance projects
• Assist in the update and implementation of City’s Asset Management Plan and related policy and procedures based on Asset Management Best Practices and O. Reg. 588/17: Asset Management Planning for Municipal Infrastructure
• Assist in capital planning, developing service standards and performance measures

MINIMUM REQUIREMENTS

• Post-secondary diploma or degree from a recognized college or university in GIS/ Engineering or Engineering Technologist diploma in Civil Engineering, or a similar discipline
• Five or more years of progressively responsible related experience with public infrastructure data/asset management programs;
• Knowledge and experience with Canadian and the international asset management standards and best practices with a focus on the municipal sector is mandatory
• Proficiency in computer software such as AutoCAD and geographic information systems (ArcGIS)
• Strong Excel toolset - mastery of filters, v-look-ups, pivot tables and formulas.
• Strong analytical skills and problem solving abilities.
• Excellent teamwork and oral and written communication skills.

KEY DUTIES AND RESPONSIBILITIES:

• Liaison and coordinate with the internal sections and departments to update the lifecycle reserve study for all Environmental Services’ assets including: water, wastewater, stormwater, structures (bridges and culverts), streetlight assets.
• Analyzes and maintains the asset and geomatics database related to condition inspection, rehabilitation/ replacement and upgrade of City’s various infrastructure assets
• Maintain relevant parts of asset registry through field inspections, asset data collection, and proficient use of City’s asset management software systems (e.g. GIS, EAM, etc.)
• Responsible for development and implementation of standard processes for collecting, updating, maintaining and managing the asset infrastructure information, condition inspections and mapping.
• Assist in preparation of annual capital budget requests for all infrastructure assets.
• Assist in the update and implementation of City’s Asset Management Plan and related policy and procedures based on Asset Management Best Practices and O. Reg. 588/17: Asset Management Planning for Municipal Infrastructure
• Research and perform quantitative data analysis to project asset remaining useful life and update current and future programs.
• Provide asset related information including maps to internal and external customers in a timely manner.
• Coordinates with internal sections to establish risk management practices and performance measures.
• Research and assist in implementation of best practices for asset management including condition inspections, capital planning, developing service standards and performance measures.
• Other duties as assigned by the Manager, IMS/ Capital Planning and Senior Manager, Infrastructure.

Reporting to the Manager of IMS/ Capital Planning in Environmental Services, this position will be responsible for:

• Development and implementation of standard processes for collecting, updating, maintaining and managing the asset infrastructure information; and maintain relevant parts of the infrastructure asset registry
• Analyze and maintain the asset and geomatics database related to various infrastructure assets
• Research and forecast asset management trends, projecting current activities and programs into longer-term needs.
• Update the lifecycle reserve study for all Environmental Services’ assets
• Assist in preparation of annual capital budget requests for all infrastructure assets
• Assist in preparing/ updating the annual capital works programs for all infrastructure assets upgrades, rehabilitations and maintenance projects
• Assist in the update and implementation of City’s Asset Management Plan and related policy and procedures based on Asset Management Best Practices and O. Reg. 588/17: Asset Management Planning for Municipal Infrastructure
• Assist in capital planning, developing service standards and performance measure