Project Description

Business Intelligence Analyst – Metro Vancouver

Metro Vancouver is seeking a Business Intelligence Analyst to support the Liquid Waste Services Business Strategy and Improvement Team. The project focuses on analyzing large datasets from multiple systems and transforming data into meaningful business insights through SQL, Power BI, Power Query, and data modelling.

The resource will be responsible for requirements gathering, data profiling, source-system analysis, technical specifications, BI/EDW framework development, ETL/data pipelines, dashboards, reporting, and documentation/standards development. The role also involves advanced Power BI Service capabilities such as Dataflows, Datamarts, security, workspaces, and automated data refresh. Microsoft Fabric experience is considered a strong asset.

Core technical requirements

- Solid SQL and relational databases — SQL Server, Oracle
- Power BI development and analytics
- Advanced Power BI Service, including:

- Dataflows

- Datamarts

- Workspace/security configuration

- Automated data refresh

- Power Query / M Query

- DAX





- Data modelling and visualization
- Data profiling and source-data analysis
- Data warehouse / EDW architecture and reusable frameworks

- Data lakes / ODS

- ETL/ELT and data pipelines
- Relational and non-relational databases

- REST APIs

- OLAP cubes
- Technical specifications and design documentation

Preferred / asset skills

- Azure DevOps

- Python or R
- Microsoft Fabric, particularly:

- Data integration

- Data warehousing

- Analytics

- Semantic modelling

- Enterprise reporting

Business/soft skills

- Requirements gathering and translating business requirements into technical specifications

- Business analysis

- Documentation and standards development
- Streamlining and standardizing technical/operational documentation
- Ability to communicate technical concepts in non-technical language
- Independent work with minimal supervision
- Ability to analyze information, identify priorities, and recommend alternative business processes

📌 Business Intelligence Analyst (Burnaby)
🏢 Workiy
📍 Burnaby