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.

Resumes are being accepted for the temporary position of Data and Analytics Specialist within the Information Technology department. Reporting to the GIS and Data Program Manager, this role is primarily responsible for developing the City’s information management foundation to implement the Enterprise Data and Analytics program, operationalizing analytics, and delivering data-as-a- service following industry standard practices and tools including AI.

Key duties and responsibilities

• Work closely with clients and other resources to effectively communicate, plan, design, and implement solutions for delivering real-time and AI-driven insights.
• Design and build data warehouses and analytics warehouses, for structured and unstructured data.
• Design and build data architectures to leverage data as an organizational asset.
• Design comprehensive data solutions that enable clients to appropriately capture, make sense of and action data.
• Ensure delivered solutions fit within overall project plan and schedule.
• Provide feedback to departments and creates structured documentation, including specifications and weekly status reports.
• Advise departments on configuration and implementation options based on best practices.
• Participate in the business requirements gathering process for customizations.
• Lead/support process automation initiatives, for interfacing data structures and connecting applications.
• Act as a subject matter expert in data management technologies.
• Ensure that all implementation methodology deliverables are complete and on time.
• Perform other tasks related to Data Governance, Master Data Management, Open Data and Database Administration, as required.
• Diagnose and resolve issues related to reporting, analytics, and BI tools and systems, while optimizing their performance as needed.
• Act as project manager for data/analytics projects including generating project status, time, and expense reports as requested.
• Other relevant duties as required.

Qualifications and requirements

• Completion of post-secondary education in computer science, computer programming or closely related field. Candidates with an equivalent combination of education and experience may be considered.
• Extensive experience in the design and construction of Data Integration Architectures, ETL/ELT pipelines, preferably with Informatica and Azure Data Technologies.
• Experience in Utilizing Generative AI to extract information from unstructured data sources, identify trends, patterns and deliver insights.
• Experience in implementing and supporting Data Governance frameworks and overall Information Management for structured and unstructured data.
• Extensive experience with Power BI and/or other data visualization and analytics tools.
• Progressive experience in the design and deployment of Metadata and Master Data systems for domains like Asset, Customer or Location Master.
• Knowledge of data integration architectures.
• Comprehensive Data Lake and Data Warehouse analysis and design experience, with SQL Server/Oracle databases, ESRI GeoDatabase and NoSQL Databases.
• Proficiency in using .NET technologies, JavaScript frameworks and libraries for data collection, visualization and interaction with SharePoint Online.
• Ability to analyze business and technical requirements for data lifecycle management and build full stack web applications.
• Experience working with different SDLC methods including Agile, Scrum, Kanban.
• Excellent interpersonal skills with the ability to communicate effectively with all levels of staff, leadership, consultants and the general public.
• Excellent organizational skills, accuracy and attention to detail.
• Ability to lead projects and team members under limited supervision.
• Excellent time management skills in a dynamic delivery environment.

Hours of work
35 hours per week, Monday to Friday, between the hours of 8:30 a.m and 4:30 p.m. This position is eligible for hybrid and flexible work arrangement options (as per current corporate policy).

Pay/Salary
Non-Union Grade 6: $51.80- $64.78 per hour

How to apply
Qualified applicants are invited to apply using our online application system by September 10, 2025. Please note all applicants must complete the online questionnaire specific to this position at the time they submit their resume and cover letter in order to be considered.

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.

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.