The Power BI Lead is responsible for leading the design, development, governance, and support of enterprise reporting and analytics solutions using Microsoft Power BI and Microsoft Fabric. This role serves as the primary point of contact for business stakeholders, architects, data engineering teams, and offshore delivery teams, ensuring scalable, high-quality, and business-focused analytics solutions.

Key Responsibilities

Leadership & Delivery

- 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.

Business & Stakeholder Management

- 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.

Solution Design & Development

- 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.

Data & Integration

- 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.

Governance & Administration

- 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.

Performance & Optimization

- Optimize report rendering, DAX calculations, and dataset performance.

- Identify and resolve data refresh failures and reporting bottlenecks.

- Drive continuous improvement and automation initiatives.

AMS / Production Support

- 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.

Required Skills

- 8-12+ years of BI and analytics experience.

- 5+ years of hands-on Power BI development experience.

- Strong expertise in:

- Power BI Service

- Power BI Desktop

- DAX

- Power Query (M)

- Semantic Models

- Data Modeling

- Microsoft Fabric

- Strong SQL skills.

- Experience with Azure Data Platform (Databricks, Synapse, Azure SQL, ADLS).

- Experience with DevOps and CI/CD deployment practices.

- Understanding of data governance, security, and reporting best practices.

- Experience leading onsite-offshore delivery teams.

Preferred Certifications

- Microsoft PL-300 - Power BI Data Analyst

- Microsoft Fabric Analytics Engineer Associate

- Azure Data Engineer Associate

- Agile/Scrum certifications (preferred)

Key Success Metrics

- Report delivery quality and timeliness

- User adoption and stakeholder satisfaction

- Platform stability and performance

- SLA compliance

- Data accuracy and governance compliance

- Team utilization and capability development

- Continuous improvement and automation outcomes

Job Description

The role is responsible for creating visual representations of data, concepts, ideas, or designs to facilitate understanding, communication, and decision-making. The work also involves translating complex information into visual formats that are clear, engaging, and impactful.

Job Description - Grade Specific

The role plays a pivotal role in managing the visualization team, coordinating projects, ensuring quality, engaging stakeholders, and driving continuous improvement. The role also provides leadership, guidance, and support to achieve successful visualization initiatives and contribute to effective visual communication within the organization.

The base compensation range for this role in the posted location is $70,392 to $99,571.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave

• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility