ETL Developer

Required:

·       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 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.  #LI-CJ