Senior BI Analyst

Black & McDonald Limited; Markham; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading construction and engineering firm is seeking a Senior Business Intelligence Analyst in Markham, ON. The role involves designing and optimizing data solutions using Microsoft Fabric and Power BI, along with developing advanced analytics capabilities. Candidates should have over 5 years of experience in data engineering and strong skills in SQL and DAX. A competitive salary and benefits package is offered, alongside an innovative work environment.

Benefits

Competitive salary and benefits package

Opportunity to work with cutting-edge technology

Collaborative and innovative work environment

Professional development and support

Qualifications

• 5+ years of experience in data engineering or related roles.
• Strong expertise in Microsoft Fabric, Power BI, and Azure Synapse Analytics.
• Proficiency in SQL, DAX, and Power Query (M).
• Experience with data warehouse/lakehouse architecture and Azure OneLake.

Responsibilities

• Design and implement scalable data solutions using Microsoft Fabric.
• Create and maintain data models and semantic layers.
• Develop and support interactive Power BI dashboards and Paginated Reports.
• Optimize performance of data solutions and troubleshoot issues.

Skills

Microsoft Fabric

Power BI

SQL

DAX

Data governance

Agile environment

Tools

Azure Data Services

Azure Synapse Analytics

Delta Lake

Python

Spark

Job description

Overview

Job Title: Senior Business Intelligence (BI) Analyst

Location: Markham, ON

Department: Business Intelligence / IT

Reports To: Business Intelligence Manager

Employment Type: Full-Time

About This Career Opportunity

Black & McDonald’s Business Intelligence/IT team is growing! If you are a committed and collaborative professional looking to contribute to a hard-working, innovative team, this opportunity is for you.

We are seeking a highly skilled Senior BI Developer to join our Business Intelligence team. In this role, you will design, develop, and optimize data solutions, dashboards, and reports leveraging Microsoft Fabric, Power BI, and Azure Data Services to enable advanced analytics and business intelligence capabilities across the organization.

Responsibilities

• Design and implement scalable data solutions using Microsoft Fabric.
• Create and maintain data models and semantic layers to support analytics and reporting.
• Develop and support interactive Power BI dashboards and Paginated Reports.
• Integrate data from multiple sources into OneLake, ensuring data quality, governance, and security.
• Collaborate with BI developers and business stakeholders to deliver efficient, scalable solutions.
• Optimize performance of data solutions and troubleshoot issues in complex environments.
• Implement best practices for data architecture, ETL/ELT processes, and metadata management.

Required Qualifications

• 5+ years of experience in data engineering or related roles.
• Strong expertise in Microsoft Fabric, Power BI, and Azure Synapse Analytics.
• Proficiency in SQL, DAX, and Power Query (M).
• Experience with data warehouse/lakehouse architecture, Azure OneLake, and Delta Lake.
• Solid understanding of data governance, security, and compliance in cloud environments.
• Strong problem-solving skills and ability to work in an agile environment.

Preferred Requirements

• Experience with Python or Spark for data transformation.
• Knowledge of machine learning pipelines and AI integration in Microsoft Fabric.
• Familiarity with CI/CD for data solutions and DevOps practices.
• Microsoft certifications such as Fabric Analytics Engineer Associate or Azure Data Engineer Associate.

What We Offer

• Competitive salary and benefits package.
• Opportunity to work with cutting-edge Microsoft Fabric technology.
• Collaborative and innovative work environment.
• Professional development and support.

Black & McDonald welcomes and encourages applications from persons with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the recruitment and selection process.

#LI-MK1