Data Integration Specialist

Information Technology
69362 Requisition #

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.


Position Summary:


The Data Integration Specialist is responsible for participating in the design and coordination of various data integration processes across multiple functional areas and business lines. The position acts as liaison with the business, and translates internal and external business requirements into technical specifications that are then developed. This role also serves as primary initial responder in identifying issues, troubleshooting/correlating issues, assessing impact, and coordinating resolution, and engaging resolution groups for troubleshooting; drives efficient resolution of issues. 


Essential duties include:


  • Troubleshoot errors in data integrations and processes (batch file and API)
    • Engage resolution groups for troubleshooting
    • Quantify scope and impact of identified issues
    • Ensure issues and resolution are tracked through ticket system
    • Thoroughly documents proposed solutions and identified issues
  • Modify or create data integration configurations to support business needs
  • Derives requirements and specifications from business needs and coordinates the technical solution and timing of delivery of the solution with development resources
  • Coordinate with multiple teams to deploy new or changed systems to the production environment according to documented change management procedures
  • Maintain up-to-date documentation including tracking logs, data integration mapping documents, and training materials for new solutions or changes to existing solutions
  • Execute some routine tasks on regular basis, which can include data imports and executing SSIS packages, also provides support for the Data Operations coordinators during peak times




  • High School Diploma 
  • 3 or more years related experience required
  • Technical aptitude and troubleshooting skills a must
  • Experience with various data integration methods and software (Adeptia preferred)
  • Microsoft SQL. Data manipulation, data integration design and development including T-SQL
  • Experience with troubleshooting API data integrations using Postman or similar tools
  • Proficiency with Microsoft Office Professional
  • Capability to work from home (Requires Internet connection).



  • Familiarity with data security best practices
  • Ability to translate technical information into business language
  • Experience in working with off-shore resources in various functions and capacities
  • Experience in a NOC or IT operations environment a plus


Work Traits: 

  • Demonstrated strong analytical problem solving skills
  • Proven ability to assimilate business concepts quickly and communicate those via written, graphical, and oral means to technical teams
  • Outstanding communication/interpersonal skills and ability to interact with all levels of an organization to resolve an issue
  • Able to work in a team environment
  • Ability to work effectively in a fast-paced environment
  • Actively seeks out tasks that help develop skills, knowledge, and maturity of data operations


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 require, 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.





Please Note:

Gallagher never extends an offer of employment or requests any personal identification information without having received an online application and conducted one or more in-person or video interviews. If you have received any communication referencing the offer of a job at Gallagher and you have not submitted an online application or been interviewed by a Gallagher employee, please do not assume that the offer is being sent from a legitimate Gallagher representative.

Similar Listings

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71421

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71320

Rolling Meadows, Illinois, United States

📁 Information Technology

Requisition #: 71531