SBIA-Senior Business Intelligence Analyst

Lifemark; Canada; Hybrid; CAD 90,000 - 105,000; Full time

Benefits offered by this job

Hybrid work model

Career growth

Inclusive culture

Job summary

Lifemark Health Group is seeking a Senior BI Analyst to design, build, and deliver enterprise reporting within a modern Microsoft Fabric and Azure ecosystem. This is a development-focused role building Power BI dashboards, semantic models, and end-to-end reporting assets that scale and inform business decisions.

The ideal candidate combines deep Power BI, data modeling, SQL, and Fabric expertise with a passion for high-quality, performant reporting that supports stakeholders across the

Qualifications

• 5+ years of experience in BI, analytics, or reporting roles.
• Proven track record delivering Power BI dashboards and semantic models from scratch.
• Advanced Power BI, DAX, Power Query, and data modeling expertise.
• Hands-on with Microsoft Fabric and Azure-based data platforms.
• Strong SQL skills and ability to translate requirements into production-ready solutions.

Responsibilities

• Design, develop, test, and deploy Power BI dashboards and reports from concept to production.
• Build operational, financial, and executive reporting to support decision-making.
• Create scalable data models and semantic layers for reporting performance.
• Develop reusable reporting frameworks, templates, and standards.
• Collaborate with stakeholders to translate requirements into analytics solutions.
• Mentor junior analysts and contribute to BI governance and standards.

Skills

Power BI

DAX

SQL

Data modeling

Stakeholder management

Azure

Education

Bachelor's degree in a related field

Tools

Microsoft Fabric

Azure

Power BI deployment pipelines

Job description

Salary Range: $90,000.00 To $105,000.00 Annually

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