Gallagher ETL Developer in Rolling Meadows, Illinois
Arthur J. Gallagher & Co. at http://www.ajg.com/ , 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.
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 anddesign process diagrams
Develop functional specifications for dataacquisition, transformation and load processes
Conduct code reviews and participate intechnical design
Prepare unit test, integration test plandocuments 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.
Job: Information Technology
Organization: Corp - Home Office
Title: ETL Developer
Location: Illinois-Rolling Meadows
Requisition ID: 45127