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. Role specifics: Auto Liability and Complex Bodily Injury Claims and Litigation Management - Jurisdictions: Nationwide - Licenses: TX, FL, GA, NY - Location: This role is eligible for fully remote work. How you'll make an impact: - Apply claims management experience to execute decision-making to analyze claims exposure, plan the proper course of action, and appropriately resolve claims. - Interact extensively with various parties involved in the claim process to ensure effective communication and resolution. - Provide exceptional customer service to our claimants on behalf of our clients exhibiting empathy through each step of the claims process. - Handle claims consistent with clients' and corporate policies, procedures, and standard methodologies in accordance with statutory, regulatory, and ethics requirements. - Document and communicate claim activity timely and efficiently, supporting the outcome of the claim file. Qualifications - Claims Background: Auto Liability, Complex Bodily Injury experience, and Litigation Management. - Jurisdictional Experience: Nationwide. - Active Adjusters' licenses: TX, FL, GA. Requirements - High School Diploma. - Minimum of 3 years related claims experience. - Appropriate licensing and/or certification in all states in which claims are being handled. - Knowledge of accepted industry standards and practices. - Computer experience with related claims and business software. 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 complex SQL queries, views, stored procedures, and functions to support data transformation and reporting needs • Build, manage, and support SSIS-based ETL workflows to integrate data from multiple source systems • Develop and maintain Power BI Paginated Reports, including parameterized, scheduled, and distribution-ready outputs • Create interactive Power BI dashboards and reports, including data modeling, relationships, and advanced DAX calculations • Partner with business stakeholders to gather requirements and convert them into effective BI and reporting solutions • Ensure data accuracy, quality, and consistency across all BI assets • Optimize and tune SQL queries, ETL processes, and reports for performance and scalability • Maintain clear technical documentation, follow coding standards, and adhere to version control best practices • Participate in code reviews and contribute to continuous improvement of BI processes and standards

• The Business Intelligence Analyst designs, develops, tests, documents, maintains, and troubleshoots reports across a broad platform of Business Intelligence tools • Supports the full lifecycle of projects, particularly the requirements definitions, quality assurance testing, and user acceptance testing phases of projects • Responsible for the execution of full reporting lifecycle; from design, development, testing, documentation, maintenance, and troubleshooting • Complete work towards closing tickets, including triage, research, and communication with internal and external members • Develop and update technical documentation for reporting systems • Lead and drive requirement gathering meetings with experts in a variety of fields; defining systems scope and objectives of business requirements, including documentation of requirements (i.e. use cases) and relevant translation into system requirement specifications

Role Description The Business Intelligence Engineer is responsible for the development, maintenance, and adoption of business intelligence solutions. Responsibilities include: - Working with operational leaders to build dashboards and reports for data-driven decisions. - Serving as the primary technical resource for the business intelligence software stack. - Providing design and development deliverables. - Supporting existing analytics solutions. - Bringing a technical foundation to contribute immediately and a curiosity to expand skills as data needs evolve. This is a remote opportunity; however, the ideal candidate will live in or around the following metropolitan areas: - Dallas, TX - Salt Lake City, UT - Phoenix, AZ - Las Vegas, NV - Denver, CO Qualifications - 3-5 years of experience in a Business Intelligence, Data, Analyst, or similar role. - Proficiency in SQL with hands-on experience in a cloud data warehouse environment (Snowflake strongly preferred). - Experience with Python for data manipulation, scripting, and automation. - Familiarity with data integration/ETL tools (experience with Boomi/Rivery preferred). - Experience building dashboards and reports in a modern BI visualization tool (Sigma, Tableau, Power BI, Looker, etc.). - Strong ability to work independently, manage competing priorities, and communicate technical concepts to non-technical stakeholders. Requirements - Direct experience with Boomi, Snowflake, and Sigma in a production environment. - Experience working as a solo BI resource or in a small team environment. - Exposure to data governance, documentation, and roadmap planning. - Experience building reporting for the field services industry.