We are looking for a technically strong Systems Analyst to support a suite of municipal applications used across Engineering, Development, Fire Services, and Utilities. This role blends system support, data work, integrations, and reporting. You’ll work with platforms such as our advanced metering infrastructure (AMI), scheduling and staffing tools, and various workflow systems, helping ensure they run smoothly and deliver accurate, reliable information.
This position is ideal for someone who enjoys digging into data issues, building integrations, creating useful reports, and working closely with both internal teams and vendors.
What You’ll Do
- Provide day-to-day support for departmental systems, including AMI, scheduling, and development-related tools.
- Create and maintain reports and dashboards using SQL, Power BI, SharePoint/Teams, ArcGIS, Excel, and vendor platforms.
- Write, review, and tune SQL queries to improve performance, accuracy, and data flow reliability.
- Build and troubleshoot integrations using SQL Server, APIs, FME Server, and other technologies.
- Assist with application upgrades, configuration changes, migrations, and security updates.
- Track down system issues by following data through various applications and integrations, identifying root causes, and coordinating solutions.
- Administer user roles, permissions, and access controls.
- Document system configurations, integrations, data structures, and workflows.
- Perform routine database tasks, including maintenance and basic tuning.
- Monitor and support application servers and related infrastructure.
- Provide support for mobile and field-based tools, including tablets and meter-reading devices.
- Work with internal teams and external vendors to ensure systems meet operational needs and remain reliable.
- Explore new technologies—automation, AI, and machine learning—to identify opportunities for improvement.
Minimum Requirements
- 5+ years of experience working as a Systems Analyst or in a similar IT role.
- 3+ years of hands-on MS SQL programming experience.
- 3+ years developing or supporting system integrations.
- 3+ years of experience providing application support.
- Skilled with Windows Server and Azure environments.
- Canadian citizenship or permanent residency.
- Able to obtain and maintain a clear Police Information Check.
Assets
- Experience in municipal or utilities settings, particularly with AMI or departmental workflows.
- Knowledge of Azure, SharePoint, Power Automate, ArcGIS, or workflow automation tools.
- Familiarity with scheduling tools, FME Server, or advanced automation platforms.
- Strong troubleshooting ability, especially in vendor-supported environments.
- Experience supporting mobile or field-based technologies.