Business Intelligence Analyst

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

Salary/Rate: $85.00/ hour


Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com