Log In
Sign Up
Requisition ID: 36109
Company
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, decolonization, 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 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.
- A minimum of 3 years 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 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 of Vancouver has a COVID-19 Mandatory Vaccination Policy. All external applicants applying to the City of Vancouver are required to be fully vaccinated as a condition of hire and subject to this policy as a condition of ongoing employment. Candidates may only be exempted from this requirement if they request and are approved for an accommodation based on a reason related to a Human Rights Code ground (such as disability). Such a request must be made during, not after, the recruitment process.
Business Unit/Department: Engineering Services (1300)
Affiliation: CUPE 15 Non Pks
Employment Type: Regular Full Time
Position Start Date: January 2023
Salary Information: Pay Grade GR-026: $41.98 to $49.61 per hour
Application Close: November 27, 2022
At the City of Vancouver, we are committed to recruiting a diverse workforce that represents the community we so proudly serve. Indigenous applicants, people of colour, all genders, LGBT2Q+ 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-10mins. Cover letters should express interest and highlight additional information relevant to the position and resumes should include a tailored summary of skills and experience related to the position.
