Data Analyst

**Requisition ID**:41706

**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 & Function**

The Solid Waste Data Analyst utilizes data analytics to assess and communicate progress towards Solid Waste Utility and Street Cleaning business goals. Support continuous improvement of service delivery and policy setting.

This position is responsible for developing and maintaining reports that provide insights into business operations and support decision-making. The position is responsible for researching, compiling, tracking, analyzing, forecasting, recommending, and maintaining best practices for solid waste data. This role is responsible for assessing and reporting key performance indicators. The Solid Waste Data Analyst is expected to work with confidential and sensitive data, including that to identify work force trends and inform strategic direction regarding operational improvements, capital investments, procurements, and negotiations pertaining to legal agreements.

The immediate focus of the position will include:

- Development and consolidation of operational reports used daily to assess operational effectiveness using python and BI tools,
- Support in preparing forecasts and completing sensitivity analysis to support capital project planning; and,
- Assist Senior Data Systems Analyst in upcoming data management platform implementation.

The position reports to the Operational Technology, Program Lead and works closely with the Senior Data System Analyst. They support Solid Waste Services Branch’s ongoing programs and the planning of new initiatives. The position also interacts with the Director of Solid Waste, Managers of Sanitation Operations as well as Transfer and Landfill Operations including their supervisory and technical staff as required, supporting the Division’s overall business priorities.

**Specific Duties & Responsibilities**
- Develops and maintains operational and strategic metrics related to the City’s Solid Waste Utility and street cleaning operations.
- Prepares reports for senior governments related to regulatory requirements and regional initiatives.
- Supports the development and maintenance of data pipelines to collect, clean, and transform data from various sources including IoT sensors, asset management system(s), weigh scale software, time tracking, SAP, etc.
- Develops data visualizations using BI tools, python and/or GIS software.
- Researches, develops, implements, and maintains best practices for reporting and data management. Collates, reconciles, investigates, and resolves data discrepancies/anomalies/gaps; analyzes, charts, and interprets findings to support business decisions.
- Supports the development and maintenance of data quality monitoring programs to ensure accuracy, validity, and timeliness of data. Reconciles and corrects data and processes as needed.
- Establish and maintains good working relationships with key internal staff from operational branches, other departments, and external partners to ensure validity of performance metrics, align data entry practices with metric calculations and support meaningful interpretation
- Other duties/responsibilities as assigned.

**Qualifications**

Education and Experience:

- Completion of a certificate, diploma, or post-secondary degree in data, mathematics, statistical analysis, or information technology or a related discipline; or equivalent education and experience
- Considerable experience in data analysis and business process and performance improvement using structured methodology, or an equivalent combination of applicable education and experience.

Knowledge, Skills and Abilities:

- Thorough knowledge of data management best practices.
- Thorough knowledge of data management, business intelligence, data mining, designing dashboards, charts, and other forms of reporting to support effective decision making for business process improvements and change initiatives for medium to large organizations.
- Sound knowledge of research techniques, statistics, and data systems.
- Working knowledge of cloud, on-premise warehouses, and query systems.
- Ability to identify metrics as well as utilize performance measures, data management processes, and data tools to inform strategic decisions.