Job ID:63132Job Category:Information & TechnologyDivision & Section:Transportation Services, Policy Data & Strategic InitiativesWork Location:55 John St, Toronto (hybrid)Job Type & Duration:Full-time, Permanent VacancyHourly Rate:$52.38 - $57.39Shift Information:Monday to Friday, 35 hours per weekAffiliation:L79 Full-timeNumber of Positions Open:1Posting Period:08-Apr-2026 to 27-Apr-2026The 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).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 ResponsibilitiesData Operations ResponsibilitiesDevelops 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 DataConducts 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.CommunicationPrepares 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 QualificationsYour 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 education and experience. A post‑graduate degree would be considered an asset.Considerable experience with databases and data warehousing including organizing, compiling, manipulating and analyzing large datasets.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.Solid 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).Equity, Diversity and InclusionThe 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.#J-18808-Ljbffr

📌 Senior Data Analyst & Integrator (Data Operations) - $52.4 - $57.4 An Hour (Toronto)
🏢 City of Toronto
📍 Toronto