Power BI Architect/Lead

Post Date

Jul 11, 2025

Location

Philadelphia,
Pennsylvania

ZIP/Postal Code

19103
US
Dec 21, 2025 Insight Global

Job Type

Contract

Category

Architect

Req #

KPD-793535

Pay Rate

$60 - $75 (hourly estimate)

Job Description

Insight Global's consulting client is seeking an experienced Power BI Technical Lead/Architect to oversee the end-to-end design and development of Finance and Control reports for a Specialty Insurance client.

This role involves leading client discussions to define and architect the Power BI reporting solution, designing and supporting complex queries, driving performance optimization strategies, and providing expert guidance on data security and governance.

The ideal candidate will have proficiency in Power BI, data warehousing, ETL processes, data modeling, and experience with Databricks. This project includes creating a Data Lake platform in Databricks, integrating data from Guidewire and Legacy systems to support reporting across multiple departments.

This person can sit fully remote with 25% -30% (5-6 days a month) travel to the end client in Cincinnati, OH. There are some cases where travel is optional but encouraged.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form. The EEOC "Know Your Rights" Poster is available here.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

- 5-8 years of experience with Power BI architecture including designing and optimizing complex queries.
- Strong skills in data warehousing, ETL processes, and data modeling.
- Experience with Databricks and integrating data from various systems.

Nice to Have Skills & Experience

- Experience with Guidewire or working within the specialty Insurance industry

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.