Key skills
AirflowAWSAzureCloudETLPythonSQLSSISData EngineeringAnalyticsdbtS3Cloud StorageMentoringCommunicationRemote Work
About this role
Role Overview
- Maintain and enhance ETL pipelines across 123 SSIS jobs spanning 8 data domains
- Manage data ingestion from diverse sources including S3, Azure Blob, SFTP, APIs, and manual/fragile integrations
- Investigate, debug, and resolve pipeline failures in a live production environment
- Develop and improve data transformation logic — understanding not just the how, but the why
- Implement data quality checks, validation rules, and error handling
- Monitor pipeline health and contribute to observability improvements
- Collaborate with the broader data engineering and analytics team to support platform stability and evolution
- Support the ongoing infrastructure migration from IBM Cloud to AWS
Requirements
- Proven experience in ETL pipeline design and maintenance in a production environment
- Hands-on experience with orchestration tools such as SSIS, Prefect, Airflow, dbt, or Azure Data Factory
- Strong SQL and Python skills
- Experience with data ingestion across multiple patterns — cloud storage, SFTP, APIs, and real-world messy/fragile sources
- Solid understanding of data transformation logic and data modelling principles
- Experience with data quality, validation, error handling, and monitoring
- Comfortable working within complex legacy systems and established team workflows
- Good communication skills and a proactive approach to problem-solving
Tech Stack
- Airflow
- AWS
- Azure
- Cloud
- ETL
- Python
- SQL
- SSIS
Benefits
- 100%Remote Work
- WFH allowance: Monthly payment as financial support for remote working.
- Career Growth: We have established a career development program accessible for all employees with a 360º feedback that will help us to guide you in your career progression.
- Training: For Tech training at Zartis, you have time allocated during the week at your disposal. You can request from a variety of options, such as online courses (from Pluralsight and Educative.io, for example), English classes, books, conferences, and events.
- Mentoring Program: You can become a mentor in Zartis or you can receive mentorship, or both.
- Zartis Wellbeing Hub (Kara Connect): A platform that provides sessions with a range of specialists, including mental health professionals, nutritionists, physiotherapists, fitness coaches, and webinars with such professionals as well.
- Multicultural working environment: We organize tech events, webinars, parties, and activities to do online team-building games and contests.