Job Title: Business Intelligence Analyst
Job ID: 90089

Location: Burnaby, British Columbia

What you will be doing:

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:

M Query

Dax Language

Power Query

Dashboards and reports with Power BI Desktop

Troubleshoot day-to-day data warehouse issues

Design, build, and deploy BI solutions (e.g., reporting tools, dashboards)

Maintain and improve existing BI systems

What you must have:

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 Dev Ops 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 robust asset

Salary/Rate: $85.00/ hour

#J-18808-Ljbffr

📌 Business Intelligence Analyst (Burnaby)
🏢 TEEMA
📍 Burnaby