Skills

Python SQL Data Governance Data Engineering CI/CD DevOps Azure Synapse Analytics Problem-solving Analytics and Reporting Architecture Data Architecture Machine Learning power bi Organization Azure Agile Recruitment Analytics Spark DAX

Job Specifications

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 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.

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.

About the Company

Black & McDonald is an integrated, multi-trade service provider that safely delivers high-quality construction, facilities management, and technical solutions. We are a family-owned and operated company with over 6,500 employees working out of 40+ offices across North America. With more than 100 years of diverse market experience across North America, we are a forward-thinking organization with a strong track record of delivering customer-focused solutions and operational excellence. For more information on our licenses visi... Know more