Develop, troubleshoot, and support SSRS and Power BI reporting solutions
Build and optimize SQL, DAX, and Power Query solutions and stored procedures
Assemble datasets and semantic models from SQL Server and Snowflake
Lead, coach, and develop a team of Power BI and SSRS developers
Oversee production support, incident management, and root cause analysis
From the employer’s posting
Develop, troubleshoot, and support SQL Server Reporting Services (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.
Lead, coach, and develop a team of Power BI and SSRS developers.
Oversee production support processes, incident management, root cause analysis, and continuous improvement initiatives.
Before you apply
Employer’s visa record
1 H-1B petition approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
SQL
Azure
Power BI
Power Query
Snowflake
SQL Server
SSRS
Where the posting names them
How you'll make an impact 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.
The role requires deep expertise in Power BI, SSRS, and SQL, along with a strong understanding of Azure, Power Platform, Snowflake, database architecture, Power BI architecture, and SSRS architecture.
Technical Delivery · Develop, troubleshoot, and support SQL Server Reporting Services (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.
· Provide technical direction for report design, data retrieval, semantic modeling, SQL development, performance optimization, maintainability, and production support.
10+ years of experience developing enterprise business intelligence and reporting solutions using Power BI, SSRS, SQL, data warehouses, and data lakes.
5+ years of experience working with enterprise data platforms, including SQL Server, Snowflake, and Azure Synapse.
People Leadership · Lead, coach, and develop a team of Power BI and SSRS developers.
5+ years of advanced experience with Power BI, including DAX, semantic modeling, Power Query, Row Level Security (RLS) and report optimization.
Introduction At Gallagher Bassett, we're there when it matters most because helping people through challenging moments is more than just our job, it’s our purpose. Every day, we help clients navigate complexity, support recovery, and deliver outcomes that make a real difference in people’s lives. It takes empathy, precision, and a strong sense of partnership—and that’s exactly what you’ll find here. We’re a team of fast-paced fixers, empathetic experts, and outcomes drivers — people who care deeply about doing the right thing and doing it well. Whether you're managing claims, supporting clients, or improving processes, you’ll play a vital role in helping businesses and individuals move forward with confidence. Here, you’ll be supported by a culture that values teamwork, encourages curiosity, and celebrates the impact of your work. Because when you’re here, you’re part of something bigger. You’re part of a team that shows up, stands together, and leads with purpose. How you'll make an impact 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 is a hands-on role that combines people management, technical leadership, project delivery, development governance, and business partnership. The manager is expected to maintain strong technical expertise and to personally participate in development, troubleshooting, solution design, and technical reviews when needed. The role requires deep expertise in Power BI, SSRS, and SQL, along with a strong 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, with experience leveraging AI-enabled tools Key Responsibilities 1. Technical Delivery · Develop, troubleshoot, and support SQL Server Reporting Services (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. 2. Stakeholder Collaboration & Communication · 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. 3. People Leadership · 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. About You Required: Typically requires a University Degree and minimum 5 years 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 experience with Power BI, including DAX, semantic modeling, Power Query, Row Level Security (RLS) and report optimization. 5+ years of experience working 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 utilizing AI-enabled tools and capabilities within reporting, analytics, software development, or business operations. Strong analytical, problem-solving, communication, and leadership skills. Compensation and benefits At Gallagher, we believe supporting our colleagues goes far beyond the role itself. For more information, visit our Benefits page. Competitive compensation Comprehensive benefits programs designed to support your 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 At Gallagher, we are dedicated to building an inclusive and authentic workplace. If your past experience doesn’t align perfectly, we encourage you to join our Talent Community to stay connected to additional career opportunities. At times, we will consider transferable skills from previous roles. Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)
About Gallagher
People
About 72,000 in 2025, up 29% from the year before.Annual report (SEC Form 10-K)
Company
Listed as AJG.
Demand for Data Leadership roles
New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Leadership, by the work the posting describes.
Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.
Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.
Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.
US government figures for computer and information systems managers
Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs
The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.