Work in Illinois Manufacturing Jobs

Job Information

Gallagher Senior Applications Specialist in Rolling Meadows, Illinois

Gallagher Bassett is the premier provider of global claims services, dedicated to exceptional customer service and demonstrably superior outcomes. GB helps people, teams and businesses overcome adversity and loss through the guiding expertise of over 5,000 claims professionals, all committed to going beyond expectations in the continuous pursuit of a better way.

Senior Data Integration Solution Engineer Position Summary

The Senior Data Integration Solution developers provides guidance, leadership, and solid execution of data integration solutions as they related to BI and AI project initiatives. Typically this role participates on multiple, technically complex, mission-critical, and/or high-profile data projects or initiatives. This individual must possess strong leadership skills including the ability to make sound data architectural solutions recommendations.

This role provides design and software development f will be responsible for developing and supporting various data ingestion, data extraction, business intelligence (BI) data solutions. This role requires a strong understanding of data integration concepts, processes and methodologies.

Who we are

Gallagher Bassett is a for-profit company with a positive social impact. We help injured workers get back to health (and back to work) faster, cheaper, and with less administrative burden. In broader terms, we’re a company of experts navigating the complex world of claims management so that our clients can focus on their own businesses. GB has over 4,000 employees, with operations in the US, Canada, UK, and Australia.


  • Competitive salary and benefits

  • Fun and flexible work environment

  • Apprenticeship model with significant development opportunities and emphasis on professional growth

  • Challenging, thought-provoking work on high-performing team with significant impact to the organization


  • The candidate must be highly proficient and experienced at designing, implementing, and supporting ETL solutions data warehouse environment

  • As a senior team member, the senior data engineer will assume lead roles in the design and development of data integrations, oversee the work of junior developers, and participate in the strategic planning around future development of the Gal data environment.

  • Ensures acceptable levels of system performance, integrity and security

  • Must be able to handle multiple highly complex projects concurrently and collaboratively.

  • Provide operational production support and flexible to manage high severity incidents/problem resolution during off business hours.

  • Collaborate with functional group leaders and engineering team(s) to gather and analyze data requirement needs.

Preferred qualifications to be successful in this role:

  • You are a strong communicator and an active listener.

  • A passion for technology

  • Deep technical understanding of all things data

  • Ability to lead a project team

  • Ability to paint a technology vision and communicate its value

  • Ability to create detailed estimates for planned technology activities.

  • A disciplined approach to your work life and your craft

Job Qualifications:

The following technologies are important to us. Although we understand your level of experience may vary in certain areas, you will be expected to be advanced in a number of these areas:

  • Azure: Azure Data Warehouse, Azure SQL database, Azure Data Factory

  • Microsoft: SQL Server, T-SQL, SSIS

  • Others: Octopus, DevOps

  • 3 years of progressive experience as senior data engineer with current and emerging data technologies and approaches. 2 of them on the Microsoft platform.

  • Minimum 7 years of experience in designing and building large applications utilizing SQL Server Solid understanding of Azure DW, Azure SQL database, Microsoft SQL Server and other Data base technologies. Including knowledge of physical/cloud database design.

  • Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle.

  • A sound knowledge of both database and program code performance tuning.

  • Sound communication skills with management, development teams, vendors, systems administrators and other related service providers


  • Bachelor's degree and 5 years related experience or an equivalent combination of education, training, and experience is required.

  • Competent to work at the highest technical level of all phases of applications systems analysis and programming activities.

U.S. Eligibility Requirements:

  • Interested candidates must submit an application and resume/CV online to be considered

  • Must be 18 years of age or older

  • Must be willing to submit to a background investigation; any offer of employment is conditioned upon the successful completion of a background investigation

  • Must have unrestricted work authorization to work in the United States. For U.S. employment opportunities, Gallagher hires U.S. citizens, permanent residents, asylees, refugees, and temporary residents. Temporary residence does not include those with non-immigrant work authorization (F, J, H or L visas), such as students in practical training status. Exceptions to these requirements will be determined based on shortage of qualified candidates with a particular skill. Gallagher will require proof of work authorization

  • Must be willing to execute Gallagher's Employee Agreement or Confidentiality and Non-Disclosure Agreement which requires, among other things, post-employment obligations relating to non-solicitation, confidentiality and non-disclosure

Gallagher offers competitive salaries and benefits, including: medical/dental/vision plans, life and accident insurance, 401(K), employee stock purchase plan, educational expense reimbursement, employee assistance program, flexible work hours (availability varies by office and job function) training programs, matching gift program, and more.

Gallagher believes that all persons are entitled to equal employment opportunity and does not discriminate against nor favor any applicant because of race, sex, color, disability, national origin, religion, creed, age, marital status, citizenship, veteran status, gender, gender identity / expression, actual or perceived sexual orientation, or any other protected characteristic.​ Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified applicant with a disability, unless the accommodation would impose an undue hardship on the operation of our business.

Job: Information Technology

Organization: GB US Operations

Title: Senior Applications Specialist

Location: Illinois-Rolling Meadows

Requisition ID: 64318