Business Analyst (1 vacancy)

City-of-Woodstoc; Woodstock; On-site; CAD 87,000 - 98,000; Full time

Benefits offered by this job

OMERS pension plan

Training opportunities

Competitive wages

Job summary

The City of Woodstock is seeking a Business Analyst to manage the Public Works work order system and related applications. You will document requirements, map workflows, and support maintenance, asset management, scheduling, routing, and service delivery activities.

You will configure modules, ensure data integrity, and develop reports, dashboards, and KPIs to support decision-making and county reporting. A diploma in GIS/IT or related field and strong Excel/SQL skills are required.

Qualifications

• Diploma in GIS, IT or related field (essential).
• Minimum 3 years of experience in business analysis, systems administration, or GIS.
• Knowledge of work/asset management and operational processes.
• Familiarity with GIS software (ArcGIS).
• Familiarity with SQL and databases.
• APIs and system integrations experience.
• Advanced Excel skills.
• Strong communication and organizational skills.
• Ontario Class G driver’s licence required.

Responsibilities

• Administer and improve the Public Works work order system and related apps.
• Configure modules, tasks, maintenance plans, and access for the Cartegraph system.
• Coordinate with IT for integrations with GIS, weather services, and financial apps.
• Develop operational reports, dashboards, and KPIs for management.

Skills

Excel

Analytical

Communication

SQL

GIS knowledge

Data analysis

Project planning

Education

Diploma in GIS/IT/Business

Tools

Cartegraph

Geotab

Burnside patrol software

Power BI

ArcGIS

Job description

2026-72

BUSINESS ANALYST (1 vacancy)

Reporting to: Manager of Fleet & Business Support

Department: Public Works

Classification: PERMANENT Full Time; Unionized

Salary Range: $42.05 - $47.24/hour as per Schedule “A”

Hours of Work: As per CA.

Starting Date: As soon as possible

Application Deadline: No later than 4:00 p.m. October 9, 2026

Why City of Woodstock?

Known as the Friendly-City, Woodstock is located in the heart of Oxford County and blends big city conveniences with a small-town feel. With a growing population of over 50,000 welcoming citizens, Woodstock residents place high value on our small-town atmosphere, while enjoying urban amenities. The city is a great place to call home with amazing parks and trails, fantastic amenities as well as wonderful arts and cultural facilities. At the crossroads of highways 401 and 403, Woodstock has a thriving manufacturing sector and opportunities in agriculture, education and healthcare and convenient access to communities across Southwestern Ontario. Visitors can enjoy the city’s many festivals and delight in the many local shops and restaurants in Downtown Woodstock.

When you work for the City, you get to be part of an incredible team of dedicated people with a range of skills and experiences to share. Our team works together to help build a strong, connected community where people have access to the services they need, while enjoying a relaxed lifestyle. Other great benefits to working at the City of Woodstock:

• Join a growing and dynamic organization offering rewarding careers,
• Competitive Wages,
• Option to join a Defined Benefit Pension Plan (OMERS) where employee contributions are matched by the City,
• Training opportunities to support you in this role,
• And a great working environment for individuals committed to making a difference, just to name a few.

Duties and Responsibilities:

1. The Business Analyst is responsible for the administration, configuration, and continuous improvement of the Public Works work order management system and related operational applications. The position works with Public Works divisions and other stakeholders to document business requirements, map processes, and develop system workflows that support maintenance, asset management, scheduling, routing, preventive maintenance, and service delivery activities.
2. Key responsibilities include developing and maintaining work order system modules; configuring tasks, schedules, resource requirements, preventive maintenance plans, due dates, meter points, and user access; and supporting the implementation and ongoing operation of the County Cartegraph work order management system. The Business Analyst coordinates with Information Technology and other system partners to support account creation, permissions, testing, application updates, and integrations with systems such as GIS, weather services, service requests, financial applications, fleet systems, and mobile technologies.
3. The position maintains the quality, integrity, and consistency of work order and asset-related data. This includes reviewing work order records for completeness and adherence to approved processes, identifying data quality issues, providing feedback to supervisors and management, and developing standard operating procedures for system use, data entry, workflow management, and reporting.
4. The Business Analyst develops and maintains operational reports, dashboards, performance measures, and key performance indicators to support management decision-making, service planning, compliance monitoring, and County reporting requirements. The position gathers and interprets operational data, trends, and statistics; analyzes the impact of proposed operational or workflow changes; and provides recommendations related to service delivery, efficiency, budget impacts, risks, and process improvements.
5. The position provides functional and technical support to supervisors, Assistant Supervisors, and other users of the work order management system. This includes training users to create, assign, plan, schedule, monitor, update, and close work orders; schedule people, equipment, and other resources; track task completion; and use system information to manage operational activities. The Business Analyst conducts user acceptance testing for new modules, enhancements, integrations, and related applications, and coordinates required modifications.
6. The role may provide functional direction and training to staff, temporary employees, or contractors supporting data collection and data entry. The position also supports the setup, deployment, and troubleshooting of mobile devices used for field operations and monitors assigned modules within Burnside patrol software and other related applications.
7. The Business Analyst researches emerging technologies, business practices, and operational tools; participates in reviews of policies and processes; and prepares reports, briefing materials, presentations, and recommendations for senior management, Council, County partners, and other stakeholders. The position maintains effective working relationships with City departments, County GIS staff, external agencies, vendors, and the public, and performs other related duties as assigned.
8. Other related duties as assigned.

Qualifications:

Essential

• Diploma in Geographic Information Systems (GIS), Business, Information Technology, or a related field from a recognized post-secondary institution.
• Minimum three (3) years of progressively responsible experience in business analysis, systems administration, work order management, asset management, GIS, data analysis, or a related area.
• Knowledge of work order management, maintenance management, asset management, and operational business processes.
• Knowledge of GIS software, including ESRI ArcGIS products.
• Familiarity with SQL and/or other database technologies.
• Experience with application programming interfaces (APIs), system integrations, GPS/GIS applications, and data synchronization between business systems.
• Advanced proficiency with Microsoft Office, particularly Excel.
• Strong analytical, research, project planning, problem-solving, organizational, and time-management skills.
• Demonstrated commitment to data integrity, quality assurance, confidentiality, and appropriate information management practices.
• Excellent written and verbal communication skills, with the ability to explain technical concepts and operational information to a range of users and stakeholders.
• Valid Ontario Class G driver’s licence.

Preferred

• Experience in a municipal, government, public-sector, infrastructure, fleet, or operational service-delivery environment is preferred.
• Familiarity with work management, fleet, telematics, fuel management, timekeeping, and related systems, including Cartegraph, MESH, OnTrack Hours of Service, Geotab, GIR Fuel Management, Eptura Fleet Asset Software, and Burnside patrol software, is an asset.
• Knowledge of Power BI dashboard development and Data Analysis Expressions (DAX) is an asset.

Working Conditions:

• Work is performed primarily in a municipal office environment using computer systems, databases, mobile devices, and related technology.
• Regular interaction with operational staff, supervisors, managers, City departments, County representatives, vendors, external agencies, and members of the public.
• Work is subject to frequent interruptions, changing priorities, and competing deadlines.
• Occasional attendance at operational facilities, worksites, field locations, or meetings may be required, including occasional work outdoors in varying weather conditions.
• Regular hours of work are in accordance with the applicable collective agreement and operational requirements. Occasional overtime, evening meetings, or schedule flexibility may be required.

The City of Woodstockis committed to diversity andinclusivityin employment and welcomes applications from qualified individuals of diverse backgrounds. We embrace equity, diversity, justice, inclusion and belonging and we’re committed to building a team that represents many backgrounds, perspectives and skills, representative of the communities we serve. The more inclusive we are, the better our work and workplace will be. We are committed to creating a workplace where people experience meaningful work, a sense of hope and optimism, an environment of trust, and inspired results.

Please note:

Immediate family member, as per City of Woodstock Nepotism Policy, HR-015, shall not be employed in the City of Woodstock in any capacity under the following circumstances, but not limited to wherein the family member is in a supervisory or management capacity or responsible for the work of the individual or the department. A conflict of interest must be declared to the Director of Human Resources as outlined in the City of Woodstock Nepotism Policy, HR-015 as soon as it has been identified.

In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, the City of Woodstock will provide accommodations throughout the recruitment, selection and/or assessment process to applicants with disabilities. If selected to participate in the recruitment, selection and/or assessment process, please inform the City’s Human Resources staff of the nature of any accommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation by contacting [e-mail]. In accordance with the Municipal Freedom of Information & Protection of Personal Privacy Act, personal information collected will only be used for candidate selection. Human Resources will work together with the hiring committee to arrange reasonable and appropriate accommodation for the selection process which will enable you to be assessed in a fair and equitable manner.

Satisfactory passing of a criminal record check (or Vulnerable Sector Check) and reference checks as well as proof of qualifications will be required of any successful candidate(s) for this position.

We thank all candidates who apply but advise that only those selected for an interview will be contacted.

No artificial intelligence tools are used to screen, assess, or select applicants for this position. Artificial intelligence tools may be used to help recruiters identify potential candidates on external platforms. All hiring decisions are made by human reviewers.