Programmer Analyst II; GIS

Position Summary

The Geospatial workplace at the City is dynamic and continually changing and evolving to handle the City’s business needs. We are seeking a candidate who is open and ready to embrace and adapt to change. This position is responsible for the support, development, implementation, and documentation of geospatial solutions across multiple lines of business. This is an intermediate technical position that, through assignments of medium complexity, contributes to the delivery of new business solutions and to the maintenance, enhancement, and support of existing ones.

This position requires strong problem‑solving skillset to tackle complex GIS programming challenges when designing and implementing GIS solutions. This position reports to the Coordinator Geospatial Technical Services. The position will be working with other employees, so excellent interpersonal skills such as conflict resolution, communication and leadership skills are considered an asset. The person will be required and expected to work independently.

The Programmer Analyst II focuses on the maintenance and support of the City’s geographic information systems (GIS) platform, as well as the administration and support of computer‑aided design (CAD), global positioning systems (GPS) software, and related geospatial tools for the organization. The role requires a solid understanding of GIS concepts, principles, and spatial data management. The nature of the role will rely on creative solutions, so strong problem‑solving skills are a must.

• For programming assignments of medium complexity, this position is responsible for the development of business solutions that meet business area requirements. This will include program design, programming, unit testing, system testing, acceptance testing, and implementation.
• This position will provide analysis services for medium‑sized assignments and projects. It will also be responsible for preparing appropriate documentation.
• Contribute to the support of existing business solutions by maintaining (analyzing and correcting problems), developing, testing, and implementing enhancements to them, and by updating system documentation.
• Develop timelines and budgets for assigned work, monitor timelines and report regularly to the immediate supervisor the progress and status of all assignments.
• Coach and mentor other staff members.
• Demonstrate leadership and initiative in sharing technical expertise with other team members, and contribute to the effectiveness of clients through leadership, guidance and training as required.
• Perform duties in adherence to established standards and procedures.
• Perform related duties as required.

• A university degree in Computer Science or other related discipline or completion of a two (2) year diploma/certificate in Computer Information Systems from a recognized post‑secondary institution combined with two (2) to three (3) years of related progressive experience.
• Two to three years experience that includes program design, programming, unit testing, system testing, acceptance testing, and implementation specifically for geospatial and related technologies (ArcGIS, ArcGIS Online, FME, AutoCAD, QGIS, etc.). The role requires proficiency in programming languages commonly used in GIS development, such as Python and JavaScript.
• Should have working experience with GIS Libraries and Frameworks like ArcGIS API for Python, ArcGIS JavaScript API, Leaflet, Open Layers, and GDAL.
• Knowledge and experience in administering and working with spatial databases like Oracle, PostgreSQL with PostGIS, SQL Server within the ArcGIS Framework with an understanding of spatial queries and how to optimize them. Additional experience with RDBMs (Oracle, SQL Server) and other GIS, GPS, and CAD‑based toolsets would be considered an asset.
• Expertise in developing web mapping applications using technologies such such as HTML, CSS, and JavaScript. It would be beneficial if the applicant has development experience using swagger and micro‑processing.
• Working knowledge and experience with contemporary system design and development tools and techniques.
• Knowledge…