Business Intelligence Intern

Gallagher • Rolling Meadows, IL

8d

About The Position

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.

Overview

We are seeking a Data Engineer Intern who will participate in and contribute to project and operational work under the guidance of experienced IT professionals. This role is ideal for individuals beginning their careers and eager to build strong technical, analytical, and communication skills in a professional environment.

Requirements

• Basic knowledge of SQL for querying, transforming, and analyzing data
• Experience with Python for scripting, automation, or data processing
• Understanding of ETL concepts, data warehousing, or data pipeline workflows (coursework or academic projects acceptable)
• Familiarity with version control tools such as Git
• Familiarity with AI assisted coding tools
• Strong written and verbal communication skills

Nice To Haves

• Currently pursuing a Bachelor’s degree in Computer Science, Information Systems, Data Science, Business Analytics, or a related field
• Exposure to cloud technologies (Azure, AWS, or GCP) through coursework or projects
• Understanding of data modeling concepts or relational database design, data engineering

Responsibilities

• Develop and modify SQL queries to for data exploration, transformation, and analysis
• Use Python and Azure Data Factory to automate workflows and perform analytical tasks
• Use AI assisted tools like GitHub Copilot to help with software development
• Participate in data quality checks, validation processes, and troubleshooting

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

What This Job Offers

• Career Level: Intern