Business Intelligence Analyst

REQUEST FOR STATEMENTS OF QUALIFICATIONS

DATE: Aug 28th, 2026
POSITION TITLE: Business Intelligence Analyst

Metro Vancouver is seeking a contract Business Intelligence Analyst to collaborate with the Liquid Waste
Services Business Strategy and Improvement Team. This role involves creating data visualizations by analyzing
large datasets using SQL and Power Query to extract and present valuable insights from multiple systems.
Additionally, the successful candidate will also focus on requirements gathering, documentation, and
standards development. This assignment could start as early as Sep 28th, 2026, depending on resource
availability. This position is intended to support project-specific initiatives, with assignments offered as
required based on project demand and resource requirements. This position requires participation in a hybrid
work environment, combining remote work with regular in-office attendance.

The terms of this contract will be as follows:

" The initial term of the contract is one year, subject to budget approval and project work availability,
with the option to extend or terminate the contract as required. The position is expected to require
approximately 600 hours of work annually, although actual hours may vary depending on project
requirements and business needs.

The Business Intelligence Analyst will work in collaboration with our Business Strategy and Improvement
Team and will focus on:

" Translating business requirements into technical specifications
" Data profiling
" Source data analysis with SQL or applicable tools
" Business Analysis
" Designing and developing the data analytics (data warehouse, data lake ODS, data modelling, Power
BI security, Power BI workspace) reusable framework
" Designing data models based on technical specifications
" Exploring advanced Power BI features for analytics, including customized solutions such as Dataflows
and Datamarts
" Designing and building data pipelines and ETL packages including:
o M Query
o Dax Language
o Power Query
o Dashboards and reports with Power BI Desktop
o Troubleshoot day-to-day data warehouse issues

The position requires the following technical qualifications:

" Design, build, and deploy BI solutions (e.g., reporting tools, dashboards)
" Maintain and improve existing BI systems
" Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle).
" Experience with on-premise data warehouse reusable framework design and implementation
" Experience with data modelling, analysis, and visualization
" Work with relational and non-relational databases to extract, transform, and load (ETL) data
" Experience with building data pipelines and ETL processes
" Extensive development experience with technologies including SQL Server, REST APIs, OLAP cubes,
and BI analytics tools.
" Extensive analytic development experience with Power BI and preferably Microsoft Power Platform.
" Advanced Power BI Service configuration experience, including Power BI Dataflows and Datamarts.
" Experience in Power BI report development, reports automation with data source refresh
configurations
" Experience with analyzing data source systems to identify data transformation needs
" Thorough knowledge of software development methods, practices and procedures
" Ability to prepare technical design and write technical specifications
" Experience using Azure DevOps to manage projects is preferred
" Experience with programming languages such as Python or R is a plus
" Experience with Microsoft Fabric for data integration, data warehousing, analytics, semantic
modeling, and enterprise reporting solutions is considered a strong asset

In addition, this position requires the ability to:

" Establish and maintain effective working relationships with a variety of internal contacts
" Provide advice and assistance on matters related to the work
" Ability to document, analyze, and assess a variety of information; identify priorities and resources; and
propose alternative business processes.
" Demonstrated experience reviewing, streamlining and standardizing technical and operational
documentation.
" Ability to develop practical standards that promote consistency while remaining easy for teams to
maintain.
" Ability to assist in the development of standards and perform other administrative tasks related to
assigned work
" Ability to communicate effectively orally and in writing and to present proposals in non-technical
language
" Perform assigned duties with minimal supervision, although direction will be given.
" Maintain confidentiality