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

Nice to have

• Prior experience with financial services client reporting platforms
• Experience with external wealth brokerage institutional client portals

Qualifications

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.

Benefits

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

Important Notice

Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini’s discretion, consistent with applicable laws.

Disclaimers

Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. Capgemini also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect.