Work in Illinois Manufacturing Jobs

Job Information

Gallagher Senior Data Engineer in Rolling Meadows, Illinois

Gallagher is a global leader in insurance, risk management and consulting services. We help businesses grow, communities thrive and people prosper. We live a culture defined by The Gallagher Way, our set of shared values and guiding tenets. A culture driven by our people, over 30,000 strong, serving our clients with customized solutions that will protect them and fuel their futures.

Gallagher Benefit Services, Inc. (GBS) , a division of Gallagher , consistently stands out in a competitive marketplace as an employer of knowledgeable, highly skilled and competitive talent. We are a company that touches businesses and their employees on a personal level. At the core, our job is to help protect the health and well-being of employees and their families and provide for their financial security—all while allowing employers to attract and retain the people they need to grow and succeed. As you consider the value of working for our team, remember our talent, winning attitude and strong performance will be highly valued and will maximize your future potential

Position Summary:

As a Sr. Data Engineer you will be a key member of the GBS IT Data and Analytics team.. This role will be proficient in investigating, transforming, and combining data of different data sources and types.

Ideal candidates are prepared to design appropriate solutions to support business data needs and create consumable analysis-ready data sets. The Sr. Data Engineer will educate business partners on the use and sources of data. They will identify and explore new data sources and be primarily focused on developing integration processes between systems. The role function involves the processing, planning and organization of the data as well as supporting data load and integration services to ensure efficient and effective business operations while establishing and enforcing standards and procedures.

Essential Duties and Responsibilities:

  • Creates and maintains optimal data pipeline architecture for extraction, transformation, and loading of data from various data sources – both internal and external

  • Assembles large, complex sets of data that meet non-functional and functional business requirements

  • Builds industrialized analytic datasets and delivery mechanisms that utilize the data pipeline to deliver actionable insights

  • Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc .

  • Investigates data, data sources and performs data quality analysis

  • Communicates and maintains master data, metadata, data management repositories, logical data models, data standards

  • Collaborates with engineers to help adopt best practices in data system creation, data integrity, test design, analysis, validation, and documentation

  • Works with stakeholders including the executive, product, data and technology teams to support their data infrastructure needs while assisting with data-related technical issues

  • With minimal direction, plans, implements, manages, and/or contributes on projects that are moderate to high complexity and scale using accepted project management standards

  • Trains/coaches team members or peers and actively shares expertise with peers


  • Bachelor’s degree (IT or Business related discipline)

  • 5 years related experience.

  • Hands-on experience integration technologies such as SQL Server Integration Services, Azure Data Factory, Azure Logic Apps, Azure Integration Services or similar technologies

  • Experienced in integrating data to/from Microsoft SQL Server, Salesforce, Dynamics CRM, Dynamics 365, Azure SQL, Azure SQL DW

  • Working knowledge of analytical tools like Power BI

  • Mastery of relational SQL and NoSQL databases

  • Experienced with data pipeline and workflow management tools

  • Experienced with data wrangling and preparation for use within data science, business intelligence or similar analytical workflows

  • Strong written and verbal communication skills including the ability to effectively collaborate with multi-disciplinary groups and all organizational levels

  • High level organizational and project management skills in order to handle multiple concurrent assignments in a timely manner and to monitor processes throughout a team or department

  • Strong decision-making skills

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: GBS - Operations

Title: Senior Data Engineer

Location: Illinois-Rolling Meadows

Requisition ID: 67630