Power BI Lead
About the role
Power BI Lead Employment Type: Contract-to-Hire (possible 3-month CTH) Location: North York, Ontario, Canada Work Mode: Hybrid (3 days/week in office)
Job Summary Our client is looking for a Power BI Lead to drive the design, development, governance, and support of enterprise reporting and analytics on Microsoft Power BI and Microsoft Fabric. As the main point of contact for business stakeholders, architects, data engineering, and offshore delivery teams, you’ll lead a team of Power BI developers, analysts, and support staff, manage reporting demand and production support, and set the standards that make analytics scalable, high-quality, and business-focused. Success will be measured by delivery quality and timeliness, user adoption, platform stability, SLA compliance, data accuracy, and continuous improvement.
Key Responsibilities
- Lead a team of Power BI developers, analysts, and support staff, and enable and delegate work to offshore teams.
- Prioritize and manage reporting demand, enhancements, defects, and production support, meeting timelines, quality standards, and SLAs.
- Partner with business stakeholders to gather requirements, define KPIs, and run requirements workshops, solution reviews, and UAT.
- Provide executive-level reporting insights and recommendations.
- Design and build enterprise dashboards, scorecards, and self-service reporting solutions.
- Build and optimize semantic models, data models, and DAX measures, and create reusable reporting frameworks and visual standards.
- Define reporting architecture and best practices.
- Work with data engineering to define data requirements and integrate Power BI with Azure Databricks, Fabric, SQL Server, Synapse, Snowflake, and other platforms.
- Establish Power BI governance, security, and deployment standards, and manage workspaces, apps, access, and row-level security (RLS).
- Monitor usage, refresh schedules, gateway health, and capacity, and keep data quality and performance high.
- Optimize report rendering, DAX, and dataset performance, and resolve refresh failures and bottlenecks.
- Oversee L2/L3 support, including incident and problem management, root cause analysis, and prevention.
- Maintain operational documentation, SOPs, and knowledge repositories, and drive automation and continuous improvement.
Required Qualifications
- 8-12+ years of BI and analytics experience.
- 5+ years of hands-on Power BI development.
- Strong expertise in Power BI Service, Power BI Desktop, DAX, Power Query (M), semantic models, data modeling, and Microsoft Fabric.
- Strong SQL skills.
- Experience with the Azure data platform (Databricks, Synapse, Azure SQL, ADLS).
- Experience with DevOps and CI/CD deployment practices.
- A solid understanding of data governance, security, and reporting best practices.
- Experience leading onsite-offshore delivery teams.
- Willingness to complete a mandatory background check.
Nice to Have
- Microsoft PL-300 (Power BI Data Analyst) certification.
- Microsoft Fabric Analytics Engineer Associate certification.
- Azure Data Engineer Associate certification.
- Agile/Scrum certifications.
This engagement is managed end-to-end by Querentia. Our recruiters give you honest feedback at every stage, prepare you for the interview, and support a smooth onboarding once you land the offer.
