Senior Power BI Lead

Arrowhead Programs; Chicago (IL); Hybrid; USD 170,000 - 180,000; Full time

Benefits offered by this job

Health Benefits: Medical/Rx, Dental, 4

Vision Insurance

Life Insurance

Disability Insurance

ESPP

401k

Tuition Reimbursement

Paid Time Off

Holidays

Employee discounts

Job summary

Arrowhead Intermediaries seeks a Senior Power BI Lead to establish centralized Power BI across the AHI Data Strategy & BI team, serving three divisions and setting enterprise standards for reporting, governance, semantic modeling, and report lifecycle management.

The ideal candidate has 10+ years in BI, 5+ years Power BI, strong SQL and governance experience, and a proven ability to lead a BI team across multiple divisions.

Qualifications

• 10+ years of BI, analytics, data platform, or reporting experience.
• 5+ years advanced Power BI experience and 3+ years senior lead/architecture ownership.
• Insurance industry experience preferred (property/casualty, MGA/MGU, etc.).
• Experience building or maturing BI teams, governance programs, or enterprise analytics models.
• Expert-level Power BI skills: semantic modeling, DAX, dataflows, deployment pipelines, security, and governance.
• Strong SQL, dimensional modeling, star/snowflake schemas, data warehouses, and data integration.
• Ability to design complex row-level security across multiple units and hierarchies.
• Excellent communication to translate exec needs into data products and standards.

Responsibilities

• Creates foundation for a new Power BI department within the AHI Data Strategy & BI team.
• Sets enterprise standards for reporting across Arrowhead Programs, Bridge Specialty Group, and Arrowhead Specialty.
• Ensures governed, accessible information via certified datasets, standardized metrics, and lifecycle management.
• Leads complex reporting with diverse data maturity levels and cross-division datasets.

Skills

Power BI

SQL

DAX

Data Modeling

Data Governance

Row-level Security

Stakeholder Management

Visualization

Dimensional Modeling

SQL Server

Education

Bachelor's degree in Computer Science or related field

Tools

Azure

Databricks

Microsoft Fabric

Azure Data Lake

Synapse

SQL Server

Analysis Services

Purview

Tableau

Job description

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.

Arrowhead Intermediaries and its divisions—Arrowhead Programs, Bridge Specialty Group, and Arrowhead Specialty are seeking a Senior Power BI Lead to join our growing team. This hybrid opportunity is ideally suited for candidates based in Atlanta, Chicago, Denver, or San Diego.

Arrowhead Intermediaries (AHI), the Specialty segment of Brown & Brown, is seeking a senior Power BI leader to establish and scale a centralized Power BI function within the AHI Data Strategy & BI team. This role will serve three independently operated divisions and will be responsible for setting the enterprise standard for Power BI reporting, governance, security, semantic modeling, and report lifecycle management across AHI.

How You Will Contribute:

• 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, balancing divisional needs with enterprise consistency.
• 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.

Required

• 10+ years of business intelligence, analytics, data platform, or reporting experience, including 5+ years of advanced Power BI experience and 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, with the ability to translate executive and operational needs into clear data products, technical specifications, and governance practices.
• Excellent written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences and influence leaders to adopt standards.
• Strong design sensibility for executive reporting, including visualization best practices, accessibility, user experience, branding, storytelling, layout, filters, slicers, navigation, and actionable insights.
• 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.

Preferred Qualifications

• Experience with Azure, Databricks, Microsoft Fabric, Azure Data Lake, Synapse, SQL Server, Analysis Services, Purview, or related Microsoft data platform capabilities.
• Experience with Tableau or other BI tools, especially where tool rationalization or standardization was required.
• Experience in data governance, master data management, data quality, metadata management, data lineage, stewardship, or enterprise data strategy.
• Power BI, Fabric, Azure Data Engineer, Azure Solutions Architect, or related Microsoft certifications.
• Experience with Python, R, APIs, automation, DevOps, Git, or advanced analytics workflows.

Pay Range

170,000.00 - 180,000.00 Annual

The pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role.

Teammate Benefits & Total Well-Being

• 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.

Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations.

Recruiting Vendor Disclosure Statement

Brown & Brown does not accept unsolicited resumes from external recruiters, recruitment vendors or employment agencies (“Recruiting Vendors”). Recruiting Vendors must have a valid written agreement and received prior written authorization from an authorized Brown & Brown representative before submitting candidates for any publicly posted role. Any unsolicited resumes submitted to Brown & Brown or its employees become the property of Brown & Brown, and no fees will be paid for such submissions. Additional information regarding this policy can be found on our careers page.

The Power To Be Yourself

As an Equal Opportunity Employer, we are committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, “The Power to Be Yourself”.