Salary Range: $90,000.00 To $105,000.00 AnnuallyThis 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 remoteLifemark 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 OverviewWe 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 DeliveryDesign, develop, test, and deploy Power BI dashboards and reports from concept to productionBuild operational, financial, and executive reporting solutions that support strategic decision-makingCreate intuitive, visually compelling, and pixel-perfect dashboards following UX and visualization best practicesDevelop reusable reporting frameworks, templates, and standardsDeliver both standardized reporting solutions and ad hoc analytical reporting requestsServe as the primary owner for reporting deliverables and dashboard lifecycle managementData Modeling & Semantic Layer DevelopmentDesign and maintain enterprise semantic models and Power BI datasetsDevelop advanced DAX measures, KPIs,



and business calculationsBuild scalable dimensional and star-schema data models optimized for reporting performanceEstablish and maintain a trusted single source of truth for business metrics and reportingEnsure consistency and accuracy across all reporting assetsMicrosoft Fabric & Data IntegrationDevelop solutions using Microsoft Fabric components, including Lakehouse, Warehouse, Dataflows, and Data PipelinesSource, cleanse, transform, and prepare data for reporting and analytics use casesPartner with Data Engineering teams to consume curated Gold-layer datasetsContribute to reporting-focused data pipeline development and optimizationSupport data integration efforts across multiple business systems and data sourcesStakeholder Engagement & DeliveryCollaborate with business stakeholders to gather requirements and translate them into actionable reporting solutionsLead report design discussions and iterative feedback sessionsPrioritize and deliver reporting assets aligned with business objectivesCommunicate insights, recommendations, and technical concepts to both technical and non-technical audiencesPerformance Optimization & ScalabilityOptimize report performance through efficient DAX, model design, and query tuningEnsure reporting solutions remain scalable across large and growing datasetsMonitor dashboard adoption, usage patterns, and performance metricsContinuously improve reporting efficiency, usability, and responsivenessData Governance & QualityApply enterprise standards for naming conventions, documentation, and metadata managementValidate data accuracy and ensure reporting reliabilitySupport governance initiatives related to reporting, metrics, and business definitionsMaintain documentation for datasets, reports, and reporting processesPromote best practices in Power BI development, data modeling, and visualization designMentor junior analysts and BI developersContribute to establishing a Reporting and Analytics Center of ExcellenceDrive continuous improvement in BI development standards and methodologiesWhat we're looking for:5+ years of experience in Business Intelligence, Analytics, or Reporting-focused rolesProven experience building Power BI dashboards, reports, and semantic models from scratchAdvanced expertise in Power BI, DAX, Power Query, and data modelingHands-on experience with Microsoft Fabric and/or Azure-based data platformsStrong SQL skills for data extraction, transformation, and optimizationStrong understanding of dimensional modeling,



star schema design, and reporting best practicesExcellent communication and stakeholder management skillsStrong builder mindset with a passion for hands-on developmentAbility to independently translate business requirements into production-ready solutionsExceptional attention to detail and commitment to data qualityStrong problem-solving and analytical skillsExcellent collaboration and stakeholder engagement abilitiesFocus on performance, scalability, maintainability, and user experienceContinuous learning mindset and willingness to adopt emerging technologiesNice to HaveExperience with Python for automation, analytics, or data preparationFamiliarity with CI/CD processes for Power BI deploymentsExperience with Power BI deployment pipelines and workspace administrationPreferred QualificationsExperience with Microsoft Fabric components, including Lakehouse, Warehouse, Data Factory, and Real-Time AnalyticsStrong understanding of Medallion Architecture (Bronze, Silver, Gold)Experience implementing reporting governance and enterprise BI standardsFamiliarity with additional reporting and visualization tools such as Tableau, SSRS, or LookerExposure to advanced analytics, machine learning, or data science workflowsSuccess MetricsDelivery of high-quality Power BI dashboards and reporting solutionsDashboard adoption and engagement across business teamsReport performance, reliability, and scalabilityStakeholder satisfaction and business impactConsistency and adherence to BI standards and governance practicesWhy Join UsOpportunity to help build and scale a modern enterprise reporting ecosystem using Microsoft FabricHigh-impact role with ownership of critical reporting and analytics solutionsExposure to cutting-edge cloud data and analytics technologiesCollaborative, data-driven culture focused on innovation and continuous improvementCareer growth opportunities into BI Lead, Analytics Architect, or Data Platform leadership rolesInclusionWe are committed to creating an inclusive setting 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.AccommodationAccommodations are available on request for all candidates taking part in any aspect of the recruitment and selection process. Email us at Talentatlifemark.Ca.

📌 Sbia-Senior Business Intelligence Analyst (Ottawa)
🏢 Lifemark
📍 Ottawa