Senior BI Analyst

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

Job summary

A leading infrastructure company is seeking a Senior Business Intelligence (BI) Analyst in Markham, ON. The role involves designing and optimizing data solutions using Microsoft Fabric, Power BI, and Azure. Candidates should have over 5 years of experience in data engineering and proficiency in SQL and DAX. Offering competitive salary and benefits, the position provides an opportunity to work with cutting-edge technologies in a collaborative environment.

Benefits

Competitive salary and benefits package

Professional development and support

Opportunity to work with cutting-edge technology

Qualifications

• 5+ years of experience in data engineering or related roles.
• Strong expertise in data visualization tools like Power BI.
• Proficiency in SQL and DAX.

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.

Skills

Microsoft Fabric

Power BI

SQL

DAX

Power Query (M)

Data governance

Agile environment

Problem-solving

Tools

Azure Synapse Analytics

Delta Lake

Azure OneLake

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

Black & McDonald’s Business Intelligence/IT team is growing! If you are 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 Business Intelligence (BI) Analyst 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.

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