Job Summary

Service Area: Public Services Department: Guelph Transit Work Location: Guelph Transit, 170 Watson Road S Work Mode: Hybrid Job Type and Duration: Permanent, Full Time Vacancy Position Availability: 1 existing vacant position Salary Range: $77,548.02-$96,935.02 per year Affiliation: Non-Union 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 workplace. 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‑percent 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.

Key Duties And 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 And 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 required to attend events and/or meetings. This position is eligible for hybrid and flexible work arrangement options (as per current corporate policy).

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

📌 Data Analyst (Transit) (Courtice)
🏢 City of Guelph
📍 Courtice