Job ID: 63132
Job Category: Information & Technology
Division & Section: Transportation Services, Policy Data & Strategic Initiatives
Work Location: 55 John St, Toronto (hybrid)
Job Type & Duration: Full-time, Permanent Vacancy
Hourly Rate: $52.38 - $57.39
Shift Information: Monday to Friday, 35 hours per week
Affiliation: L79 Full-time
Number of Positions Open: 1
Posting Period: 08-Apr-2026 to 27-Apr-2026
The Transportation Services Division is seeking a Senior Data Analyst & Integrator to join the Data & Analytics Unit. As part of the Policy & Innovation Section, the Data & Analytics Unit acts as a hub for data analytics and data management within the Transportation Services Division. The Unit is comprised of four teams: Data Operations (Emerging Mobility), Data Science (Safety & Mobility), Data Collection and Digital Products (MOVE). Check out some of our past projects here.
This role will sit in the Data Operations team, which is responsible for the Data & Analytics Unit's digital infrastructure including pulling, hosting, transforming, cleaning, validating, and publishing transportation data, as well as the testing and evaluation of new sources of data. The team additionally conducts analysis of Emerging Mobility such as car share and the vehicle-for-hire industry.
Major Responsibilities:
Data Operations Responsibilities:
- Develops and maintains processes and methods to Extract, Transform and Load (ETL) large transportation datasets from structured and unstructured data sources such as GPS-probe data, sensor-based data, traffic collision data, emerging mobility providers, and other large datasets.
- Evaluates the quality of transportation datasets and identifies data quality issues with a goal of automating anomaly detection, filtering, and reporting.
- Provisions data infrastructure in collaboration with Technology Services to ensure the reliable operations for the Unit, as well as the reliable and automated flow of data to partners within the City of Toronto including Open Data.
- Manages codebases for data pipelines and other projects using git and GitHub
- Leads the development of self-serve tools for the Transportation Services Division to access useful data transformations and data products.
- Processes, cleans, and manages spatial data using spatial databases (PostgreSQL/PostGIS) and GIS to support analyses and the development of web mapping applications.
- Prepares data requests for internal and external requestors together with other technical staff in the Data & Analytics Unit.
Researching the State of the Art of Transportation Data
- Conducts research relating to transportation, traffic, big data, data analytics, data science, machine learning, data visualization and smart cities topics in order to build an understanding of best practices.
- Identifies and monitors emerging transportation data sources, including those with potential applications in current and future Divisional projects and programs.
- Keeps abreast of current and emerging techniques and technologies in the fields of big data, data science and data visualization.
- Research best practices on transportation analytics and big data initiatives from academia and other municipalities and levels of government and prepares briefing notes, presentations and technical documentation.
- Maintains an electronic library/catalogue of applicable research data, statistics, books, periodicals and reference material.
- Plans, evaluates and conducts pilot studies to assess transportation analytics and data management technologies, methodologies and/or computer systems.
Communication
- Prepares technical documentation on queries, routines and processes in support of initiatives, programs and day-to-day functions of the Data & Analytics Unit to facilitate the transfer of knowledge and consistent practices.
- Prepares abstracts, reports, technical memos and presentations.
- Summarizes findings by preparing static and interactive visualizations including maps, tables, graphs, charts, diagrams and graphics.
- Attends meetings with staff, including the preparation of presentations for stakeholders on transportation statistics; networks with other Departments/Divisions, different levels of government, consultants, contractors and vendors to assess options and determine best solutions.
- Liaises with and responds to inquiries from the public, City staff, consultants, contractors, external government agencies, elected officials, Toronto Police Service, etc.
- Assists in the procurement of services and goods, including the preparation of Request for Proposals/Quotations and the evaluation of bids and proposals.
- Writes reports, including the preparation of budgets and tracking of expenditures.
Key Qualifications:
Your application must describe your qualifications as they relate to:
- Post-secondary degree or diploma in Engineering, Computer Science, Transportation or Sciences with relevant experience and/or an approved equivalent combination of