ETL/ELT Data Integration Engineer | Senior (FR)

ABOUT THE OPPORTUNITY

We are looking for a Senior Data Engineer to support data integration and engineering initiatives in the banking and financial services sector. This role focuses on designing, maintaining and optimizing ETL and ELT pipelines, supporting data warehouse and data lake environments, and collaborating with international teams and French-speaking stakeholders.

WHAT YOU WILL DO

- Design, develop, test and maintain ETL and ELT pipelines.
- Ingest, transform and load data from multiple sources into data warehouses and data lakes.
- Configure and manage ETL tools to automate data integration processes.
- Write and optimize SQL queries for data extraction, transformation and loading.
- Create and maintain data models across ODS, staging and analytics layers.
- Implement data quality checks, data lineage and monitoring controls.
- Develop and maintain job orchestration using workflow scheduling tools.
- Monitor jobs, troubleshoot failures and implement retry strategies.
- Automate operational tasks using UNIX or Linux shell scripting.
- Develop reusable scripts for data processing, file management and system automation.
- Collaborate with data architects, data analysts and business stakeholders.
- Translate business requirements into scalable data solutions.
- Optimize pipeline performance and scalability.
- Ensure security, data governance and compliance requirements are applied.
- Prepare technical documentation, runbooks and knowledge transfer materials.

WHAT WE ARE LOOKING FOR

- 6 to 9 years of professional experience in data engineering, ETL, ELT or data integration roles.
- Strong hands-on experience with ETL or ELT tools such as Semarchy, Stambia, Talend, DataStage or similar.
- Proficient SQL skills and experience with relational databases.
- Experience with data warehousing concepts, ETL and ELT patterns, data quality, data lineage and metadata management.
- Experience with job orchestration or workload automation tools.
- Knowledge of UNIX or Linux scripting for automation and data processing.
- Strong problem-solving, debugging and troubleshooting skills.
- Ability to work with autonomy in a fast-paced environment.
- Excellent written and verbal communication skills in English.
- Professional working proficiency in French at B2 level or above.
- Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering or a related field.
- Self-motivated, detail-oriented and collaborative approach.

TECHNICAL SKILLS

- ETL
- ELT
- Semarchy
- Stambia
- Talend
- DataStage
- SQL
- Oracle
- SQL Server
- PostgreSQL
- Snowflake
- Data modeling
- ODS
- Staging schemas
- Analytics schemas
- Data warehouses
- Data lakes
- Data quality
- Data lineage
- Metadata management
- VTOM
- Virtual-M
- Workflow scheduling
- Workload automation
- UNIX
- Linux
- Shell scripting
- Awk
- Sed
- Data processing automation
- Data governance
- Access controls
- Audit trails
- Data masking
- Technical documentation
- Runbooks

NICE TO HAVE

- Python
- GCP
- Cloud-native ETL tools
- Data cataloging
- Spark
- Hadoop
- CI/CD concepts
- DevOps practices
- Awareness of ISO/IEC 27001 or cybersecurity best practices

COMPENSATION TRANSPARENCY

Base salary range: EUR 22 000 - EUR 32 000 gross/year
Total compensation: up to EUR 40 000/year
The salary range is based on objective and gender-neutral criteria, including required competencies, professional experience, level of responsibility and role requirements. Final compensation will be determined according to the candidate's profile and position requirements.

WHAT WE OFFER

- Flexible working arrangements whenever the role and project context allow it.
- Private health insurance from the first day, with optional family extension.
- Confidential mental health support through professional psychological support, content and live sessions.
- Continuous learning, training and certification opportunities throughout your journey.
- Childcare vouchers and practical family support measures.
- Community moments, shared milestones and leadership presence when it matters most.
- A culture built on ownership, impact, honesty, mutual support and agility.
- Upskilling opportunities in quality management, information security, AI governance or cybersecurity best practices when relevant to your role.

EQUAL OPPORTUNITY

Hexa is committed to equal opportunity, inclusion and respectful collaboration. We value different backgrounds, experiences and perspectives, and we align our practices with the principles of the Portuguese Diversity Charter.

HEXA LIFE

At Hexa, we are all Builders. You will be part of a culture where people are encouraged to contribute, question, improve and turn knowledge into real impact. We build with honesty, support each other across teams and geographies, and adapt with agility to deliver meaningful solutions with quality and intention.