Work in Illinois Manufacturing Jobs

Job Information

Gallagher ETL Developer 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.

Position Summary:

The ETL Developer will demonstrate broad and deep knowledge of ETL development in a dimensional database environment using the MS SQL Server Integration Services. You will be responsible for designing, developing, testing, and troubleshooting ETL packages to implement robust, maintainable solutions that meet business requirements.

Essential Duties and Responsibilities:

  • Solidifyand extend existing ETL SSIS Framework

  • Design ETLjobs and reusable components to implement specified business requirements

  • Troubleshoot and optimize ETL code; interpret ETL logs,perform data validation, dissect SSIS code, understand the benefits anddrawbacks of parallelism, proper use of expressions, scoping of variables,commonly used transforms, event handlers and logging providers, understand andoptimize the surrogate key generation and inconsistent data type handling

  • Createtechnical specifications documents and design process diagrams

  • Developfunctional specifications for data acquisition, transformation and loadprocesses

  • Developscripts for data file processing and process integration tasks

  • Definejob parameters, reference lookups, filter criteria

  • Conductcode reviews and participate in technical design

  • Conductperformance analysis and optimize SSIS jobs, custom SQL and T-SQL jobs


· 5 years of experience implementing ETL for Data Warehouse and Business intelligence solutions

· 5 years of experience in RDBMS design and development, and performance tuning

· Deep familiarity with MS SQL Server 2012 to SQL 2017/2019 database technologies

· 3 years with SSIS and T-SQL/ stored procedures

· Familiarity with .NET and C# framework is a plus

· Working experience with Python is a plus

· Skills to read and write effective, modular, dynamic, parameterized and robust code, establish and follow already established code standards, and ETL framework

· Experience using Visual Studio to build SSIS packages

· Excellent troubleshooting & optimization skills: interpreting ETL logs, performing data validation, dissecting SSIS code, understanding the benefits and drawbacks of parallelism, experience with CDC, using expressions, scoping of variables, commonly used transforms, event handlers and logging providers, ability to understand and optimize the surrogate key generation and inconsistent data type handling

· Experience in performance tuning of the SSIS packages, deploying and administering SSIS packages, proficient in utilizing scripting in SSIS

· Understanding SQL Server / External scheduling: abilities and limitations; ability to select the most optimal scheduling solution and call SSIS jobs from the command line or from the Scheduling tool locally / remotely

· Experience to design jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without modification

· Ability to create ETL specifications, unit, and system test cases

· Clear understanding of SSIS and ETL standards and best practices

· SSIS error handling, error propagation and email notification

· Understanding and troubleshooting SSIS issues and bugs until successful issue resolution

· Proficiency in reading, writing and performance tuning SQL and T-SQL

Work Traits:

· Excellent interpersonal and teamwork skills

U.S. Eligibility Requirements:

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

  • Must be 18 years ofage or older

  • Must be willing tosubmit to a background investigation; any offer of employment isconditioned upon the successful completion of a background investigation

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

  • Must be willing toexecute Gallagher's Employee Agreement or Confidentiality andNon-Disclosure Agreement, which require, among other things,post-employment obligations relating to non-solicitation, confidentialityand 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 equalemployment opportunity and does not discriminate against nor favor anyapplicant because of race, sex, color, disability, national origin, religion,creed, age, marital status, citizenship, veteran status, gender, genderidentity / expression, actual or perceived sexual orientation, or any otherprotected characteristic.​ Equal employment opportunity will be extended in allaspects 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 reasonableaccommodations to known physical or mental limitations of an otherwisequalified applicant with a disability, unless the accommodation would impose anundue hardship on the operation of our business. #LI-CJ

Job: Information Technology

Organization: Corp - Home Office

Title: ETL Developer

Location: Illinois-Rolling Meadows

Requisition ID: 64489