Senior Power BI Lead

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

Benefits offered by this job

Health benefits

401k

Paid time off

Job summary

Arrowhead Intermediaries seeks a Senior Power BI Lead to establish a centralized Power BI function within the Data Strategy & BI team. You will set enterprise standards for reporting across Arrowhead Programs, Bridge Specialty Group, and Arrowhead Specialty, ensuring certified datasets, governance, and secure, scalable data solutions.

You will design and implement complex row-level security, lead a BI team, and collaborate with executives to deliver robust, data-driven insights across multiple

Qualifications

• 10+ years BI/analytics experience, 5+ years Power BI, 3+ years in senior lead roles.
• Insurance industry experience preferred (property & casualty, MGA/wholesale, etc).
• Experience building/maturing a BI function, governance program, or center of excellence.
• Expert-level Power BI: semantic modeling, DAX, Power Query, dataflows, deployment pipelines.
• Strong Power BI governance, data cataloging, security, lifecycle management.
• Design and implement complex row-level security across multiple units.
• Advanced SQL and data modeling: star/snowflake schemas, data warehouses.
• Translate executive needs into data products, technical specs, and governance.
• Excellent communication and stakeholder management.
• Bachelor’s degree or equivalent in CS/IS/Analytics/Business.

Responsibilities

• Create the foundation for a new Power BI department, including team structure and operating model.
• Set enterprise standards for Power BI reporting across divisions for consistency.
• Ensure governed, accessible information via certified datasets and standardized metrics.
• Lead cross-division dataset projects with appropriate security and data maturity considerations.

Skills

Power BI

Data governance

SQL

Data modeling

Stakeholder mgmt

Communication

Leadership

Executive reporting

Row-level security

Architecture

Education

Bachelor's degree or equivalent

Tools

Azure

Databricks

Fabric

Synapse

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

Skills & Experience to Be Successful

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