City of Vancouver

Computer Programmer/Analyst - GIS Analyst


PayCompetitive
LocationVancouver/Brit
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: 41260

      Requisition ID: 41260


      Organization

      Located on the traditional, ancestral and unceded lands of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) Peoples, Vancouver has a commitment to becoming a City of Reconciliation. Vancouver consistently ranks as one of the world’s most liveable cities and is working towards being the greenest city in the world. Named among Canada's Top 100 Employers, BC's Top Employers, and Canada's Greenest Employers, the City of Vancouver seeks colleagues who can help shape and embody our core commitments to sustainability, reconciliation, equity and outstanding quality of life for all residents.

      Consider joining our committed team of staff and being part of an innovative, inclusive and rewarding workplace.

      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.

      Key Contacts and Reporting Relationships

      The position reports to the Engineering Business Support Analyst and works closely with team members in Solid Waste Branches, frontline employees, and other Engineering staff. Key contacts and relationships include Technology Services, Green Infrastructure, Risk Management, Project Steering Committees, cross-departmental counterparts within the City of Vancouver and external stakeholders including vendors and partners.

      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.

      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

      Application Close: June 7, 2024

      At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve . Indigenous peoples, people of colour, 2SLGBTQ+ persons including all genders and persons with disabilities are encouraged to apply. Accommodations will be provided upon request during the selection process. Learn more about our commitment to diversity and inclusion.

      Before you click Apply now

      Once you start your application you can save your work and leave the applications page, however please remember to submit your profile to the specific job requisition before the posting closing date.

      In addition to uploading your cover letter and resume, part of the application process may include answering application questions related to the preferred requirements of the role which may take approx. 5-10 minutes. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a summary of skills and experience related to the position.

  • About the company

      Vancouver (/vænˈkuːvər/ van-KOO-vər) is a major city in western Canada, located in the Lower Mainland region of British Columbia.

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.