About the role
Job ID: 64125
Job Category: Information & Technology Division & Section: Parks & Recretion, PFR Bus & Technology Transformations Work Location: Metro Hall, 55 John St, Toronto, ON M5V 0C4 Job Type & Duration: 1 Temporary Vacancy, 12 months Hourly Rate: $44.64 - $48.88 Shift Information: Monday to Friday, 35 hours per week Affiliation: Local 79 Full-Time Unit Number of Positions Open: 1 Posting Period: 22-July-2026 to 06-Aug-2026
Job Summary
To provide technical support and assist in data cleaning, manipulation, analysis and visualization on data to deliver insights and contribute to evidence informed decision making and solutions.
Major Responsibilities
Provides technical support and assists with performing data cleaning, manipulation, analysis and visualization to support data migration, implementation, evidence-informed decision-making and issue resolution. Contributes to the development of data models, dashboards and databases. Sets up data queries, builds Extract, Transform and Load (ETL) processes, data preparation workflows and reusable scripts to support data migration from legacy systems and manual spreadsheet-based sources into IBM Maximo and related enterprise applications. Provides technical expertise using data analysis, migration, transformation, mapping, validation and reconciliation techniques to support data-driven implementation decision-making. Formulates data-related recommendations to support data migration, data quality improvement, implementation readiness and issue resolution. Connects a variety of business data such as asset location, spatial acility condition d business data and analyzes data to support migration readiness, implementation decisions and operational insights. Ensures data quality, identifies errors and performs data cleanses, validates, standardizes and reconciles datasets, including identifying completeness, consistency, duplication, formatting, taxonomy, referential integrity and other data quality issues. Builds data visualizations, reports and briefing materials to inform decision-making and contribute to implementation updates and briefing decks. Guides stakeholders in understanding data findings, validation results, dashboards and reporting tools used to support decision-making. Produces data visualization and reports using structured, spreadsheet-based, database, spatial and geospatial data sources. Tracks and maintains KPIs, data quality indicators, migration progress measures and business impacts related to a major technology and process transformation. Troubleshoots and takes actions to resolve issues associated with data quality, data migration, interpretation, reporting, testing and post-load validation. Communicates analysis results, data quality findings, assumptions, transformation decisions, defects and implementation issues to internal and external stakeholders. Compiles data, reconciliation, validation and statistical reports based on data analysis, including formatting for clarity, structure and decision-making. Maintains data, documentation and records in accordance with information management, privacy, ethical analytics and data governance best practices and guidelines. Develops, fosters and maintains effective working relationships with internal and external stakeholders. Builds relationships with key business users and decision makers to understand business requirements, confirm data definitions, validation rules, taxonomy decisions and acceptable data quality thresholds. Supports knowledge transfer to team members and stakeholders on data definitions, validation rules, data quality findings, dashboards, reports and data processes.
Key Qualifications
Your application must desribe your qualifications as they relate to:
Post-secondary education in Data Analytics/Science, Statistics, Geographic Information System/Geomatics, Computer Science, Mathematics, Building Systems/Science, Asset Management, Facilities Management, or an equivalent combination of education and relevant experience. Experience supporting data migration, conversion, or system implementation, including preparing, transforming, validating, reconciling, and documenting data from legacy systems or manual sources into enterprise applications. Experience with source-to-target data mapping, including field relationships, transformation rules, business rules, exceptions, and unresolved mapping issues. Experience profiling, cleansing, validating, standardizing, and reconciling complex datasets, including data quality issues related to completeness, consistency, duplication, formatting, taxonomy, and referential integrity. Experience using databases, query languages, scripting, or data preparation tools to extract, analyze, transform, automate, test, and validate data, including Structured Query Language (SQL), Oracle or similar databases, Python, Tableau Prep, or comparable tools.
You must also have
Familiarity with data dictionaries, data lineage, taxonomy, controlled vocabularies, business glossaries, or related metadata documentation. Familiarity with Geographic Information System (GIS) tools, spatial data, or location-based asset data. A willingness to learn about enterprise asset management, work management, facility management, and maintenance management systems.
Equity, Diversity and Inclusion
The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.
Accommodation
The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.
Not the right fit? Search for DATA ANALYST & INTEGRATOR jobs in Toronto, Ontario, Canada
About City of Toronto
The City of Toronto is committed to fostering a positive and progressive workplace culture, and strives to build a workforce that reflects the citizens it serves. We are committed to building a high performing public service, with strong and effective leaders to enable service excellence, through high engagement and healthy and safe workplaces.
Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canada’s leading economic engine and one of the world’s most diverse and livable cities. As the fourth largest city in North America, Toronto is a global leader in technology, finance, film, music, culture, and innovation, and consistently places at the top of international rankings due to investments championed by its government, residents and businesses.
Toronto Public Service consists of approximately 35,771 employees, providing programs and services to Toronto residents, businesses and visitors. Additionally, the City of Toronto has a number of agencies and corporations including the Toronto Police Service, Toronto Public Library and the Toronto Transit Commission, which make up the broader municipal organization.
There are 44 operating divisions and offices providing an extensive level of programs and services. We offer diverse career opportunities across a wide variety of professional, trade, administrative, managerial and other employment roles. The Toronto Public Service has won numerous awards for quality, innovation and efficiency in delivering citizen-focused services. We are proud to have been named one of Canada's Top 100 Employers, Canada's Best Diversity Employers, Top Family Friendly Employers and Greater Toronto's Top Employers.
Consider joining the award-winning Toronto Public Service and help us make a difference in a great City!
Similar Jobs
About the role
Job ID: 64125
Job Category: Information & Technology Division & Section: Parks & Recretion, PFR Bus & Technology Transformations Work Location: Metro Hall, 55 John St, Toronto, ON M5V 0C4 Job Type & Duration: 1 Temporary Vacancy, 12 months Hourly Rate: $44.64 - $48.88 Shift Information: Monday to Friday, 35 hours per week Affiliation: Local 79 Full-Time Unit Number of Positions Open: 1 Posting Period: 22-July-2026 to 06-Aug-2026
Job Summary
To provide technical support and assist in data cleaning, manipulation, analysis and visualization on data to deliver insights and contribute to evidence informed decision making and solutions.
Major Responsibilities
Provides technical support and assists with performing data cleaning, manipulation, analysis and visualization to support data migration, implementation, evidence-informed decision-making and issue resolution. Contributes to the development of data models, dashboards and databases. Sets up data queries, builds Extract, Transform and Load (ETL) processes, data preparation workflows and reusable scripts to support data migration from legacy systems and manual spreadsheet-based sources into IBM Maximo and related enterprise applications. Provides technical expertise using data analysis, migration, transformation, mapping, validation and reconciliation techniques to support data-driven implementation decision-making. Formulates data-related recommendations to support data migration, data quality improvement, implementation readiness and issue resolution. Connects a variety of business data such as asset location, spatial acility condition d business data and analyzes data to support migration readiness, implementation decisions and operational insights. Ensures data quality, identifies errors and performs data cleanses, validates, standardizes and reconciles datasets, including identifying completeness, consistency, duplication, formatting, taxonomy, referential integrity and other data quality issues. Builds data visualizations, reports and briefing materials to inform decision-making and contribute to implementation updates and briefing decks. Guides stakeholders in understanding data findings, validation results, dashboards and reporting tools used to support decision-making. Produces data visualization and reports using structured, spreadsheet-based, database, spatial and geospatial data sources. Tracks and maintains KPIs, data quality indicators, migration progress measures and business impacts related to a major technology and process transformation. Troubleshoots and takes actions to resolve issues associated with data quality, data migration, interpretation, reporting, testing and post-load validation. Communicates analysis results, data quality findings, assumptions, transformation decisions, defects and implementation issues to internal and external stakeholders. Compiles data, reconciliation, validation and statistical reports based on data analysis, including formatting for clarity, structure and decision-making. Maintains data, documentation and records in accordance with information management, privacy, ethical analytics and data governance best practices and guidelines. Develops, fosters and maintains effective working relationships with internal and external stakeholders. Builds relationships with key business users and decision makers to understand business requirements, confirm data definitions, validation rules, taxonomy decisions and acceptable data quality thresholds. Supports knowledge transfer to team members and stakeholders on data definitions, validation rules, data quality findings, dashboards, reports and data processes.
Key Qualifications
Your application must desribe your qualifications as they relate to:
Post-secondary education in Data Analytics/Science, Statistics, Geographic Information System/Geomatics, Computer Science, Mathematics, Building Systems/Science, Asset Management, Facilities Management, or an equivalent combination of education and relevant experience. Experience supporting data migration, conversion, or system implementation, including preparing, transforming, validating, reconciling, and documenting data from legacy systems or manual sources into enterprise applications. Experience with source-to-target data mapping, including field relationships, transformation rules, business rules, exceptions, and unresolved mapping issues. Experience profiling, cleansing, validating, standardizing, and reconciling complex datasets, including data quality issues related to completeness, consistency, duplication, formatting, taxonomy, and referential integrity. Experience using databases, query languages, scripting, or data preparation tools to extract, analyze, transform, automate, test, and validate data, including Structured Query Language (SQL), Oracle or similar databases, Python, Tableau Prep, or comparable tools.
You must also have
Familiarity with data dictionaries, data lineage, taxonomy, controlled vocabularies, business glossaries, or related metadata documentation. Familiarity with Geographic Information System (GIS) tools, spatial data, or location-based asset data. A willingness to learn about enterprise asset management, work management, facility management, and maintenance management systems.
Equity, Diversity and Inclusion
The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.
Accommodation
The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.
Not the right fit? Search for DATA ANALYST & INTEGRATOR jobs in Toronto, Ontario, Canada
About City of Toronto
The City of Toronto is committed to fostering a positive and progressive workplace culture, and strives to build a workforce that reflects the citizens it serves. We are committed to building a high performing public service, with strong and effective leaders to enable service excellence, through high engagement and healthy and safe workplaces.
Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canada’s leading economic engine and one of the world’s most diverse and livable cities. As the fourth largest city in North America, Toronto is a global leader in technology, finance, film, music, culture, and innovation, and consistently places at the top of international rankings due to investments championed by its government, residents and businesses.
Toronto Public Service consists of approximately 35,771 employees, providing programs and services to Toronto residents, businesses and visitors. Additionally, the City of Toronto has a number of agencies and corporations including the Toronto Police Service, Toronto Public Library and the Toronto Transit Commission, which make up the broader municipal organization.
There are 44 operating divisions and offices providing an extensive level of programs and services. We offer diverse career opportunities across a wide variety of professional, trade, administrative, managerial and other employment roles. The Toronto Public Service has won numerous awards for quality, innovation and efficiency in delivering citizen-focused services. We are proud to have been named one of Canada's Top 100 Employers, Canada's Best Diversity Employers, Top Family Friendly Employers and Greater Toronto's Top Employers.
Consider joining the award-winning Toronto Public Service and help us make a difference in a great City!