Systems Analyst II

Main Purpose and Function

The Senior Solid Waste Data Systems Analyst is responsible for leading the design, implementation, governance and continuous improvement of the Solid Waste data platform, data products and business intelligence solutions. The position is responsible for technical and business requirements; design, develop, document, test, deploy and support solutions and products that allow the business to automate processes, build solutions, & analyze data; Work closely with Technology Services to develop and maintain the division’s Databricks-based data warehouse.

Using data engineering, analytics, and business intelligence technologies, the role delivers data solutions that support operational, financial, regulatory, and strategic business needs. The position works collaboratively with operational, technical, and leadership teams to transform data into actionable information and business value.

The work performed will enable Solid Waste to leverage performance metrics to support strategic, operation and financial decisions as well as support service transformation by driving accountability, improving transparency and increasing value for money. It also makes recommendations for changes to systems and processes that may impact financial and operational areas as well as staffing workloads and levels, working conditions, and changes in positions.

Specific Duties and Responsibilities

• Works as part of a project team to develop high quality, robust, maintainable business solutions
• Leads the architecture, development, deployment, and maintenance of the division's Databricks data warehouse, data pipelines, and analytics solutions.
• Provides senior technical application support for a wide range of custom and COTS applications developed using a range of platforms, tools, web frameworks, programming languages, operating systems and databases
• Leads business analysis, solution design, and technical specification development for data and analytics initiatives with complex software components and requirements.
• Leads business analysis to identify requirements, define data needs, and develop scalable data products
• Designs and generates technical specifications for complex software components and applications
• Designs and develops integrations between data platform and business systems using REST/SOAP APIs
• Develops and leads quality assurance and control procedures to ensure accuracy and completeness of business data and outputs.
• Develops analytics strategies, performance measures, forecasts, and decision-support products to inform departmental planning and strategic direction.
• Creates data products using PowerBI or custom development of data products, visualizations, and analysis
• Leads and facilitates testing activities for products including preparation of test data, scripts, environments for unit, integration, and user testing. Debugs and reworks as needed.
• Ensures reliability, performance, security, and availability of production data solutions created by the team
• Stays current with developments in advanced analytics, programming languages, data modeling, integration tools, database technologies, data visualization tools, techniques, and best design practices.
• Applies business analysis, process improvement, service design, and performance measurement methodologies to identify and implement operational improvements.
• Assesses operational data, technology, people, policy, governance, and change-management implications of proposed process changes.
• Responsible for applying the City’s data governance standards and quality controls and acts as a data steward for the division
• Presents findings to departmental leaders and other stakeholders.
• Develops and maintains effective working relationships with stakeholders in business, operational, technical, and leadership groups.
• Develops and maintains user training and documentation.
• Provides day-to-day leadership and guidance to staff, including hiring, assigning responsibilities, evaluating and reporting on performance, coaching, mentoring, training and development.
• Performs other duties/responsibilities as assigned.

Qualifications

Education and Experience:

• Bachelor’s degree or diploma in Computer Science or Information Technology and a minimum of five years of related experience with implementation and maintenance of data warehousing and BI solutions leveraging structured and unstructured data, preferably in a municipal environment, or an equivalent combination of education, training and experience
• Minimum of 3 years of experience with user engagement, requirements gathering and change management. 
• Experience in supporting and developing strategies to support major corporate decisions and identifying performance measures to inform strategic decisions. 
• Experience with data management, business intelligence tools, data mining, designing reports and dashboards to facilitate effective evidence based decision making. 
• Extensive experience in strategically answering complex business problems through data analysis, scenario modeling and creative thinking. 
• Significant experience in supporting and facilitating complex multi-stakeholder initiatives and engagements
• Experience with the creation and presentation of public information (formal/informal reports, other publications) as well as engagement involving a diverse range of stakeholders. 

Knowledge, Skills and Abilities:

• Experience with scripting or programming languages and relevant packages used for analysis, automation and integration, such as Python, DAX, ArcGIS Python API, PowerQuery

• Advanced knowledge of reporting, business intelligence, statistical analysis, and data visualization techniques using tools such as Power BI, SQL, and Python.

• Advanced experience designing, developing, implementing, and supporting enterprise reporting and analytics solutions
• Advanced knowledge and experience with Microsoft Power Platform technologies, including Power BI, Power Apps, and Fabric, and their integration with enterprise data platforms
• Advanced skills and experience in working with Data Warehousing software and performing ETL processes in tools such as Databricks and Informatica
• Strong skills with data modelling and data warehouses.
• Advanced skills in SQL development, query optimization, and database design using platforms such as Microsoft SQL Server, Spark SQL, and Oracle.
• Experience leading data or technology projects through the full project lifecycle
• Experience working with operational stakeholders to translate business requirements into technical solutions.
• Knowledge of mapping and spatial analysis techniques.
• Knowledge of GIS in a municipal environment and understanding of its relationship with other business systems.

• Experience leading or supervising technical staff
• Ability to simultaneously manage multiple organizational priorities, projects, and deadlines.

• Ability to initiate business process improvements, supporting strategic decisions and change initiatives for a large organization. 

• Ability to apply analytical, business and data management assessment skills and methodology to achieve a comprehensive multi-layered understanding of the related analytical and business processes and tools. 

• Ability to strategically answer complex business questions through data analysis, scenario modeling, data visualizations, and creative thinking. 
• Ability to leverage strong analytical, technical and troubleshooting skills to solve complex problems and perform root cause analysis. 
• Working knowledge in project management
• Ability to analyze and synthesize data from multiple data sources and formats.
• Some knowledge of user experience, design and accessibility principles.
• Familiarity with machine learning, predictive analytics, or related emerging technologies.
• Ability to handle business critical and sensitive information.
• Ability to forward think, coupled with the skills of being able to articulate ideas in both written and verbal form. 
• Demonstrated analytical skills and strong organizational abilities.

Business Unit/Department : Engineering Services 

Affiliation: Exempt 

Employment Type: Regular Full-Time  

Position Start Date: January 2027  

Salary Information: Pay Grade RNG-080: $102,960 to $128,691 per annum 

Application Close: November 3, 2026 

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 . 

The City of Vancouver acknowledges that it is situated on the unceded traditional territories of the xʷməθkʷəy̓əm (Musqueam Indian Band), Sḵwx̱wú7mesh Úxwumixw (Squamish Nation), and səlilwətaɬ (Tsleil-Waututh Nation). More about unceded traditional territories

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.