Top Benefits
About the role
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 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.
- 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 Black & McDonald Limited
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 visit: https://blackandmcdonald.com/licenses/
Top Benefits
About the role
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 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.
- 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 Black & McDonald Limited
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 visit: https://blackandmcdonald.com/licenses/