Senior Business Intelligence Analyst

This is a hybrid position based out of North York @ 243 Consumers Rd - You will work 4 days a week in office and 1 day a week remote

Lifemark Health Group (LHG) is a market leader in customized healthcare solutions. With over 20 years of service excellence, LHG is one of the largest, most trusted, and most comprehensive providers in Canada. As a national healthcare company, LHG employs over 5,000 highly trained clinicians, medical experts, and team members in almost 400 locations coast-to-coast and continues to grow both organically as well as through acquisitions. With that growth is a vision to be the most innovative healthcare provider in community rehabilitation, workplace health and wellness, and medical assessment services. Lifemark was acquired by Loblaw Companies on May 10, 2022.

Role Overview

We are seeking a highly skilled and hands-on Senior Business Intelligence (BI) Analyst to design, build, and deliver enterprise reporting and analytics solutions within a modern Microsoft Fabric and Azure ecosystem.

This is a development-focused role. You will be responsible for building Power BI dashboards, semantic models, and reporting assets from end to end - transforming raw data into scalable, production-ready reporting solutions that drive business decisions across the organization.

The ideal candidate combines deep expertise in Power BI, data modeling, SQL, and Microsoft Fabric with a passion for delivering high-quality reporting experiences that are performant, reliable, and user-friendly.

Key Responsibilities:

Power BI Development & Reporting Delivery

Design, develop, test, and deploy Power BI dashboards and reports from concept to production

Build operational, financial, and executive reporting solutions that support strategic decision-making

Create intuitive, visually compelling, and pixel-perfect dashboards following UX and visualization best practices

Develop reusable reporting frameworks, templates, and standards

Deliver both standardized reporting solutions and ad hoc analytical reporting requests

Serve as the primary owner for reporting deliverables and dashboard lifecycle management

Data Modeling & Semantic Layer Development

Design and maintain enterprise semantic models and Power BI datasets

Develop advanced DAX measures, KPIs, and business calculations

Build scalable dimensional and star-schema data models optimized for reporting performance

Establish and maintain a trusted single source of truth for business metrics and reporting

Ensure consistency and accuracy across all reporting assets

Microsoft Fabric & Data Integration

Develop solutions using Microsoft Fabric components, including Lakehouse, Warehouse, Dataflows, and Data Pipelines

Source, cleanse, transform, and prepare data for reporting and analytics use cases

Partner with Data Engineering teams to consume curated Gold-layer datasets

Contribute to reporting-focused data pipeline development and optimization

Support data integration efforts across multiple business systems and data sources

Stakeholder Engagement & Delivery

Collaborate with business stakeholders to gather requirements and translate them into actionable reporting solutions

Lead report design discussions and iterative feedback sessions

Prioritize and deliver reporting assets aligned with business objectives

Communicate insights, recommendations, and technical concepts to both technical and non-technical audiences

Performance Optimization & Scalability

Optimize report performance through efficient DAX, model design, and query tuning

Ensure reporting solutions remain scalable across large and growing datasets

Monitor dashboard adoption, usage patterns, and performance metrics

Continuously improve reporting efficiency, usability, and responsiveness

Data Governance & Quality

Apply enterprise standards for naming conventions, documentation, and metadata management

Validate data accuracy and ensure reporting reliability

Support governance initiatives related to reporting, metrics, and business definitions

Maintain documentation for datasets, reports, and reporting processes

Mentorship & Best Practices

Promote best practices in Power BI development, data modeling, and visualization design

Mentor junior analysts and BI developers

Contribute to establishing a Reporting and Analytics Center of Excellence

Drive continuous improvement in BI development standards and methodologies

What we're looking for:

5+ years of experience in Business Intelligence, Analytics, or Reporting-focused roles

Proven experience building Power BI dashboards, reports, and semantic models from scratch

Advanced expertise in Power BI, DAX, Power Query, and data modeling

Hands-on experience with Microsoft Fabric and/or Azure-based data platforms

Strong SQL skills for data extraction, transformation, and optimization

Experience delivering enterprise-scale, production-grade reporting solutions

Strong understanding of dimensional modeling, star schema design, and reporting best practices

Excellent communication and stakeholder management skills

Strong builder mindset with a passion for hands-on development

Ability to independently translate business requirements into production-ready solutions

Exceptional attention to detail and commitment to data quality

Strong problem-solving and analytical skills

Excellent collaboration and stakeholder engagement abilities

Focus on performance, scalability, maintainability, and user experience

Continuous learning mindset and willingness to adopt emerging technologies

Nice to Have

Experience with Python for automation, analytics, or data preparation

Familiarity with CI/CD processes for Power BI deployments

Experience with Power BI deployment pipelines and workspace administration

Preferred Qualifications

Experience with Microsoft Fabric components, including Lakehouse, Warehouse, Data Factory, and Real-Time Analytics

Strong understanding of Medallion Architecture (Bronze, Silver, Gold)

Experience implementing reporting governance and enterprise BI standards

Familiarity with additional reporting and visualization tools such as Tableau, SSRS, or Looker

Exposure to advanced analytics, machine learning, or data science workflows

Success Metrics

Delivery of high-quality Power BI dashboards and reporting solutions

Dashboard adoption and engagement across business teams

Report performance, reliability, and scalability

Stakeholder satisfaction and business impact

Reduction in manual reporting effort

Consistency and adherence to BI standards and governance practices

Why Join Us

Opportunity to help build and scale a modern enterprise reporting ecosystem using Microsoft Fabric

High-impact role with ownership of critical reporting and analytics solutions

Exposure to cutting-edge cloud data and analytics technologies

Collaborative, data-driven culture focused on innovation and continuous improvement

Career growth opportunities into BI Lead, Analytics Architect, or Data Platform leadership roles

Inclusion

We are committed to creating an inclusive environment where people from all backgrounds can thrive. Improving inclusion and equity is a collective responsibility. Lifemark promotes equal employment opportunities for all job applicants, including but not limited to those self-identifying as a member of the employment equity groups: Indigenous peoples, Newcomers to Canada, Women, and Visible minorities.

Accommodation

Accommodations are available on request for all candidates taking part in any aspect of the recruitment and selection process. Email us at Talentatlifemark.ca.

#LI-NC1