Data Engineer I

Data Engineer I

123395

Zurich is currently looking for a Data Engineer to work out of our North American Headquarters in Schaumburg, IL.

This position will be part of an Enterprise Data Management Team that will be responsible for leveraging the value of the data assets throughout the organization and will facilitate the development/implementation of the desired end-state data environment. The Enterprise Data Management Team will also be responsible for improving the organization's decision-making capabilities by providing high quality, transparent data within the data warehouse and associated data marts.

The talented Data Engineer/ETL Developer will have experience working with very large data sets, designing, developing and debugging Informatica processes that populate Data warehouses on (MPP) platforms. The ETL Developer will also have good knowledge of Big Data technologies and cloud native data tools with the ability to share ideas among a collaborative team.

In this role, she/he will participate on core teams identifying and validating data scenarios within the Enterprise. The candidate will need to demonstrate the ability to develop actionable plans, recognize opportunities and be able to report out on on-going progress. This role will require technical documentation abilities and team coordination skills.

Basic Qualifications:

• Bachelors Degree in Computer Science or Mathematics/Statistics and 4 or more years of experience in the Data Engineering area

OR

• High School Diploma or Equivalent and 6 or more years of experience in the Data Engineering area

OR

• Zurich Certified Insurance Apprentice including an Associate Degree in Computer Science or Mathematics/Statistics and 4 or more years of experience in the Data Engineering area

AND

• 3 or more years of experience in Data Management

• Experience with ETL Architecture, ETL Design and End-to-End ETL Development work

• Experience in scripting languages

• Experience with data transformation and aggregation tools

• Experience in data analysis, data interrogation or data profiling

• Strong understanding of data warehousing including data structures/modeling concepts

Skillset Needs:

• Experience with Informatica PowerCenter

• Experience with processing large datasets on MPP platforms like Yellowbrick, Netezza

• Strong SQL and stored procedures skills

• Experience in scripting languages including Shell and Perl

• Experience in job scheduling tools like AutoSys

• Exposure to reporting tools preferably Business Objects, Power BI

• Exposure to Azure Cloud Platform and Cloud Data Services like Azure Data Factory, Databricks

• Exposure to cloud monitoring tools like Splunk, Grafana

• Strong verbal and written communication skills

• Ability to work independently and interact effectively with business as part of a team

• Exposure to Insurance Domain knowledge

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 clickhere . 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 compensation 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 85,500-140,000, with short-term incentive bonus eligibility set at 10%.

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 clickhere 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 - Illinois Virtual Office

Remote Working: Yes

Schedule: Full Time

Employment Sponsorship Offered: Yes

Linkedin Recruiter Tag:

EOE Disability / Veterans