Business Intelligence Specialist Lead

Gallagher•Rolling Meadows, IL

3d•Hybrid

About The Position

We are seeking a Business Intelligence (BI) Specialist Lead to drive the design, development, and delivery of reporting solutions using Microsoft Power BI. This role combines hands-on development with team leadership, working closely with business stakeholders and clients to translate data into actionable insights. You’ll play a key role in managing reporting initiatives, ensuring data accuracy, and delivering high-quality BI solutions on time.

Requirements

Bachelor’s degree (preferred in Computer/Information Science or Business/Commerce)
Experience leading or supervising small teams of developers and QA analysts
3–5 years of hands-on experience developing Power BI reports and applications
Working knowledge of SQL, databases, and data retrieval concepts
Familiarity with HTML and web technologies
Strong verbal and written communication skills
Self-starter with a strong work ethic
Flexible and adaptable; able to manage both planned and unplanned work
Practical problem-solver with a focus on resolving issues
Collaborative, respectful communicator with strong facilitation skills
Comfortable working with senior leaders and external vendors
Able to work independently with minimal supervision and meet deadlines

Responsibilities

Develop, maintain, and enhance reports and dashboards using Microsoft Power BI
Perform ad hoc and recurring report analysis, design, and processing
Partner with business, client, and technical teams to gather and define requirements
Create clear functional and technical documentation and provide project status updates
Lead and supervise a small team of onshore/offshore developers and QA resources to ensure timely delivery
Monitor and ensure adherence to key Service Level Agreements (SLAs)
Conduct unit testing to validate report accuracy and data integrity
Provide training to business users and clients on BI tools and reporting solutions
Serve as a project coordinator on key client initiatives as needed

Benefits

Medical/dental/vision plans, which start from day one!
Life and accident insurance
401(K) and Roth options
Tax-advantaged accounts (HSA, FSA)
Educational expense reimbursement
Paid parental leave
Digital mental health services (Talkspace)
Flexible work hours (availability varies by office and job function)
Training programs
Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
Charitable matching gift program