About the Role
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.
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
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
- 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
- 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
Skills
- Power BI
- DAX
- Power Query
- Data Modeling
- Microsoft Fabric
- Azure
- SQL
- Dimensional Modeling
- Star Schema Design
- Python
- CI/CD
- Tableau
- SSRS
- Looker
- Advanced Analytics
- Machine Learning
- Data Science
Location
- North York
Work Type
- Hybrid
- 4 days a week in office
- 1 day a week remote
Experience Level
- Senior
About the Company
- 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.
- 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
Equal Opportunity
- 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.
- Accommodations are available on request for all candidates taking part in any aspect of the recruitment and selection process. Email us at Talentatlifemark.ca.
