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.
- Strong 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
- Azure DevOps
- Python or R
- Microsoft Fabric, particularly:
- Data integration
- Data warehousing
- Analytics
- Semantic modelling
- Enterprise reporting
- 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
Similar Jobs
What you need to know about the Los Angeles Tech Scene
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering



