Computer Programmer/Analyst

at  The City of Vancouver

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
• Minimum 2 years proven experience in software development in a project environment for a range of environments and platforms
• Minimum 2 years of experience in modern application integrations that make use of Logic Apps and other Azure-based event-driven technologies
• Thorough knowledge of programming technologies: .NET Core, Python, React, JavaScript
• 2+ years developing in .NET (4.7+) environment, Web API, RESTful API, MVC, Web Services
• 2+ years developing in low-code development platforms (OutSystems, ServiceNow, Power Platform)
• 2+ years of experience working with SQL Server, Oracle PL/SQL, ADO.NET, Entity Framework, and database reporting and integration frameworks (e.g. SSRS, SSIS)
• 1+ years with deployment techniques, CI/CD continuous integration / delivery, deployment automation, GIT, DacPac
• 1+ years in writing Unit Tests, Functional tests, and test automation (e.g. Selenium)
• 1+ years of experience with API Management and Integration Platforms (API design, gateways, analytics)
• Experience with application design/development/deployment, user interface design, data integration, data extraction, data analysis, reporting, and database design
• Experience using documentation, testing, trouble-shooting, and security tools and techniques
• Experience with problem definition, requirements definition, analysis and solution techniques applicable to systems and procedures

Knowledge, Skills and Abilities:

• Thorough working knowledge of office productivity tools (e.g. Windows, MS Office, MS Project, Visio, etc.), web development and client server coding languages, database tools and integrated development environment
• General experience with information technology concepts for networking, and operating systems
• Strong analytical and problem solving skills
• Combination of strong technical and business skills required
• Demonstrated ability to work both independently and as a member of a team
• Excellent oral, written and presentation skills with ability to communicate to all levels of the organization
• Ability to manage projects, multiple priorities and respond to requests in a timely manner
• Ability to establish and maintain effective working relationships both internally and externally with technical and non-technical staff
• Ability to handle business critical and sensitive information
• Demonstrated ability to work under pressure, manage multiple priorities and respond to requests in a timely manner
• Continuous improvement and continuous learning mindset

Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 – 4 days a week from locations that are a daily commutable distance from their work at a City worksite. At this time this position is eligible to be part of the Flexible Work Program.
The City’s COVID-19 vaccination policy is currently suspended and as a result, vaccination against COVID-19 is not required at this time. However, should circumstances change and the City deem it necessary to re-introduce such policy, you may be required to provide proof of vaccination against COVID-19 in order to be eligible to continue performing your duties.
Business Unit/Department: IT, Digital Strategy & 311 (1070)
Affiliation: CUPE 15 Non Pks
Employment Type: Temporary Full Time
Position Start Date: June, 2023
Position End Date: July 1, 2025
Salary Information: Pay Grade GR-027: $43.82 to $51.78 per hour

MAIN PURPOSE AND FUNCTION

The main purpose of this position is the development and support of internally developed and 3rd party applications on a wide range of platforms including desktop, network, client server, mobile, web, 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 incumbent 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 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
• Has experience in the software development lifecycle, and common models (Agile, Kanban, iterative, etc.) with familiarity in best software practices including source code control, requirements gathering and unit testing
• Keeps up to date with developments in programming techniques and languages, operating systems, and database management software
• Provides technical direction to junior technical staff, clients or consultants
• Other duties/responsibilities, as assigned