Manager, Business Intelligence

Gallagher • Rolling Meadows, IL

5h

About The Position

The Business Intelligence Manager leads a team of developers responsible for designing, developing, deploying, and supporting enterprise reporting and business intelligence solutions using Power BI, SQL Server Reporting Services (SSRS), and SQL. This hands-on role combines people management, technical leadership, project delivery, development governance, and business partnership. The manager maintains strong technical expertise and participates in development, troubleshooting, solution design, and technical reviews when needed.

The role requires expertise in Power BI, SSRS, and SQL, along with an understanding of Azure, Power Platform, Snowflake, database architecture, Power BI architecture, and SSRS architecture. The ideal candidate understands emerging AI technologies and their application to business intelligence, analytics, reporting, and development productivity, and has experience using AI-enabled tools.

Requirements

• A university degree and a minimum of 5 years of prior relevant experience, or equivalent experience.
• Bachelor's degree in Computer Science, Information Systems, Business Intelligence, Data Analytics, or a related field.
• Experience in the insurance or risk management industry.
• 10+ years of experience developing enterprise business intelligence and reporting solutions using Power BI, SSRS, SQL, data warehouses, and data lakes.
• 5+ years of advanced Power BI experience, including DAX, semantic modeling, Power Query, Row Level Security (RLS), and report optimization.
• 5+ years of experience with enterprise data platforms, including SQL Server, Snowflake, and Azure Synapse.
• 5+ years of experience with development governance, source control, CI/CD, and deployment automation.
• 3+ years of experience leading or managing BI, reporting, analytics, or software development teams.
• 1–3 years of experience using AI-enabled tools and capabilities within reporting, analytics, software development, or business operations.
• Strong analytical, problem-solving, communication, and leadership skills.

Responsibilities

• Develop, troubleshoot, and support SSRS and Power BI solutions.
• Build and optimize SQL, DAX, and Power Query solutions, including complex queries and stored procedures.
• Assemble datasets and semantic models from SQL Server and Snowflake data warehouses.
• Keep Git source code repositories and product documentation updated and accurate.
• Conduct solution architecture reviews and code reviews.
• Oversee production support processes, incident management, root cause analysis, and continuous improvement initiatives.
• Collaborate with business analysts, project managers, contractors, and other technology teams supporting BI delivery.
• Build trusted relationships with business stakeholders and serve as a technical advisor for reporting and BI solutions.
• Manage deliverables and backlogs across multiple concurrent projects and communicate status, risks, and issues clearly.
• Lead, coach, and develop a team of Power BI and SSRS developers.
• Provide technical direction for report design, data retrieval, semantic modeling, SQL development, performance optimization, maintainability, and production support.
• Manage capacity, priorities, risks, and dependencies to ensure timely product delivery.

Benefits

• Competitive compensation
• Comprehensive benefits programs designed to support well-being
• Career development opportunities and ongoing learning
• A collaborative, people-first culture with accessible leadership
• The opportunity to do meaningful work with global reach and local impact

What This Job Offers

• Job Type: Full-time
• Career Level: Manager