Computer Programmer​/Analyst; GIS Programmer

Requisition : 46857

Organization

Vancouver is consistently ranked as one of the world’s most liveable and environmentally sustainable cities. Recognized among BC’s Top Employers and Canada’s Greenest Employers, the City of Vancouver is seeking colleagues who can help advance our core commitments to exceptional public service, sustainability, equity, and an outstanding quality of life for all residents.

With a strong commitment to being a City of Reconciliation, we invite you to join our dedicated team and become part of an innovative, inclusive, and engaging workplace. A career with the City of Vancouver and within the broader public service, offers meaningful work where you play a key role in ensuring equitable access to services, upholding ethical governance, and supporting the needs of citizens with integrity and dedication.

Main Purpose and Function
The position primarily supports the integration and sustainment of the Urban Forestry Division’s asset management software – an ESRI-based software referred to as UFO (Urban Forest Operations). The position may also be assigned to other projects to support Park Operations throughout the City of Vancouver.

The GIS Programmer develops and supports internally developed and 3rd party applications on a wide range of platforms including GIS, web applications, client server, mobile, cloud and externally hosted environments involving various office productivity tools, programming languages, operating systems, database products, middleware and other technologies.

This is complex analytical and programming work involving all phases of application development including software development, testing and implementation, systems analysis, feasibility analysis, and documentation and training. The position analyzes existing and proposed systems and procedures, designs and develops complex programs or segments of programs to solve problems, and performs related testing, debugging and documentation tasks

Specific Duties/Responsibilities

• Recommends, designs, documents, develops, and revises GIS computer solutions for requirements (and problems) of varying complexity

• Provides technical assistance and coordinates the development and integration of programs

• Plans, documents and executes software implementation, including rollback strategies, and coordinates activities with other IT teams and clients, following best practices for deployment and communication

• Develops queries, and advises team members on functionality, and provides instructions to locate and extract data

• Estimates time and cost of system development activities and reports progress against estimates to management, Program/Project Managers, and project team members

• Prepares and maintains detailed user and operations documentation to ensure service levels can be measured and achieved, and to meet audit requirements for safeguarding software, data and business continuity

• Evaluates the need for, and develops general-purpose routines, utilities and command procedures

• Prepares test data, test scripts and/or test environments, conducts testing (logic, usability, functional, integration, security), debugs programs, and supports user acceptance testing

• Provides training and guidance on the use of computer systems and software

• Provides technical direction to junior technical staff, clients or consultants

• Other duties/responsibilities, as assigned

Minimum Position Requirements

Education and Experience:

• Completion of a Computer Systems Technologies two-year diploma course at a technical institute plus sound experience in programming; OR an equivalent combination of training and experience

Knowledge, Skills and Abilities:

• Thorough knowledge of GIS, ArcGIS Enterprise, ArcGIS Online, GIS Python automation and web application development

• Thorough knowledge of programming technologies: .NET Core, React, Java Script

• Thorough knowledge of .NET (4.7+) environment, Web API, RESTful API, MVC, Web Services

• Thorough knowledge of working with SQL Server, Oracle PL/SQL, , Entity Framework, and database reporting and integration frameworks (e.g. SSRS, SSIS)

• Considerable knowledge of deployment techniques, CI/CD…