Systems Analyst

OverviewThe City of New Westminster, a central hub in the Metro Vancouver area, delivers a broad spectrum of urban services to over 85,000 residents. The City is known for civic leadership, service delivery, and outstanding employee relations. The IT Services team seeks a highly skilled Systems Analyst/Programmer with strong technical expertise in database, cloud and on‑premise integrations, and enterprise application development and support.Role ResponsibilitiesDevelop and troubleshoot reports using Power BI, SharePoint/Teams, Azure, ArcGIS, Excel, MS SQL, and proprietary vendor tools.Write and optimize SQL queries to support integrations and system functionality.Implement, secure, and upgrade third‑party and in‑house applications as needed.Develop, manage, and troubleshoot system integrations using SQL Server, FME Server, APIs, and other tools.Support cloud‑based and third‑party system migrations.Develop line‑of‑business applications using SharePoint automation, .NET, Azure, and related tools.Investigate and resolve application errors by identifying root causes and implementing solutions.Manage user accounts, security, and system access, including role assignments and permissions.Provide technical support and system administration for Engineering/Development/Fire/Utilities applications.Document and diagram systems, data flows, and integrations.Configure and enhance system functionality for Engineering/Development/Fire/Utilities applications.Perform database administration tasks, including backups, data refreshes, and performance tuning.Monitor and maintain application servers that support the applications.Support handheld device applications, including meter readers, tablets, and mobile phones.Work closely with vendors and stakeholders to meet business and operational needs.Research and implement emerging technologies including AI, automation, and machine learning.Position DetailsHybrid remote/in‑office arrangement. Temporary, full‑time position covering a maternity leave.Minimum Required EducationBachelor’s degree from a recognized, reputable post‑secondary institution in an IT Systems‑related discipline.Minimum Required Experience5+ years of experience in an IT department as a systems analyst.3+ years of MS SQL database programming experience.3+ years of systems integration development and troubleshooting experience.3+ years of application support experience.3+ years of experience working with Windows Server and Azure environments.Other RequirementsMust be a Canadian citizen or a permanent resident.Required to pass and maintain a clear Police Information Check.Desired Skills and ExperienceExpertise in SQL Server administration.Advanced SQL Server programming skills, including query writing, optimization, and integration troubleshooting.Experience developing workflows with tools such as FME Server and MS Power Automate.Experience with utilities department applications and integrations.Experience with advanced scheduling tools.Experience with AI, automation, and machine learning.Systems Analyst experience in a municipal setting.Microsoft Windows Server administration experience.Microsoft SharePoint development and automation experience.Microsoft Azure experience.Product lifecycle and technical ownership experience.Designing, developing, and maintaining application integrations.Independent troubleshooting and resolution of system issues.Strong analytical and problem‑solving skills.Effective communication skills.Ability to manage multiple priorities and work under minimal supervision.Proficiency in enterprise system upgrades and deployments.Hands‑on experience with Power BI, SharePoint/Teams, ArcGIS, Excel, and MS SQL.Capability to troubleshoot system errors, investigate root causes, and resolve issues without sole reliance on external support.Experience in user account and security management, including role‑based access control and application hardening.Familiarity with server administration tasks.Experience with third‑party system integrations and support.Candidate ProfileThis role requires a technically adept candidate who can independently diagnose issues, troubleshoot data problems, manage system integrations, and develop and optimize enterprise application functionality. If you have the necessary technical expertise and a proactive problem‑solving mindset, we encourage you to applySeniority levelMid‑Senior levelEmployment typeTemporaryJob functionInformation TechnologyIndustriesGovernment Administration #J-18808-Ljbffr