• Develop creative business intelligence solutions using SQL, views, and stored procedures • Develop reports, dashboards, and custom files for internal/external clients • Develop routines for data summarizations, queries, data cubes, and data reporting templates • Develop production tasks and processes within the Business Intelligence Department in a mortgage servicing space • Develop scalable processes to generate reports, files, dashboards, and data cubes according to business requirements • Develop and manage process-driven solutions using Windows and Microsoft SQL Server environment • Develop queries, reports, files, dashboards, etc., using Microsoft Windows and Microsoft SQL Server environment • Develop and maintain scalable BI process using queries, reports, files, data marts, dashboards, etc. • Develop and maintain automated production environment using stored procedures • Collaborate with other developers to create/maintain scalable processes and best practices • Collaborate with other departments on timing and details of the development cycle • Ensure quality control best practices are followed • Ensure seamless and scalable BI development lifecycle is followed • Make recommendations and develop best practices for BI presentation layers, such as stand-alone reports, dashboards, and self-service/drill through tools • Manage/balance workload; monitor/manage efficiency and timeliness of deliveries • Work with other departments on Business Intelligence needs and improvements • All other duties as assigned

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