Computer Programmer/Analyst - GIS Analyst

at  The City of Vancouver

MINIMUM QUALIFICATION REQUIREMENTS

Education and Experience:

• Completion of a post-secondary diploma in Information Technology or Business Analytics with a specialization in Data Science or Geographic Information Systems plus considerable experience in programming, data analysis, and business process and performance improvement using a structured methodology or an equivalent combination of applicable education and experience.
• Experience in supporting and developing GIS strategies to support business decisions
• Experience working with and advising operational leadership.

Knowledge, Skills and Abilities:

• Thorough knowledge of building or reviewing highly complex spatial-temporal data management systems, including data capture, management, business intelligence, and data mining, designing reports and dashboards for effective decision making, initiating business process improvements, and supporting change initiatives and strategic decisions for a complex operations-focused organization
• Considerable knowledge of research techniques, statistics, data systems, performance metrics, finance, and business concepts.
• Knowledge of SQL (SQL Server, Oracle) and Data Science languages (Python, or R)
• Knowledge of building data visualizations and dashboards (PowerBI)
• Advanced skills in ESRI GIS-based tools (ArcGIS Pro, Spatial Analyst, Operational Dashboards, StoryMaps, FieldMaps, and Survey123)
• Ability to support and facilitate complex multi-stakeholder initiatives and engagements
• Ability to identify issues and generate resolution options in clear, concise, and compelling terms in a complex business environment.
• Ability to strategically answer complex business problems through data analysis, scenario modeling, data visualizations, and creative thinking
• Ability to analyze and synthesize data from multiple data sources and formats.
• Ability to identifying performance measures to inform strategic decisions
• Ability to display information as map-based visuals for operational deployment
• Strong business understanding and ability to link root-cause issues to data insights; ability to “connect the dots” and make strategic recommendations within a complex organization
• Ability to make sound recommendations and judgments in a wide variety of complex situations with no established precedents
• Ability to simultaneously manage multiple organizational priorities, projects, and deadlines
• Excellent communication and presentations skills with the ability to deliver complex concepts to both technical and non-technical audiences
• Excellent verbal and written communication skills.
• Ability to maintain professionalism, objectivity, confidentiality, tact, and diplomacy
• Strong analytical, research, and organizational skills
• Strong business understanding and ability to link departmental strategic goals to metrics.
• Excellent interpersonal skills and ability to work well independently and in a team.
• Ability to handle confidential and sensitive information with a high degree of discretion and impartiality.
• Ability to meet transportation needs of the department.

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.
Business Unit/Department: Engineering Services (1300)
Affiliation: CUPE 15 Non Pks
Employment Type: Temporary Full Time
Position Start Date: July 2024
Position End Date: 08/08/2025
Salary Information: Pay Grade GR-027: $47.62 to $56.27 per hour

MAIN PURPOSE AND FUNCTION

The GIS Analyst utilizes data analytics to assess and communicate opportunities and progress towards Solid Waste Utility and Street Cleaning business goals. The position supports continuous service delivery and policy setting improvements using systems solutions; leverages geospatial analysis, business analytics, and reviews of associated business performance metrics to drive strategic, operational, and financial decisions; and supports service transformation to improve Divisional performance and value. This role works closely with GIS, Technology Services, and Engineering business leaders to leverage business intelligence to simplify and provide value-added analysis and metrics reporting. The GIS Analyst works with confidential and sensitive data, identifies workforce trends, informs strategic direction regarding operational improvements, and identifies root-cause business data issues.

The GIS Analyst’s immediate focus includes:

• Vehicle route optimization products and supporting GIS data modeling.
• Preparing recommendations on data enablement opportunities to capture sensitive street cleaning data (including abandoned items)
• Integrating geospatial and non-spatial datasets from operations and legacy sources to display current state information as actionable intelligence for the Solid Waste Management Division, with particular focus on waste collection and disposal operational optimization and waste reduction.

SPECIFIC DUTIES/RESPONSIBILITIES

• Provides business decision support to Solid Waste Branches which includes budgeting and reporting on key performance indicators, GIS modeling,business analysis, and business case development
• Consults, leads, advises, and develops benefits realization plans for critical programs and tracking actual performance against business plans (benefits realization)
• Creates scripts and models (python, R, SQL, model builder) to automate analytics processes and graphic outputs to increase efficiency and/or address operational needs
• Contributes to the development and implementation of enterprise data strategy, including overseeing standards for performance metrics and analysis
• Analyzes large datasets for enterprise systems and developing performance metrics as well as presenting results
• Consults with division business units in analyzing existing and proposed geographic information systems tools – including proposing data collection methods, modeling, procedure changes, and the development of requirements and conceptual solution designs
• Provides technical assistance and expertise for the collection, storage, and use of spatial data across the division
• Researches, develops, benchmarks and establishes best practices for data enablement (including spatial and non-spatial data) to continue moving the City’s Solid Waste Utility and street cleaning operations towards its business goals.
• Consults business units on GIS-based products to compile, analyze, forecast, and prepare summary reports and data visualizations, such as graphs and maps, tables, and dashboards.
• Integrates and combines data from multiple city sources (including Cart Asset Management System (CAMS), Hansen Asset Management System, timesheets, Mobile Data Collection apps) to run complex analytics and spatial analytics for business groups to gain insight into operations and/or inform financial decisions.
• Plans mobile data collection strategies and workflows, including the implementation, rollout, and training to frontline staff (typically using Survey123, Field Maps and other GIS related programs) for different business groups and projects
• Supports and collaborates with operations staff on waste collection, street cleaning and solid waste operations route optimization utilizing various data sources, analysis methodologies, and software (including ESRI GIS and RouteSmart)
• Researches new software or potential applications for projects requiring the use of geographic information technology, and makes recommendations on best use/practice in the division.
• Creates documentation outlining technical solutions
• Designs develops, presents business insights, and identifies business opportunities through advanced data analytics to senior management.
• Recommends solutions and alternatives related to accessibility, interaction, and presentation of data.
• Other duties/responsibilities as assigned.