Power BI Reporting Architect

Bridge Investment Group; Sandy (UT); On-site; USD 70,000 - 100,000; Full time

Job summary

Bridge Investment Group is seeking a Power BI specialist to design and build reports and dashboards used by leadership and operators daily. This role offers hands-on ownership and close collaboration with business stakeholders to translate needs into clear metrics.

You will work in a modern data stack, connect to Azure SQL data warehouse and APIs, and grow into the go-to expert for our Power BI reporting architecture.

Qualifications

• 3+ years of hands-on experience building reports in Power BI.
• Strong data modeling skills — you understand star schemas, cardinality, and how model design drives report performance and correctness.
• Solid DAX and Power Query (M) proficiency.
• Comfortable writing SQL against a relational data warehouse.
• Advanced Excel skills — pivot tables, advanced formulas (INDEX/MATCH, XLOOKUP), and Power Query.
• Experience pulling and integrating data from APIs or other external sources.
• Ability to work independently, pick up an unfamiliar data model quickly, and grow into an owner of the reporting environment.

Responsibilities

• Design, architect, and build Power BI reports and dashboards using the project (PBIP) format, source control, and a shared theme/design system.
• Design clean, performant data models — star schemas, relationships, and DAX measures that are accurate, reusable, and easy to reason about.
• Connect Power BI to multiple sources: our Azure SQL data warehouse, a semantic layer, an analytics cube (XMLA/MDX), and third‑party APIs.
• Partner with business stakeholders to gather requirements and feedback, and turn them into clear, trustworthy metrics.
• Make architecture and design decisions that keep our reporting consistent, scalable, and easy to maintain.
• Collaborate with data engineering to shape the tables and views that feed your reports and to flag upstream data issues.
• Validate report accuracy against source systems and help maintain a consistent, governed catalog of metric definitions.

Skills

Power BI

Data modeling

DAX

Power Query

SQL

Excel advanced

Tools

Power BI

Azure SQL Data Warehouse

SQL

Excel

Power Query

Job description

Bridge Investment Group is seeking a Power BI specialist to design and build reports and dashboards used by leadership and operators daily. This role offers hands-on ownership and close collaboration with business stakeholders to translate needs into clear metrics.

You will work in a modern data stack, connect to Azure SQL data warehouse and APIs, and grow into the go-to expert for our Power BI reporting architecture.