Senior Power BI Lead

Brown & Brown Insurance

Senior Power BI Lead establishing and scaling centralized Power BI function within Arrowhead Intermediaries. Overseeing reporting standards, governance, and security across divisions.

Posted 7/24/2026full-timeChicago • Colorado, Illinois • 🇺🇸 United StatesSenior💰 $170,000 - $180,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expert-level Power BI skills, including semantic modeling, DAX, and report governance, while leading the development of a BI team and ensuring data accessibility and quality across the organization. Proven ability to design complex security models and manage stakeholder relationships effectively.

Highest-signal resume keywords

Expert-Level Power BI SkillsBusiness Intelligence Team LeadershipAdvanced SQL and Data ModelingInsurance Industry ExperienceComplex Row-Level Security Design

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BIDAXPower QueryDataflowsSQLDimensional ModelingStar and Snowflake SchemasData WarehousingSemantic ModelingIncremental Refresh

Soft Skills

Stakeholder ManagementBusiness AnalysisWritten CommunicationVerbal CommunicationDesign Sensibility

Tools & Technologies

Power BI GovernanceData CatalogingReport CertificationLifecycle ManagementProduction Support

Industry Keywords

Insurance IndustryProperty and CasualtySpecialty InsuranceMGA/MGUWholesale BrokerageRetail AgencyCarrierInsurance Distribution

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Creates the foundation for a new Power BI department inside the AHI Data Strategy & BI team, including team structure, operating model, standards, intake, delivery, quality control, and support practices
Sets the standard for all AHI Data Strategy Power BI reporting across Arrowhead Programs, Bridge Specialty Group, and Arrowhead Specialty
Ensure business users receive correct, governed, and accessible information through certified datasets, standardized metrics, report governance, and disciplined release management
Leads complex reporting scenarios involving unique row-level security requirements, different business models, varying levels of data maturity, and cross-division datasets that must be combined responsibly

Requirements

What you’ll need

10+ years of business intelligence, analytics, data platform, or reporting experience
5+ years of advanced Power BI experience
3+ years in a senior lead, architect, administrator, or BI platform ownership role
Required insurance industry experience, preferably in property and casualty, specialty insurance, MGA/MGU, wholesale brokerage, retail agency, carrier, or insurance distribution environments
Demonstrated experience building or maturing a BI team, reporting function, governance program, center of excellence, or enterprise analytics operating model
Expert-level Power BI skills, including semantic modeling, DAX, Power Query, dataflows, deployment pipelines, workspace design, performance tuning, incremental refresh, composite models, report design, and tenant/capacity administration
Strong understanding of Power BI governance, report certification, data cataloging, stewardship, metric standardization, security, lifecycle management, production support, and adoption practices
Proven ability to design and implement complex row-level security models and access-control patterns across multiple business units, hierarchies, and user groups
Advanced SQL and data modeling experience, including dimensional modeling, star and snowflake schemas, relational databases, data warehouses, lakehouse patterns, curated datasets, and semantic layers
Experience combining data across multiple divisions, platforms, source systems, and maturity levels, with the judgment to identify limitations, document assumptions, and avoid misleading insights
Strong business analysis and stakeholder management skills
Excellent written and verbal communication skills
Strong design sensibility for executive reporting
Demonstrated ability to lead highly visible initiatives while remaining hands-on in architecture, development, troubleshooting, and quality review
Bachelor's degree in computer science , Information Systems, Statistics, Analytics, Data Science, Business, or a related field, or equivalent practical experience.

Benefits

Comp & perks

Health Benefits : Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance
Financial Benefits : ESPP; 401k; Student Loan Assistance; Tuition Reimbursement
Mental Health & Wellness : Free Mental Health & Enhanced Advocacy Services
Beyond Benefits : Paid Time Off, Holidays, Preferred Partner Discounts and more.