Data and Operations Specialist - Engineering Data Specialist (GIS)
Requisition ID: 44296
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 and environmentally sustainable cities. 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 engaging workplace. Working at the City of Vancouver and within the public service can be a rewarding career where you play a key role in ensuring impartial and equitable access to services, upholding ethical governance, and addressing the needs of citizens with integrity and dedication.
Main Purpose and Function
The Streets Asset Management team, in the Streets Design Branch, stewards the City’s streets and sidewalks and oversees their rehabilitation. Reporting to the Asset Management Engineer, the Data Specialist serves a critical role in helping track and analyse our street and sidewalk assets, to ensure we are good stewards of the City’s infrastructure and maintain a street network that supports mobility, accessibility, and a vibrant community.
The Data Specialist is responsible for providing technical oversight of data collection programs for street and sidewalk assets and ensuring that data is maintained in accordance with best practices. This position performs highly complex data analyses using large asset management data sets and produces data visualizations using modern business intelligence (BI) tools. This role requires advanced skills in GIS and database management.
The Data Specialist will support asset management programs for streets and structures in accordance with best-practices including: analysis of large data sets related to pavement, sidewalks and structures, analysis of capital and operating costs for various asset types, and review of consultant and vendor studies related to asset management.
Specific Duties and Responsibilities
- Manages the ongoing operation and maintenance of data infrastructure to meet the data analytics and reporting needs of the Streets Design Branch.
- Oversees the development of data collection programs related to the Branch’s asset management programs.
- Supports the Branch’s capital planning work by analysing street asset data, assessing trends and gaps in asset condition, and presenting findings to guide the effective investment of multimillion dollar capital budgets.
- Designs and implements sustainable and repeatable data management approaches involving cloud, on-premise, and big data datasets and technologies.
- Develops and maintains large asset management data sets from multiple sources (internal, equipment, service providers, outside agencies, etc.)
- Develops data visualizations using modern BI tools and/or GIS software.
- Designs, develops, and presents metrics and reports to senior management.
- Recommends solutions and alternatives related to the accessibility, interaction, and presentation of data.
- Directs and reviews the data collection work of manual data collection efforts.
- Prepare annual national benchmarking data and appropriate analytics to identify and address gaps in service delivery or performance.
- Other duties/responsibilities as assigned.
Qualifications
Education and Experience:
- Completion of a diploma or certificate from a recognized post-secondary institution in Data Analytics, Business Intelligence, Geographic Information Systems, Geography, Planning, Engineering, or a related discipline or an equivalent combination of education and experience applicable to the department.
- Sound experience in data analysis; experience in a public sector or large multi-stakeholder organization an asset
- Experience supporting business process changes.
Knowledge, Skills and Abilities:
- Skilled in the use of ArcGIS and MS Excel
- Knowledge of data management best practices.
- Ability to analyze and synthesize data from multiple data sources and formats.
- Ability to work with modern business intelligence (BI) software (Tableau or Qlik, PowerBI, etc.)
- Ability to work with query languages (SQL, MDX, etc.)
- Ability to design and build data warehouses and data marts.
- Working knowledge of cloud and on-premise warehouses and query systems.
- Ability to communicate effectively, foster high standards, and deliver results in a fast-paced, performance-focused environment.
- Strong sense of accountability.
- Ability to work under pressure, manage multiple priorities, and respond to requests in a timely manner.
- Ability to establish and maintain effective working relationships with a variety of internal and external contacts and team members to provide advice, information, and assistance.
- Experience visualizing data and creating presentation material; experience working with asset management data an asset
- Experience in SQL database and database design schema would be an asset.
- Knowledge of Justice, Equity, Decolonization, Diversity, & Inclusion practices and how they inform data collection & analysis would be an asset.
Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work a hybrid work 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: October, 2025
Position End Date: December, 2026
Salary Information: Pay Grade GR-026: $45.62 to $53.91 per hour
Application Close: September 1, 2025
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.
Job Segment:
Cloud, Database, GIS, Operations Manager, Business Intelligence, Technology, Operations