Data Analyst Full-time Job

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:

1. Development and consolidation of operational reports used daily to assess operational effectiveness using python and BI tools,
2. Support in preparing forecasts and completing sensitivity analysis to support capital project planning; and,
3. 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.
• Skilled in the use of modern business intelligence (BI) software (Power BI, etc.).
• Skilled in query languages (SQL, MDX, etc.).
• Strong programming skills in languages such as Python, SQL
• Familiarity with libraries and frame works commonly used for data manipulation and analysis including Pandas, NumPy, ArcPy, and Geopandas
• Considerable knowledge of databases including SQL, Oracle, and Postgres as well as their related concepts such as data modelling,
• Ability to use COTS applications GEOTAB, Compuweigh, Hansen Asst Management, EM Pro Case Management, SAP an asset
• Strong analytical, research and organizational skills.
• Ability to develop dashboard analytics and KPIs.
• Skilled in GIS-based tools, specifically ESRI products (ArcGIS Pro) an asset
• Ability to identify business problems through data analysis, scenario modeling and creative thinking.
• Ability to design and build data warehouses and data marts.
• Ability to analyze and synthesize data from multiple data sources and formats.
• Strong business acumen and ability to link departmental strategical goals to metrics.
• Skilled in using all Microsoft Office applications, specifically Excel and Power Point
• Ability to solve problems and identify innovative solutions in clear, concise, and compelling terms in a complex business environment.
• Ability to communicate effectively, foster high standards, and deliver results in a complex environment.
• Excellent verbal, written, and presentation communication skills.
• Excellent interpersonal skills and ability to work well independently and in a team.
• Ability to handle confidential and/or sensitive information with a high degree of discretion and impartiality.
• Ability to work under pressure, manage multiple priorities, and respond to requests in a timely manner.

 

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: August, 2024 

Position End Date: August, 2025 

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

 

Application Close:June 28, 2024

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 worlds 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.