Senior Data Analyst & Integrator (Data Operations)

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:

1. Post-secondary degree or diploma in Engineering, Computer Science, Transportation or Sciences with relevant experience and/or an approved equivalent combination of education and experience. A post-graduate degree would be considered an asset.
2. Considerable experience with databases and data warehousing including organizing, compiling, manipulating and analyzing large datasets.
3. Considerable experience writing code using Python, R or other equivalent tools to automate data pipelines, develop Extract, Transform and Load processes, or perform repeatable analyses.

You must also have:

• Knowledge in urban planning, traffic engineering and/or transportation planning.
• Experience with GIS (Geographic Information Systems), spatial analysis, spatial databases, cartography and mapping.
• Knowledge of interactive data visualization, interactive mapping, web development, data product and dashboard development.
• Knowledge of the Amazon Web Services (AWS) or Red Hat Enterprise Linux (RHEL) ecosystems.
• Knowledge of DevOps tools and concepts (CI/CD) and containerization (Docker)
• Knowledge of automated tests and Test-Driven Development (TDD)
• Knowledge of predictive analytics and machine learning.
• Excellent oral and written ability to communicate effectively and the ability to present research and analysis findings effectively.
• Strong analytical, problem-solving and organizational skills, together with an ability to take initiative, multi-task, and work under time constraints, and exercise good judgement. Ability to provide excellent customer service and liaise with the public, contractors, and staff in other service areas.
• Knowledge and ability to use Microsoft Office Suite (i.e., Excel, Powerpoint, Word).

NOTE TO INTERNAL FULL-TIME AND PART-TIME CITY OF TORONTO EMPLOYEES:

City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City’s Internal Job Posting Portal.

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.