PowerBI Architect

About the role

We are looking for a highly experienced Power BI Embedded BI Solution Architect to support client-facing reporting modernization initiative.

The role will focus on designing and solving complex Power BI integration embedding performance security and external user reporting challenges within clients digital ecosystem.

The client currently has external users accessing reports through a client-facing website PSW and is migrating from the existing OAS BIE reporting platform to Power BI.

Responsibilities

• Provide deep architectural guidance
• Evaluate open design challenges
• Run focused proof-of-concepts
• Recommend scalable solutions for highly complex client-facing BI scenarios
• Not a standard Power BI developer role, the client is seeking a senior SME who can operate as an expert advisor, solve difficult BI architecture problems and bring industry experience from similar enterprise BI modernization programs

Requirements

• Strong expertise in Power BI especially Power BI Embedded and external client-facing implementations
• Experience integrating Power BI reports into web applications portals
• Experience building reusable embedded analytics frameworks
• Deep understanding of DirectQuery, Import and Hybrid data models
• Hand-on experience with Snowflake and large-scale data environments
• Strong knowledge of data tier security and user-level access control
• Experience optimizing report performance for high-volume external users
• Expertise in semantic layer design and data modeling strategies
• Ability to design solutions for large data exports, paginated reports and custom reporting needs
• Strong understanding of M query parameters, filtering techniques and potential risks
• Proven ability to solve complex BI architecture problems and provide scalable solutions
• Knowledge of UI abstraction patterns for embedded BI
• Experience with multitenant reporting architecture
• Experience migrating from Oracle Analytics Server OAS OBIEE-like platforms to Power BI

Qualifications

• Prior experience with financial services client reporting platforms (nice to have)
• Experience with external wealth brokerage institutional client portals (nice to have)

Skills

• Expertise in Power BI Embedded
• Experience integrating Power BI reports into web applications portals
• Experience building reusable embedded analytics frameworks
• Deep understanding of DirectQuery, Import and Hybrid data models
• Hand-on experience with Snowflake and large-scale data environments
• Strong knowledge of data tier security and user-level access control
• Experience optimizing report performance for high-volume external users
• Expertise in semantic layer design and data modeling strategies
• Ability to design solutions for large data exports, paginated reports and custom reporting needs
• Strong understanding of M query parameters, filtering techniques and potential risks
• Proven ability to solve complex BI architecture problems and provide scalable solutions
• Knowledge of UI abstraction patterns for embedded BI
• Experience with multitenant reporting architecture
• Experience migrating from Oracle Analytics Server OAS OBIEE-like platforms to Power BI

Benefits

The base compensation range for this role in the posted location is: $130,000 - $140,000

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws.

The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini may pay for the role at the time of this posting.

This range may be subject to change as permitted by law.

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)
• Retail 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