DATA ANALYST & INTEGRATOR
City of Toronto Toronto, Ontario, Canada · CA$93K–CA$102K/yr
Government Administration · 10,001+ employees
About the role
The Data Analyst & Integrator will ingest, clean, analyze, and visualize large datasets to provide actionable insights for strategic decision-making. They will also design dashboards, automate recurring analyses, and maintain key performance indicators while supporting stakeholders across the organization.
What they look for
Requirements
Candidates must possess post-secondary education in a relevant field such as Data Analytics, Computer Science, or Statistics. Significant experience with data visualization tools, statistical computing, and database query languages like Python and SQL is required.
Full description
Job ID: 65433 Job Category: Information & Technology Division & Section: Parks & Recreation, P&R Policy & Strategic Planning Work Location: Initially based at Metro Hall (55 John St) and will relocate to North York Civic Centre (5100 Yonge St) once the new location is operational - Hybrid in accordance with the City's Hybrid Policy Job Type & Duration: Full-time, Permanent Hourly Rate: $44.64 - $48.88 Affiliation: L79 Full-time Number of Positions Open: 1 Posting Period: 17-AUG-2026 to 31-AUG-2026 Shift Information: Monday to Friday, 35 hours per week
Job Summary:
Are you interested in contributing to the quality of life in Toronto by providing decision makers with sound evidence? As part of the Research and Analytics Unit in the Policy and Strategic Planning Branch of P&R, you'll join a team focused on turning data into actionable insights.
You are a data analyst with strong statistical foundations and hands-on experience in preparing and analyzing large datasets in distributed environments. Working closely with stakeholders, you'll ingest, clean, analyze, and visualize data. You'll also design dashboards and queries, automate recurring analyses, and maintain key performance indicators that guide strategic priorities.
Major Responsibilities:
Data Visualization and Communication:
- Compiles data/statistical reports based on data analysis including formatting for audience clarity.
- Produces data visualizations on a range of different data sources, including structured, unstructured, real-time and geospatial.
- Builds out data visualizations and resulting insights to inform decision-making or to contribute towards briefing decks.
- Updates KPI decks on a regular basis to outline major changes, annotates major research projects, and changes to the system that have impact to KPls.
- Tracks and maintains major Key Performance Indicators (KPls) and business impacts.
- Communicates analysis results to internal and external stakeholders.
Stakeholder Support:
- Builds relationships with key business users and decision makers to understand their business analytics needs.
- Develops, fosters and maintains effective working relationships with internal and external stakeholders
- Project management for work assigned, including prioritization, stakeholder communication, timelines and meeting minutes.
- Guides stakeholders to understand the analytics tools and automated dashboards to support decision making.
- Trains team members and other stakeholders on foundational analytics capabilities. Gives presentations at relevant learning networks, meetings and events related to findings and data analytics/science.
Research and Analytics:
- Provides technical expertise using data analysis techniques to City divisions in support of data-driven decision making.
- Uses data science to formulate solutions and/or recommendations (i.e. including utilization of traditional research methods).
- Uses statistical techniques (e.g. A/B testing, summary statistics on central tendency, etc.) to ensure high quality analysis.
- Performs research on best practices related to data analysis and data visualization.
- Contributes to the development of corporate analytical models, dashboards and databases.
- Maintains data and records in accordance with Information Management best practices and guidelines (i.e. alignment of data governance best practices).
- Provides technical support and assists with performing data cleaning, manipulation, analysis and visualization on data to deliver insights and contribute to evidence informed decision making and solutions.
- Connects a variety of business data with location information and analyzes data to gain additional insights.
- Sets up data queries, builds Extract, Transform and Load (ETLs), data pipelines and automates recurring analysis, and builds reusable scripts to speed up future analysis.
- Troubleshoots and takes actions to resolve issues associated to data, interpretation and reporting.
- Ensures data quality, identifies errors and performs data cleaning to ensure accuracy and statistical significance.
- Implements changes to existing data measures based on analysis of historical data.
- Maintains up-to-date knowledge of both current and emerging data analytics and products.
Key Qualifications:
Your application must describe your qualifications as they relate to:
- Post-secondary education in Data Analytics, Statistics, GIS/Geomatics, Computer Science, Mathematics, Environmental Sciences, Social Sciences, Economics, Health Sciences or equivalent combination of education and relevant experience.
- Considerable experience with data visualization software such as Tableau, PowerBI, ArcGIS, R Shiny, Illustrator and other open-source data visualization tools.
- Considerable experience in descriptive (e.g., mean, standard deviation) and predictive analysis (e.g. regression, time-series analysis, clustering, etc.)
- Considerable experience with statistical computing, object-oriented programming and database query languages (Python, SQL, R).
- Considerable experience in business reporting and synthesizing information from operational systems to produce meaningful reports supporting decision-making.
- Considerable experience with databases and data warehousing including organizing, compiling, manipulating and analyzing large datasets.
You must also have:
- Excellent political acuity with consideration of context and timing.
- Ability to create and effectively present information (data storytelling).
- Ability to effectively facilitate discussions with various audiences and collect business requirements.
- Excellent interpersonal skills; with the ability to develop and maintain inter-professional team relationships with multiple stakeholders, including City staff and the public.
- Ability to work and problem-solve independently.
- Detail-orientation, dependability, and flexibility with initiative to handle a complexity of tasks simultaneously.
- Excellent critical thinking, problem solving and conflict resolution skills.
- Excellent time management and organizational skills.
- Ability to travel to various locations within the city, as required.
- Familiarity with cloud-based analytical tools (e.g. AWS).
- Familiarity with version controlled, collaborative data workflows (e.g. git, Jupyter notebooks).
- Understanding of data governance, privacy, and ethical analytics.
- Ability to comply with the Ontario Occupational Health and Safety Act (OHSA) and its regulations for the safe performance of his/her duties and responsibilities.
- Experience with metadata management, data lineage tracing and version control (git).
A Candidate List will be established and remain in effect for three (3) months after the posted opportunities have been filled. This list will be used to fill current and any additional permanent and temporary vacancies in the posted job that become available within the posted or a different location in the Parks and Recreation Division.
Notes
- All employees are invited to apply for this position. Priority consideration will be given to applicants with Local 79 seniority or aggregate service as of the job posting closing and job offer dates.
- Applicants are required to demonstrate in their resume that their qualifications match those specified in the job posting. Additional information submitted after the job posting closing date will not be accepted.
- Assessment may include an interview, written and/or practical test. Location of assessment to be determined.
- If selected for a temporary position, permanent Local 79 employees will retain their permanent status. At the end of the temporary assignment, Local 79 employees will return to their permanent base job classification.
- If selected for a temporary position, temporary and part-time employees will be reassigned to this temporary position.
- Work location reflects what is known at the time of posting.
- An employee's reporting relationship and/or work location may change due to operational reasons and in accordance with their Collective Agreement.
- Information on preparing for City job competitions is available on the Job Opportunities website.
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.
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.
Similar roles
-
Client Data Analyst
JPMorgan Chase & Co. Kuala Lumpur, Kuala Lumpur, Malaysia
-
Senior Healthcare Data Analyst
BerryDunn United States · $80K–$120K/yr
-
Data Analyst, Philanthropic Funds
University Hospitals Shaker Heights, Ohio, United States
-
Informatica Data Analyst
Accenture Kuala Lumpur, Kuala Lumpur, Malaysia
-
Program / Data Analyst
ASR INTERNATIONAL Silverdale, Washington, United States · $87K–$100K/yr
-
Market & Data Analyst (NZ)
CMA CGM Auckland, Auckland, New Zealand