ETL DEVELOPER

#ZCC 

Zurich Capability Center is currently hiring a:

ETL Developer

In Zurich Capability Center we are looking for a highly skilled ETL Developer to join our data engineering team. The ideal candidate will be responsible for building and optimizing data pipelines, integrating data from various sources, and ensuring the delivery of clean, structured, and timely data to support business intelligence and analytics initiatives. You will work closely with data architects, analysts, and DevOps to ensure robust and scalable data flows across the organization.

Key Responsibilities:

•Design, implement, and maintain robust ETL workflows for data ingestion, transformation, and loading into data warehouses and analytical platforms.

•Develop and optimize complex SQL queries and stored procedures for data extraction and transformation.

•Integrate data from APIs, relational databases, flat files, and cloud-based sources.

•Monitor, troubleshoot, and tune ETL jobs for performance and reliability.

•Collaborate with cross-functional teams to gather data requirements and translate them into technical solutions.

•Perform root cause analysis on data issues and implement corrective actions.

•Ensure proper data governance, data quality, and documentation across all data flows.

Technical Requirements:

•7 years of hands-on experience in ETL development using tools such as Informatica, Talend, SSIS, Apache NiFi, or similar.

•Advanced knowledge of SQL (CTEs, window functions, joins, performance tuning).

•Strong experience working with relational databases (PostgreSQL, SQL Server, Oracle, MySQL).

•Experience designing data pipelines for cloud platforms (Azure Data Factory, AWS Glue, GCP Dataflow, etc.).

•Familiarity with version control systems (Git), CI/CD practices, and Agile development methodologies.

•             Solid understanding of data warehousing concepts (star/snowflake schema, slowly changing dimensions, surrogate keys, etc.).

•Knowledge of data quality frameworks, error handling, and logging best practices.

Nice to Have:

•Advanced English (C1) – must be able to communicate effectively in daily stand-ups, technical discussions, documentation, and client meetings

Programming experience with Python or Scala for data processing and scripting.

•Familiarity with Apache Airflow or similar orchestration tools.

•Exposure to Big Data technologies (Spark, Hive, HDFS).

•Experience with containerization (Docker) and deployment in Kubernetes environments.

•Knowledge of data cataloging and lineage tools (e.g., Collibra, Alation).

If you are interested, please apply directly through this link or send your CV to nathalia.huerta@mx.zurich.com.

Position available only for candidates located in Mexico City, State of Mexico, or Guadalajara. Please apply only if you reside in one of these areas.

Who we are 

Looking for a challenging and inspiring work environment where you can make a difference? At Zurich millions of individuals and businesses place their trust in our products and services every day. Our 53,000 employees worldwide form the basis of our success, enabling, businesses and communities to face a world of risk with confidence. Imagine if you could help people do this all over the world. You’d give them confidence and reassurance by protecting what they love most. It’s a big challenge, but you will be supported by a world-class team who believe in helping you to reach your full potential and deliver on our promises. 

So be challenged. Be inspired. Help us make a difference. 

At Zurich we are an equal opportunity employer. We attract and retain the best qualified individuals available, without regard to race/ethnicity, religion, gender, sexual orientation, age, or disability.