ETL LEAD DEVELOPER

Zurich 56 Company Ltd; Ciudad de México; Presencial; MXN 1,126,000 - 1,503,000; Jornada completa

Descripción de la vacante

A leading global insurance company in Mexico is looking for an ETL Lead Developer. This role entails developing and implementing ETL processes, collaborating with teams for data validation, and leveraging extensive experience in Data Engineering. Ideal candidates will have a strong background in data management, be proficient in ETL architecture, and possess excellent communication skills. Join us to contribute to enhancing decision-making through high-quality data.

Servicios

Diversity and inclusion initiatives

Employee support programs

Formación

• 6+ years of experience in Data Engineering or related field.
• Strong knowledge of data transformation and aggregation.
• Experience in processing large datasets on MPP platforms.

Responsabilidades

• Develop and implement ETL processes to manage data.
• Collaborate with teams to validate data scenarios.
• Provide technical documentation for processes.

Conocimientos

Data Engineering

ETL architecture

SQL skills

Scripting languages

Communication skills

Educación

Bachelor's Degree in Computer Science or Mathematics/Statistics

High School Diploma and 8+ years of Data Engineering experience

Zurich Certified Insurance Apprentice with an Associate Degree

Herramientas

Informatica PowerCenter

Data transformation tools

Job scheduling tools like AutoSys

Replication tools like Attunity

Descripción del empleo

Zurich Capability Center is currently looking for an ETL Lead Developer.

This position will be part of an Enterprise Data Management Team responsible for leveraging data assets across the organization and facilitating the development and implementation of the desired end-state data environment. The team aims to improve decision-making by providing high-quality, transparent data within the data warehouse and data marts.

The Data Engineer will have experience working with large data sets, designing, developing, and debugging Informatica processes that populate Data warehouses on (MPP) platforms. Knowledge of Big Data technologies and tools is essential, along with the ability to collaborate effectively within a team.

The role involves participating in core teams to identify and validate data scenarios within the Enterprise. The candidate should be capable of developing actionable plans, recognizing opportunities, and reporting progress. Technical documentation and team coordination skills are required.

Client Focus: The role primarily involves delivering services to internal clients, such as line managers or employees, and may include sharing subject matter expertise or supporting others in their tasks.

Basic Qualifications:

• Bachelor's Degree in Computer Science or Mathematics/Statistics with 6+ years of Data Engineering experience
• OR High School Diploma and 8+ years of Data Engineering experience
• OR Zurich Certified Insurance Apprentice with an Associate Degree and 6+ years of Data Engineering experience

AND

• 7+ years of experience in Enterprise Data Management
• Experience with ETL architecture, design, and end-to-end development
• Proficiency in scripting languages
• Experience with data transformation and aggregation tools
• Experience in data analysis, interrogation, or profiling

Preferred Qualifications:

• Experience with Informatica PowerCenter
• Experience processing large datasets on MPP platforms
• Strong SQL and stored procedures skills
• Scripting experience including Shell and Perl
• Experience with replication tools like Attunity
• Exposure to job scheduling tools such as AutoSys
• Experience with DevOps practices
• Excellent communication skills
• Ability to work independently and within a team
• Insurance industry experience

About Us:

At Zurich, we offer a challenging and inspiring environment where you can make a difference. With 53,000 employees worldwide, we support businesses and communities in managing risk confidently. Join us to help protect what matters most and reach your full potential with our supportive, world-class team.

We are an equal opportunity employer committed to diversity and inclusion, welcoming applicants regardless of race, ethnicity, religion, gender, sexual orientation, age, or disability.