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

Salary/Rate: $85.00/ hour

📌 Business Intelligence Analyst (Burnaby)
🏢 TEEMA
📍 Burnaby