Role Description 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. Qualifications - High School Diploma - Minimum of 10 years related claims experience - Appropriately licensed and/or certified in all states in which claims are being handled - Knowledge of all team member related functions - Bachelor's Degree (Desired) Requirements - Supervise a liability claims team handling a variety of caseload sizes and complexities to deliver high-quality and efficient service. - Promote Best Practices: Guide claims team to handle claims in accordance with GB’s Best Practices. - Drive Talent: Take charge of adjuster hiring and training, encouraging a culture of performance and continuous improvement. - Manage Workloads: Define team goals, motivate performance, and effectively manage workloads to ensure optimal efficiency. - Utilize Technology: Harness the power of Gallagher's technology to enhance your team's efficiency and overall quality of service. - Client Communication: Communicate with clients, carriers, and brokers in a professional, positive, and proactive manner. - Prioritize and Develop: Effectively manage multiple competing priorities, identify coaching opportunities, and position team members for successful development. 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 - And more...

• Design, develop, and maintain Power BI reports, dashboards, and semantic models • Build and manage SSRS reports, subscriptions, and data-driven delivery solutions • Develop, maintain, and optimize SSIS packages for data integration and transformation • Support and evolve data warehouse architecture for scalability and performance • Optimize SQL Server performance through indexing strategies, query tuning, and maintenance • Encode business logic into AI-driven workflows and agent-based systems • Collaborate with AI and data teams for conversational BI interfaces • Own data quality, observability, and consistency across BI layers • Communicate technical trade-offs effectively to both technical and non-technical audiences

• Build end-to-end analytical models to evaluate customer lifecycle • Leverage outputs from ML models to drive predictive analytics and decision frameworks • Develop advanced segmentation models using clustering techniques and behavioral feature engineering • Perform deep funnel analysis using event-level data to identify inefficiencies and optimization opportunities • Design and evaluate experimentation frameworks with statistical rigor • Build data pipelines for analytics use cases using SQL and Python • Work with large datasets from multiple sources • Apply attribution modeling techniques to evaluate marketing performance • Translate complex datasets and model outputs into clear, commercially actionable insights • Automate recurring analyses and reporting using Python and workflow orchestration tools

Role Description Are you highly motivated and looking to build deep technical expertise through hands-on, real-world data engineering and analytics work? Our Business Intelligence team is seeking a highly technical intern to support a critical modernization initiative focused on migrating legacy SSRS reports to a cloud-based data lake and modern semantic models. This internship is designed for students who want to strengthen skills in data modeling, SQL development, report migration, and analytics architecture, rather than end-user reporting or business-facing analysis. The intern will work closely with experienced BI engineers on well-defined migration and design tasks that are critical to the scalability and future-state analytics platform. If you are excited about learning modern BI architecture and contributing to foundational technical initiatives, we encourage you to apply. A Day in the Life - Support the migration of legacy SSRS reports to a data lake-centric analytics architecture - Analyze existing SSRS report logic, stored procedures, datasets, and dependencies - Re-create report logic using SQL, data lake structures, and modern semantic models - Design and implement semantic layers (Power BI datasets, tabular models, or equivalent) optimized for reuse and performance - Assist with data model normalization, star schema design, and metric standardization - Validate migrated reports and datasets for data accuracy, performance, and completeness - Document source-to-target mappings, transformation logic, and modeling standards - Collaborate primarily with BI engineers and architects; limited to no direct business user interaction - Gain hands-on experience with enterprise BI modernization initiatives - Apply academic knowledge to large-scale, real-world data systems Qualifications - Undergraduate Junior, Senior, or Graduate status in Computer Science, Information Systems, Data Analytics, or related field - Strong interest in data engineering, analytics platforms, and BI architecture - Solid understanding of SQL, including joins, aggregations, and query optimization - Familiarity with relational data models and dimensional modeling concepts - Exposure to or interest in data lakes, analytics platforms, or cloud data services - Experience with Power BI, SSRS, or other reporting tools (academic or internship experience acceptable) - Strong analytical and problem-solving skills - A desire to work on focused, independent technical projects - Attention to detail and commitment to data quality and design best practices Responsibilities - Inventory and analyze existing SSRS reports, data sources, and queries - Translate report logic and calculations into data lake–based SQL models - Design and build semantic datasets to support modern reporting and analytics - Refactor complex SQL and reporting logic for performance and scalability - Support testing and validation of migrated datasets and reports - Create clear technical documentation for data models and migration decisions - Participate in a structured intern capstone project focused on BI modernization - Attend regular team check-ins to track progress and remove technical blockers Requirements - Undergraduate Junior, Senior, or Graduate Student; IT, Computer Science, Data, or Engineering majors preferred - Strong SQL and analytical skills - Basic understanding of data modeling and reporting concepts - Comfortable working independently with clearly defined technical tasks - Working knowledge of Microsoft Office Suite - Ability to document technical work clearly - Ability to manage time effectively and meet deadlines - Ability to work in a fast-paced technical environment