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
