DATA ANALYST & INTEGRATOR

Job ID: 48028

Job Category: Information & Technology

Division & Section: Parks & Recreation (P&R), Policy & Strategic Planning, Research & Analytics

Work Location: Metro Hall, 55 John Street

Job Type & Duration: Full-time, (1) Permanent,  (1) Temporary 12 months vacancy

Hourly Rate: $41.33 - $45.26 (2024 rates)

Shift Information: Monday to Friday, 35 hours per week

Affiliation: L79 Full-Time

Number of Positions Open: 2

Posting Period: 06-May-2025 to 21-May-2025

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. Additionally, in this role you will help grow our team’s data science capabilities and advance data-informed decision making across the division.

If you are a data analytics professional who is interested in using your skills and experience to contribute towards the quality of life of Torontonians, we want to meet you!

To learn more about the Data Analyst and Integrator position with Parks and Recreation, we are hosting a virtual WebEx information session with Jia Lu, Manager, Research & Analytics and Amy Buckland, Senior Data Solutions Integrator, on:

1. May 13, 2025 from 12:30PM – 1:30PM. Registration link: https://toronto.webex.com/weblink/register/r6ccc84749f0d32818a61ebf9e6359097
2. May 14, 2025 from 12:00PM – 1:00PM. Registration link: https://toronto.webex.com/weblink/register/r6a9d609ff882ed75170bb4721fdcf42b

You will have the opportunity to ask questions related to the position, working for the City of Toronto, as well as the City's application process.

Please register to participate in the information sessions as space is limited.

Your name and email are required for registration, but they will remain private during the session.

Major Responsibilities:

Research and Analytics, Data Science:

• 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.
   

Data Visualization and Communication:

• Compiles data/statistical reports based on data analysis including formatting for aesthetics and structure.
• Produces data visualization on a range of different data sources, including structured, unstructured, real-time and geospatial.
• Builds out data visualizations 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.
• 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.
   

Key Qualifications:

Your application must describe your qualifications as they relate to:
 

1. Post-secondary education in Data Analytics/Science, Statistics, GIS/Geomatics, Computer Science, Mathematics, Environmental Sciences, Social Sciences, Economics, Health Sciences or equivalent combination of education and relevant experience.
2. Considerable experience with data visualization (Tableau), ArcGIS, R Shiny, Illustrator and other open-source data visualization tools.
3. Experience with statistical computing, object-oriented programming and database query languages (Python, SQL, R).
4. Experience using statistical techniques (e.g. predictive value, time-series analysis, regression, A/B testing, Bayesian).
5. Experience with metadata management, data lineage tracing and version control (e.g. Git)
    

You must also have:

• Excellent political acuity with consideration of context and timing.
• Ability to create and effectively present information (data storytelling).
• Can 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-oriented, dependable, and flexible individual 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.
• Experience with relational database environments (e.g. Oracle, SQL Server, MySQL, Postgres).
• 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.
• Must be familiar with and comply with the Ontario Occupational Health and Safety Act (OHSA) and its regulations for the safe performance of his/her duties and responsibilities, or capable of obtaining familiarity of same.

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.

Note: The applicant pool from this job posting may be used for similar summer job opportunities in various divisions.

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.