Senior Power BI Lead

About the role

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 is seeking a Senior Power BI Lead to join our growing team. This is a hybrid opportunity, with preference given to candidates located in Atlanta, Chicago, Denver, or San Diego.

Responsibilities

• Create 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.
• Set 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.
• Lead 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

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

Qualifications

• Required insurance industry experience, preferably in property and casualty, specialty insurance, MGA/MGU, wholesale brokerage, retail agency, carrier, or insurance distribution environments.
• 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.

Skills

• Power BI
• Azure
• Databricks
• Microsoft Fabric
• Azure Data Lake
• Synapse
• SQL Server
• Analysis Services
• Purview
• Python
• R
• APIs
• Automation
• DevOps
• Git
• Advanced analytics workflows

Benefits

• 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
• Teammate Benefits & Total Well-Being: Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more.

Pay

$170,000.00 - $180,000.00 Annual