Power BI Architect

Job Title: Senior Power BI Architect

Location: Whitehouse Station, NJ

Duration: Up to 6 months

Project Overview

The client is seeking a senior-level Power BI Architect to lead a reporting transformation initiative across Healthy Paws (Pet Insurance), Renters, and Jewelry & Watches. The consultant will design and build a unified reporting ecosystem, establish standardized KPIs, and migrate reporting assets to a shared Power BI semantic model.This is not a report developer position. The client needs a consultant who can function as a reporting architect, business partner, and governance lead while working within a highly structured, traditional insurance environment.Success requires balancing technical expertise with stakeholder management, documentation, governance, and consensus-building across multiple business units.

What Success Looks Like

• Build a shared Power BI semantic model used across multiple insurance products
• Establish standardized KPI definitions and reporting governance
• Deliver operational, financial, marketing, and partner reporting solutions
• Transition legacy reporting into a unified framework
• Create documentation, runbooks, and training materials for long-term ownership
• Implement reporting standards that support self-service analytics

Required Experience

Must-Have

• 5+ years developing enterprise-scale Power BI solutions
• Strong semantic model architecture experience
• Advanced DAX
• Paginated Reports
• Power BI Service administration
• Row-Level Security (RLS)
• 5+ years SQL Server/T-SQL
• Snowflake SQL experience
• Experience building KPI governance frameworks
• Experience standardizing reporting across multiple business functions
• Strong requirements gathering and stakeholder management skills