Data Analyst (Transit)

Job Summary

Service Area: Public ServicesDepartment: Guelph TransitWork Location: Guelph Transit, 170 Watson Road SWork Mode: HybridJob Type and Duration: Permanent, Full Time VacancyPosition Availability: 1 existing vacant position

Salary Range

$77,548.02-$96,935.02 per yearAffiliation: Non-UnionPosting Period: July 17, 2026 to August 4, 2026 11:59 p.m.

When you join the City of Guelph, you join a team of over 2000 employees who deliver services the community relies on every day. Together, we are bringing to life Guelph’s vision of an inclusive, connected, and prosperous city where we look after each other and our environment. As a single tier municipality, we offer a variety of occupations and career specialities within our organization.

Guided by the goals and objectives of the Future Guelph: Strategic Plan and committed to the Corporate Values of integrity, service, inclusion, wellness and learning, the candidate will aid in the achievement of the Community Vision for an inclusive, connected, prosperous city.

What We Offer

We offer competitive wages and comprehensive benefits to meet the needs of our diverse employees.

Many of our positions offer: Paid vacation days, increasing with years of service Paid personal days; Hybrid and flexible work arrangements; Defined benefit pension plan with OMERS, including 100-per-cent employer matching; Extended health and dental benefits, including Health Care Spending Account; Employee and Family Assistance Program; Parental leave top up program; Learning and development opportunities including tuition assistance Employee recognition programs.

Position Overview

Resumes are being accepted for the position of Data Analyst (Transit). Reporting to the Manager of Business Services, the successful candidate will aid departments in utilizing transit data to make business decisions, including the creation of custom reports from PowerBI databases, and simple data cleansing.

Guided by the goals and objectives of the City’s Strategic Plan and committed to the Corporate Values of integrity, service, inclusion, wellness and learning, the candidate will aid in the achievement of the Vision for an inclusive, connected and prosperous city.

Key Duties

Responsibilities

• Maintain, develop, and enhance transit performance dashboards and reports.
• Extract, transform, analyze, and integrate data from multiple transit and enterprise systems, including scheduling, fare, operational, ERP, AVL, APC, and GIS platforms.
• Deliver ad hoc analysis and reporting to support operational monitoring, strategic planning, and departmental decision-making.
• Gather business requirements and translate them into sustainable reporting and analytical solutions.
• Develop, test, implement, and support data solutions based on business and functional requirements.
• Collaborate with business units and technical staff to identify data needs, troubleshoot issues, and support data assets.
• Support software updates and deployments in accordance with change management procedures.
• Keep current with emerging technologies
• Perform other related duties as assigned

Qualifications

Requirements

• Considerable experience related to the duties above, normally acquired through a diploma or degree in Data Analytics, Computer Science, Information Systems, or a related field.
• An equivalent combination of education and experience may be considered.
• Considerable experience in medium- to large-sized corporate environments working with enterprise data warehouses, business intelligence tools, and complex SQL for data extraction, transformation, and analysis.
• Advanced proficiency in Power BI, including dashboard development, data modeling, and report publishing.
• Experience integrating data from multiple enterprise systems, such as scheduling, fare, asset management, ERP, and GIS platforms.
• Experience writing scripts to automate data retrieval.
• Strong analytical, problem-solving, and decision-making skills.
• Strong verbal and written communication skills, with the ability to communicate effectively with staff, stakeholders, and the public.
• Ability to work independently and collaboratively in a team environment, while managing multiple priorities.
• Hours of work 35 hours per week, 8:00 AM – 4:00 PM, Monday to Friday.
• Flexibility is a requirement of this position based on departmental needs to attend events and/or meetings.
• This position is eligible for hybrid and flexible work arrangement options (as per current corporate policy).

How To Apply

Click "Apply Now" on the top right hand side of your screen by August 4, 2026. Hiring Process Transparency The City of Guelph is committed to fair and transparent recruitment practices. Candidates who participate in an interview for this position will be notified of the hiring decision within 45 days of their interview. Notifications will be provided in writing, or through technology.

Commitment to Diversity & Accessibility The City of Guelph is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive workplace where employees feel welcome, valued and engaged. Our employment policies strictly prohibit all forms of discrimination on any of the grounds in relevant laws.

All employment practices are solely based on individual merit, qualifications, and organization's needs at the time. In keeping with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, we are committed to working with and providing reasonable accommodation for qualified individuals in our job application procedures.

If you need an accommodation in order to participate in the hiring process, you may contact us to make your needs known in advance. Privacy Notice Personal information collected through the recruitment process will be used solely to determine eligibility for employment. We thank all candidates in advance; however, only those being considered for an interview will be contacted.