*Data Engineer II

Zurich (Schaumburg, IL) seeks a Data Engineer II to work with SAP and actuary applications and the reporting warehouse to transfer to more modernized systems applications. Specific duties include: understand the requirement documents and get it clarified with Business analysts; analyze the technical specification and create detailed design documents; develop ETL using Informaitca, Shell scripts using Linux as per the business specification documents; manage the offshore and onshore teams for completion of development and system unit testing; debug the issues and effectively communicate with customers for resolution; analyze the UAT issues/new scenarios and provide immediate resolution to the customers; fine tune of SQL queries to improve the performance; participate in release/Production handover meetings and adhere to the process; and participate in production deployment support and necessary communication with customers for signoffs. Option to work remotely is available.

Position requires a Bachelor’s degree, or foreign equivalent, in Computer Science, Computer Engineering, or a closely related field of study, plus 7 years of experience in the job offered, or as a Manager, Senior Consultant, Senior Project Engineer, Project Engineer, or similar position working with various applications and transferring to more modernized systems applications. Must have 7 years of experience designing and developing using Informatica Power Center. Specific experience must also include: designing ETL mappings and workflows using Informatica; implementing ETL process using Informatica Power Center and Informatica Power Exchange; optimizing and tuning the Mappings and Sessions in Informatica; working with programming languages including Python, Shell scripting, SQL, and PL/SQL; working with database platform Netezza; developing a data profiling process; working with job scheduling tool AutoSys; working with cloud technologies including Informatica cloud, Yellow brick, and Databricks; and working with cloud ELT technology DBT. Option to work remotely is available.

Full time position. Apply by submitting your resumes at Zurichna.com/en/careers, Job ID: 123214

At Zurich, compensation for roles is influenced by a variety of factors, including but not limited to the specific office location, role, skill set, and level of experience. In compliance with local laws, Zurich commits to providing a fair and reasonable compensation range for each role. For more information about our Total Rewards, please click here. Additional rewards may encompass short-term incentive bonuses and merit increases. We encourage candidates with salary expectations beyond the provided range to apply, as they will be considered based on their experience, skills, and education. The salary indicated represents a nationwide market range and has not been adjusted for geographic differentials pertaining to the location where the position may be filled. The proposed salary range for this position is $155,225.

As an insurance company, Zurich is subject to 18 U.S. Code § 1033.

A future with Zurich. What can go right when you apply at Zurich?

Now is the time to move forward and make a difference. At Zurich, we want you to share your unique perspectives, experiences and ideas so we can grow and drive sustainable change together. As part of a leading global organization, Zurich North America has over 150 years of experience managing risk and supporting resilience. Today, Zurich North America is a leading provider of commercial property-casualty insurance solutions and a wide range of risk management products and services for businesses and individuals. We serve more than 25 industries, from agriculture to technology, and we insure 90% of the Fortune 500®. Our growth strategy is not limited to our business. As an employer, we strive to provide ongoing career development opportunities, and we foster an environment where voices are diverse, behaviors are inclusive, actions drive equity, and our people feel a sense of belonging. Be a part of the next evolution of the insurance industry. Join us in building a brighter future for our colleagues, our customers and the communities we serve. Zurich maintains a comprehensive employee benefits package for employees as well as eligible dependents and competitive compensation. Please click here to learn more.

Zurich in North America is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race/ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status. 

Zurich does not accept unsolicited resumes from search firms or employment agencies. Any unsolicited resume will become the property of Zurich American Insurance. If you are a preferred vendor, please use our Recruiting Agency Portal for resume submission. 

Location(s): AM - Schaumburg
Remote Working: Yes
Schedule: Full Time
Employment Sponsorship Offered: No  
 
Linkedin Recruiter Tag: #LI-DNI and #NAAIA