*Data Engineer II

Zurich Australian Insurance Ltd.; Schaumburg (IL); Remote; USD 156,000; Full time

Job summary

An established industry player is seeking a skilled Data Engineer II to join their dynamic team. This full-time position involves modernizing systems applications, developing ETL processes, and fine-tuning SQL queries to enhance performance. You'll have the opportunity to work with cutting-edge technologies and collaborate with diverse teams. With a strong commitment to diversity and inclusion, this company encourages candidates from all backgrounds to apply. If you are passionate about data engineering and looking to make a significant impact, this role offers a fantastic opportunity to advance your career.

Benefits

Comprehensive benefits

Diversity and inclusion initiatives

Qualifications

• 7+ years in a similar role focusing on ETL and data engineering.
• Strong experience with SQL tuning and performance optimization.

Responsibilities

• Develop ETL processes and manage offshore/onshore teams.
• Analyze technical specifications and create design documents.

Skills

Informatica Power Center

SQL

Python

Shell Scripting

ETL Design

Education

Bachelor's in Computer Science

Bachelor's in Computer Engineering

Tools

Informatica Cloud

Netezza

AutoSys

Databricks

DBT

Job description

Press Tab to Move to Skip to Content Link

Job Title: 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:

1. Understand the requirement documents and clarify with Business Analysts.
2. Analyze technical specifications and create detailed design documents.
3. Develop ETL using Informatica, Shell scripts using Linux as per business specifications.
4. Manage offshore and onshore teams for development and system unit testing.
5. Debug issues and communicate effectively with customers for resolution.
6. Analyze UAT issues and provide immediate resolutions.
7. Fine-tune SQL queries to improve performance.
8. Participate in release/production handover meetings and adhere to processes.
9. Support production deployment and communicate with customers for signoffs.

Option to work remotely is available.

Qualifications:

• Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or a related field.
• 7 years of experience in a similar role, including designing and developing using Informatica Power Center.
• Experience with designing ETL mappings and workflows, implementing ETL processes, and tuning SQL queries.
• Proficiency with programming languages including Python, Shell scripting, SQL, and PL/SQL.
• Experience with database platforms like Netezza, job scheduling tools like AutoSys, and cloud technologies such as Informatica Cloud, Yellow Brick, Databricks, and DBT.

Full-time position. Apply at Zurichna.com/en/careers, Job ID: 123214.

Additional Information:

Salary range: $155,225. Zurich offers comprehensive benefits and a commitment to diversity and inclusion. We encourage candidates to apply regardless of salary expectations beyond the stated range.

Zurich is an equal opportunity employer and complies with all applicable laws.