Senior Business Intelligence Analyst

Lifemark Health Group•Toronto, ON

6h•CA$90,000 - CA$105,000•Hybrid

About The Position

Lifemark Health Group (LHG) is a market leader in customized healthcare solutions with over 20 years of service excellence. As one of Canada's largest and most trusted healthcare providers, LHG operates in almost 400 locations nationwide and employs over 5,000 professionals. The company is committed to being the most innovative provider in community rehabilitation, workplace health and wellness, and medical assessment services. Lifemark was acquired by Loblaw Companies on May 10, 2022. 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. 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 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.

Requirements

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 Haves

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

Responsibilities

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