Lead Power BI developer

Cognizant; Toronto; Hybrid; CAD 100,000 - 120,000; Full time

Job summary

A leading technology services firm in Toronto seeks a Lead Power BI Developer to design and implement advanced BI solutions. With an emphasis on dashboard modernization and team mentorship, the ideal candidate will possess deep expertise in Power BI, SQL, and data integration from various platforms. This role contributes to impactful analytics in insurance operations and requires strong collaboration skills and senior experience.

Qualifications

• 10+ years of experience in Power BI Development.
• Proven ability to lead BI initiatives and mentor junior developers.
• Experience designing ETL pipelines and integrating data from various platforms.

Responsibilities

• Drive design and development of advanced BI solutions.
• Lead dashboard modernization and mentor junior developers.
• Collaborate with stakeholders to gather requirements.

Skills

Power BI Development

Data Modeling

DAX Expressions

ETL Development

Collaboration

Education

Microsoft Certified Power BI Data Analyst Associate

Azure Data Engineer Associate

Databricks Certified Developer

Tools

SQL

Python

Azure Data Factory

Power Platform

Job description

Overview

Job title - Lead Power BI Developer
Location - Toronto, Canada (Hybrid)
Experience Level: Senior (10+ years preferred)
Certification - Microsoft Certified Power BI Data Analyst Associate

Responsibilities

The Lead Senior Power BI Developer will drive the design, development, and deployment of advanced BI solutions tailored to insurance operations. This role involves leading dashboard modernization efforts, mentoring junior developers, and collaborating with business stakeholders to deliver high-impact analytics.

Key Responsibilities

• Power BI Development
• - Lead the development of interactive dashboards, paginated reports, and semantic models using Power BI.
• - Build and optimize DAX expressions, Power Query/M scripts, and data models for performance and usability.
• - Migrate legacy reports (e.g., QlikView, Cognos, SAP BOBJ) to Power BI.

Data Engineering & Integration

• Design and maintain ETL pipelines using SQL, Python, and Azure Data Factory.
• Integrate data from insurance platforms such as Guidewire, Salesforce, and Policy Admin Systems.

Leadership & Collaboration

• Mentor junior developers and guide BI teams in Agile environments.
• Collaborate with business analysts, data architects, and stakeholders to gather requirements and translate them into technical solutions.
• Lead sprint planning, backlog grooming, and delivery cycles for BI initiatives.

Governance & Documentation

• Ensure compliance with data governance and security standards.
• Maintain documentation including user manuals, technical specs, and change logs.

Technical Environment

Tools: Power BI, Power Platform, Power Automate, Azure, SQL Server, Python, Spark
Frameworks: Microsoft Fabric, Semantic Layer, Delta Lake

Certifications Preferred

• Microsoft Certified Power BI Data Analyst Associate
• Azure Data Engineer Associate
• Databricks Certified Developer

Insurance-Specific Use Cases

• Claims Analytics: Real-time dashboards for fraud detection, KPIs, and anomaly alerts.
• Policy Insights: Role-based visualizations for underwriting and policy management.
• Customer 360: Hyper-personalized dashboards for client engagement and retention.