Power BI Solution Architect

Capgemini; Irving (TX); On-site; USD 140,000 - 210,000; Full time

Job summary

Capgemini is seeking a senior Power BI Embedded BI Solution Architect for a client-facing reporting modernization initiative in Westlake, TX. The role focuses on embedding Power BI, performance optimization, security, and scalable BI architecture across multi-tenant environments.

The ideal candidate brings expert advisory capabilities, experience migrating from legacy BI platforms, and a track record of solving complex BI architecture challenges in enterprise settings.

Qualifications

• Strong expertise in Power BI, especially Power BI Embedded and external client-facing implementations.
• Experience integrating Power BI reports into web applications and portals.
• Experience building reusable embedded analytics frameworks.
• Deep understanding of DirectQuery, Import and Hybrid data models.
• Hands-on 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 and paginated reports.
• Strong understanding of M query, parameters, filtering and risks.

Skills

Power BI Embedded

External client-facing

Web apps integration

Reusable analytics framework

DirectQuery

Hybrid data models

Snowflake

Data security

Paginated reports

M query

Multitenant reporting

Job description

Role: Power BI Embedded BI Solution Architect

Location: Westlake, TX

This role doesn't sponsor Visa

Job Description

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.

The selected SME will provide deep architectural guidance evaluate open design challenges run focused proof of concepts and recommend scalable solutions for highly complex client facing BI scenarios.

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

Required Skills Experience

• Strong expertise in Power BI especially Power BI Embedded and external clientfacing 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
• Handson experience with Snowflake and largescale data environments
• Strong knowledge of datatier security and userlevel access control
• Experience optimizing report performance for highvolume 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 Skills

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