BI Lead
Lead the design, development, governance, and support of enterprise reporting and analytics solutions using Microsoft Power BI and Microsoft Fabric.
- North York, Ontario, Canada
- Full-time
- Hybrid
- Posted Nov 13, 2026
INDUSTRYSoftware & InternetSaaS & Enterprise Software
Responsibilities
- Lead a team of Power BI developers, analysts, and support resources
- Prioritize and manage reporting demand, enhancements, defects, and production support activities
- Act as the technical and functional lead for Power BI initiatives
- Drive offshore team enablement, knowledge sharing, and work delegation
- Ensure adherence to delivery timelines, quality standards, and SLAs
- Partner with business stakeholders to understand reporting and analytics requirements
- Translate business needs into actionable reporting solutions and KPIs
- Facilitate requirement workshops, solution reviews, and user acceptance testing
- Provide executive-level reporting insights and recommendations
- Design and develop enterprise-scale dashboards, scorecards, and self-service reporting solutions
- Build and optimize semantic models, data models, measures, and calculations using DAX
- Develop reusable reporting frameworks and visualization standards
- Define reporting architecture and best practices
- Work with Data Engineering teams to define data requirements and optimize datasets
- Integrate Power BI with Azure Databricks, Fabric, SQL Server, Synapse, Snowflake, and other enterprise platforms
- Ensure data quality, consistency, and reporting performance
- Establish Power BI governance, security, and deployment standards
- Manage workspaces, apps, access controls, and Row-Level Security (RLS)
- Monitor platform usage, refresh schedules, gateway health, and capacity utilization
- Ensure compliance with enterprise data governance policies
- Optimize report rendering, DAX calculations, and dataset performance
- Identify and resolve data refresh failures and reporting bottlenecks
- Drive continuous improvement and automation initiatives
- Oversee L2/L3 support activities for Power BI solutions
- Manage incidents, problem management, root cause analysis, and preventive actions
- Maintain operational documentation, SOPs, and knowledge repositories
Requirements
Nice to have: Microsoft PL-300 – Power BI Data Analyst, Microsoft Fabric Analytics Engineer Associate, Azure Data Engineer Associate, Agile/Scrum certifications
Skills
Power BI ServicePower BI DesktopDAXPower Query (M)Semantic ModelsData ModelingMicrosoft FabricSQLAzure Data PlatformDatabricksSynapseAzure SQLADLSDevOpsCI/CDData governanceSecurityReporting best practicesOnsite-offshore delivery teamsMicrosoft Power BIMicrosoft FabricAzure DatabricksAzure SynapseAzure SQLADLSSnowflakeSQL ServerDAXPower Query (M)DevOpsCI/CD
Full description
Capgemini Canada
Company details are for members
Sign up for a free job alert to see Capgemini Canada's profile, website and LinkedIn, and the same for every employer on Referso Jobs.