Information Technology
45127 Requisition #
Share this Job

Arthur J. Gallagher & Co., one of the world's largest insurance brokerage and risk management services firms, provides a full range of retail and wholesale property/casualty (P/C) brokerage and alternative risk transfer services globally, as well as employee benefit brokerage, consulting and actuarial services. Gallagher also offers claims and information management, risk control consulting and appraisal services to clients around the world. If you're looking for a professional career with an industry leader then you have come to the right place.  Wherever your interests lie, we're sure you will agree on one thing: our continued prosperity hinges on our greatest resource --- our people.


The candidate must demonstrate broad knowledge of ETL development in a dimensional database environment while using MS SQL Server SSIS.  Candidate will be responsible for designing, developing, testing and troubleshooting SSIS packages that implement complex ETL processes.  The candidate must possess good communication skills and be able to work with business partners to understand and analyze requirements. The developer will use their MS SQL Server experience (2012 and later) to implement robust, maintainable solutions that meet business requirements.

Job Responsibilities:

  • Design, development, and testing of MS SQL Server SSIS jobs, and reusable components to implement specified business requirements
  • Develop scripts for data file processing and process integration tasks.
  • Troubleshoot and optimize new and existing ETL packages
  • Create technical specification documents and design process diagrams
  • Develop functional specifications for data acquisition, transformation and load processes
  • Conduct code reviews and participate in technical design
  • Prepare unit test, integration test plan documents and perform unit test, system integration test; document test results
  • Support BI Team during functional, UAT, regression, and performance testing

  • Bachelor's degree and 8 years related experience required.


  • Degree major in Computer Science or related field.


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, color, religion, sex, age, veteran status, disability, national origin, or any other legally protected status.  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 try again.


Either there was a problem on our end with the action you just performed, or we are currently having technical difficulties with our system. Please try again later.