Computer Programmer/Analyst

at  The City of Vancouver

QUALIFICATIONS

Education and Experience:

• Completion of a Computer Systems Technologies two-year diploma course plus sound experience in programming OR an equivalent combination of education, training, and experience
• Minimum 2 years proven experience in software development in a project environment with a focus on data and / or analytic application development
• 2+ years’ experience with SQL including data definition (DDL), manipulation (DML) and control commands
• 2+ years’ experience working with a data engineering or data enablement team.
• 2+ years of experience working with SQL Server 2012 & above
• Experience working with columnar datastores across one or more environments (Azure, AWS, Qlik, SQL Server SSAS Tabular)
• 2+ years of experience in web-based development including using JavaScript, jQuery, and frontend frameworks such as Angular JS, Backbone, or Knockout JS
• 2+ years’ experience with rapid data modeling and iterative data modeling
• 2+ years’ experience with a cloud-based data platform Experience with ELTL, data ingestion, orchestration, transformation, and data asset creation.
• 2+ years’ experience using documentation, testing, troubleshooting, and security tools and techniques
• 2+ years’ experience with problem definition, solution analysis and data integration

Knowledge, Skills and Abilities:

• Thorough working knowledge of database tools and integrated development environment, web development and client server coding languages, and office productivity tools (e.g., Windows, MS Office, Visio, etc.)
• Strong skills in data integration tools such as SSIS, FME, Informatica, Azure products or other vendor cloud solutions.
• Demonstrated knowledge of Kimball data warehousing methodology.
• Demonstrated ability to work under pressure
• 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 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 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: August, 2023
Position End Date: November, 2024
Salary Information: Pay Grade GR-027: $43.82 to $51.78 per hour

The main purpose of this position is the design, development, and maintenance of data pipelines, data models, and related technical products supporting Data Enablement program. Using a variety of tools and technologies, both on-premise and cloud based, the role works as part of a team that is responsible for: (a) design and creation of enterprise consumable data connections for analytic purposes, (b) development of data models to address a number of wide ranging enterprise analytic challenges, (c) design and build-out of an enterprise level analytic ecosystem architecture that supports both central data application creation as well as enabling self-service advanced business analytics, (d) supporting the design and adoption of enterprise data governance and data management and (e) publishing datasets on City’s Open Data Portal. Technologies in use or may be used in the future include Microsoft SQL Server and Oracle databases, SSIS, FME, SSAS, Qlik Sense, Power BI, Excel, SAP Business Warehouse, ESRI ArcGIS Server and Portal, and Azure Data Factory. Technical languages in use or may be used in the future include SQL, C#, Python, PowerShell, JavaScript, and R. Enterprise Analytics is a program within Technology Services. Technology Services is responsible for 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 analytic application development including design, development, testing, implementation, systems analysis, documentation, and training. The incumbent is expected to have experience working in a DevOps or DataOps team and understand how to work collaboratively and interactively in order to deliver business value at a predictable pace.

Specific Duties and Responsibilities

• Recommends, designs, documents, develops, and revises analytic applications (or components thereof) of varying complexity with focus on data engineering tasks including building, monitoring, and maintaining data pipelines
• Supports the monitoring, troubleshooting and enhancement of datasets published on the Open Data portal
• Provides technical assistance where and as required as part of the Enterprise Analytics team to deliver on agreed priorities per sprint
• Plans, documents, and executes analytic application implementation, including rollback strategies, and coordinating activities with other IT teams and clients, following best practices for deployment and communication
• Develops queries, and advises team members on functionality, and instruction to locate and extract data
• Estimates time and cost of research, analysis, and development activities. Reports progress against estimates to management, Program/Project Managers, and project team members as needed
• 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 as they relate to the design, development, and support of analytic application products
• Prepares test data, test scripts and/or test environments, conducts testing (logic, usability, integration, security, and acceptance), debugs programs, and supports user acceptance testing as part of the Enterprise Analytics’ team’s sprints
• Provides training and guidance on the use of developed analytical applications
• Experience with the software development lifecycle, and common models (agile, Kanban, iterative, waterfall, etc.) with familiarity in best software practices including source code control, user story development, value-based prioritization, and testing
• Keeps up-to date with developments in programming techniques, languages, data modeling tools, data integration tools, database technologies and data visualization tools, techniques, and best design practices.
• Other duties/responsibilities, as assigned