Business Intelligence Analyst

TEEMA; Burnaby; On-site; CAD 83,000 - 117,000; Full time

Job summary

TEEMA in Burnaby, BC seeks a Business Intelligence Analyst to translate business needs into SQL-based specifications, profile data, and design scalable BI solutions. You will work on data warehouses, data lakes, and Power BI security within collaborative cross-functional teams.

Responsibilities include building data pipelines and ETL processes, developing dashboards, and maintaining BI systems while leveraging Azure DevOps and Python/R to extend analytics capabilities.

Qualifications

• Strong SQL skills with relational databases (SQL Server, Oracle).
• Experience designing on-premise data warehouse reusable frameworks.
• Data modelling, analysis, and visualization capabilities.
• ETL experience with relational and non-relational data sources.
• Experience building data pipelines and ETL processes.
• Power BI plus Microsoft Power Platform expertise.
• Power BI Dataflows/Datamarts and reporting automation experience.
• Azure DevOps project management is preferred.
• Python or R programming experience is a plus.
• Familiarity with Microsoft Fabric for data integration and analytics.

Responsibilities

• Translate business requirements into technical specifications.
• Profile data and perform source data analysis with SQL.
• Design and develop data analytics infrastructure (data warehouse, data lake, ODS).
• Build BI solutions and dashboards with Power BI Desktop.
• Ensure security and governance in Power BI workspaces.
• Design data models based on technical specs.
• Develop data pipelines and ETL packages (M Query, DAX, Power Query).
• Explore advanced Power BI features, Dataflows, and Datamarts.
• Troubleshoot data warehouse issues and maintain BI systems.
• Collaborate with Strategy and Improvement teams.

Skills

SQL

Power BI

Data Warehousing

Data Modeling

ETL

Azure DevOps

Python or R

REST APIs

OLAP Cubes

Datamarts

Tools

SQL Server

Oracle

Power BI Desktop

Power BI Service

Datamarts

Microsoft Fabric

Job description

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