ETL DEVELOPER — Zurich Insurance (sede Ticino)
- Location
- Lugano
- Contract
- full-time
- Posted
- 5 days ago
Role overview
ETL Developer
Zurich Capability Center is currently hiring a
In Zurich Capability Center we are looking for a highly skilled ETL Developer to join our data engineering team.
- ETL Developer
- Zurich Capability Center is currently hiring a:
- 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.
- Collaborate with cross-functional teams to gather data requirements and translate them into technical solutions. Technical Requirements:
Main responsibilities
- 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).
Key requirements
- Develop and optimize complex SQL queries and stored procedures for data extraction and transformation.
- Collaborate with cross-functional teams to gather data requirements and translate them into technical solutions. Technical Requirements:
- 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.).
Application process
- Enviar candidatura ahora
Contacts
- 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.
Company and context
- You will work closely with data architects, analysts, and DevOps to ensure robust and scalable data flows across the organization.
Additional details
- Ensure proper data governance, data quality, and documentation across all data flows. Technical Requirements
- Knowledge of data quality frameworks, error handling, and logging best practices.
- Knowledge of data cataloging and lineage tools (e.g., Collibra, Alation).
Notes and original content
- Ensure proper data governance, data quality, and documentation across all data flows.
- Technical Requirements
- Nice to Have
- What we offer
Questions about this listing
What salary does Zurich Insurance (sede Ticino) offer for this role?
Zurich Insurance (sede Ticino) lists CHF 51'500 - 88'000 gross per year for this position in Lugano. This is the salary published in the original listing (or, when the employer omits a figure, a realistic estimate for the role and sector) — the calculator on this site converts it to your actual net take-home once cross-border tax and social contributions are applied.
Is this a full-time role, and what type of contract does Zurich Insurance (sede Ticino) offer?
This listing is a full-time position. The contract type shown here comes directly from the employer's original posting; always confirm exact hours, notice period and probation length with Zurich Insurance (sede Ticino) during the application process, since these details can vary by role even within the same contract category.
Do I need the G permit to apply for this role in Ticino as an Italian cross-border worker?
Yes, if you are resident in Italy within the 20 km border zone. The Swiss employer files the G-permit application at the Ticino cantonal migration office after the contract is signed — first issuance takes 2-6 weeks, then automatic yearly renewal for as long as the employment continues. Weekly return to your Italian home is required to keep the status.
How do I apply for this position at Zurich Insurance (sede Ticino)?
Use the "Apply now" button on this page — it links directly to Zurich Insurance (sede Ticino)'s original listing at careers.zurich.com, so your application goes straight to the employer's own applicant-tracking system. Frontaliere Ticino does not collect or forward applications itself.
