Data Analyst (Street Operations)

Requisition ID: 41733 

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

This position is responsible for providing technical oversight of Street Operations data collection for street and sidewalk infrastructure maintenance and repair programs and ensuring that data is maintained in accordance with best practices.  This position performs highly complex data analysis using large data sets and produces visualization, reports and summaries related to expenditures, schedules and accomplishments, using modern business intelligence (BI) tools.  

The Data Specialist supports asset maintenance and repair programs for streets, sidewalks, and structures in accordance with best practices including:  analysis of large data sets related to pavement, sidewalks and structures, analysis of capital, operating, repair and maintenance costs for various asset types, and review of asset management data sets to inform maintenance and repair programs. 

Specific Duties and Responsibilities:

• Manages the ongoing operation and maintenance of data and related data infrastructure to meet the data analytics and reporting needs of the Streets Operations Branch.
• Leads, consults, and participates in business process and technology reviews of all Street Operations functions recommending solutions and alternatives related to the accessibility, interaction, and presentation of data.
• Leads the development of Business Intelligence (BI) Reporting platform for Street Operations.
• Designs and implements sustainable and repeatable data management approaches involving cloud, on-premise, and big data datasets and technologies.
• Develops and maintains large data sets pertaining to spending, cut repairs, work accomplishments, 311 citizen complaints, equipment, etc. from multiple City of Vancouver sources including but not limited to SAP, Hansen and SEAM.
• Designs and develops reports, visualizations, and dashboards for tracking KPIs, metrics and service levels using advanced Excel, GIS Software, and modern BI tools for presentation at the branch, divisional, and department level, as well as to external stakeholders.
• Recommends solutions and alternatives related to the accessibility, interaction, and presentation of data.
• Identifies implications and makes recommendations for changes in data processes and procedures that may affect operational areas.
• Collects and analyzes data to complete current state analyses and to optimize solutions.

• Processes data sets for quality assurance and following up for corrective action where required.
• Builds financial models that accurately project the annual cost recovery rates required to balance expenses such as equipment and fleet.
• Collaborates with broad, multi-functional project teams to maintain clarity of objectives and alignment on implementation plans.
• Manage data requests from internal and external stakeholders including other Engineering Services branches, 311, Risk Management, Freedom of Information, and Legal Services. 
• Teaches, mentors and supports administrative staff in the application of best practice approaches to data input and administration to ensure data accuracy and integrity.
• Directs and reviews the data collection work of manual data collection efforts.
• Other duties/responsibilities as assigned.

Qualifications:

Education and Experience:

• Completion of a post-secondary degree from a recognized post-secondary institution in Business Administration,  Business Analytics or  related field of study plus considerable experience in data analysis, business process and/or performance improvement in a public sector or large multi stakeholder organization or an equivalent combination of education, training and experience.

Knowledge, Skills and Abilities:

• Strong knowledge of Microsoft Power BI, Dataflows, Power BI Service and paginated reports.
• Sound knowledge of structured operational business processes.
• Working knowledge of could and on-premise warehouses and query systems.
• Advanced in the use of Microsoft Excel and office suite with excellent keyboarding skills
• Analytical skills, accuracy and attention to detail with a strong sense of accountability.
• Skilled in the use of data systems and statistical data collection.
• Excellent business writing skills.
• Ability to analyze and synthesize data from multiple data sources and formats.
• Ability to work with query languages (SQL, MDX, etc.)
• Ability to design and build data warehouses and data marts.
• Ability to problem solve and provide creative ways to resolve issues.
• Ability to communicate effectively, foster high standards, and deliver results in a fast-paced, performance focussed environment.
• 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 mentoring.
• Ability to demonstrate an organized and local approach to finding solutions to complex situations or problems.

Business Unit/Department: Engineering Services (1300) 

Affiliation: CUPE 15 Non Pks 

Employment Type: Regular Full Time 

Position Start Date: August, 2024 

Salary Information: Pay Grade GR-024: $42.04 to $49.65 per hour

Application Close: July 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.