Data Engineer (ETL) French Speaker

Syone; Lisboa; On-site; EUR 42,000 - 68,000; Full time

Job summary

Syone is seeking a data-focused professional to translate business requirements into technical specs for the Data Engineering team in Lisbon, Portugal. You will design and maintain data models (star/snowflake) and develop BI dashboards to empower analytics-driven decisions.

You’ll build ETL/ELT pipelines, integrate data from multiple sources, and ensure data quality and lineage across the data estate. You will collaborate with stakeholders, maintain documentation, and continuously improve data

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Data Science, Statistics, Finance, or a related field.
• At least 3 years of professional experience in a similar role (Data Analyst / Analytics Engineer / BI Developer).
• Strong SQL skills with complex queries and optimization.
• Relational databases, data warehousing and data modeling knowledge (Kimball).
• Hands-on experience with ETL/ELT tools such as Stambia, Talend, Informatica, SSIS, Azure Data Factory or dbt.
• Willingness to learn Stambia if you have experience with other ETL technologies.
• Professional proficiency in French (minimum B2) to interact with French-speaking stakeholders.
• Fluent English, both written and spoken.

Responsibilities

• Collaborate with business stakeholders to understand requirements and translate them into clear technical specifications for the Data Engineering team.
• Design, develop and maintain data models, including star and snowflake schemas, optimized for analytics and reporting.
• Design, develop and maintain dashboards and BI reporting solutions to support business decision-making.
• Build, test and optimize ETL/ELT pipelines to integrate data from multiple sources into data warehouses.
• Develop and maintain data integration processes using Stambia and other ETL tools.
• Implement automated data quality checks to ensure data reliability, consistency and integrity.
• Maintain data documentation, including data dictionaries, data definitions and data lineage.
• Collaborate with Data Engineers and other stakeholders to deliver scalable and efficient data solutions.
• Contribute to the continuous improvement of data processes, performance and reporting capabilities.

Skills

SQL

Data modeling

Data warehousing

ETL/ELT engineering

English

French (B2)

Education

CS/DS/Statistics/Finance degree

Tools

Stambia

Talend

Informatica

SSIS

Azure Data Factory

dbt

Job description

Collaborate with business stakeholders to understand requirements and translate them into clear technical specifications for the Data Engineering team.

Design, develop and maintain data models, including star and snowflake schemas, optimized for analytics and reporting.

Design, develop and maintain dashboards and BI reporting solutions to support business decision-making.

Build, test and optimize ETL/ELT pipelines to integrate data from multiple sources into data warehouses.

Develop and maintain data integration processes using Stambia and other ETL tools.

Implement automated data quality checks to ensure data reliability, consistency and integrity.

Collaborate with Data Engineers and other stakeholders to deliver scalable and efficient data solutions.

Contribute to the continuous improvement of data processes, performance and reporting capabilities.

What you will do

• Collaborate with business stakeholders to understand requirements and translate them into clear technical specifications for the Data Engineering team.
• Design, develop and maintain data models, including star and snowflake schemas, optimized for analytics and reporting.
• Design, develop and maintain dashboards and BI reporting solutions to support business decision-making.
• Build, test and optimize ETL/ELT pipelines to integrate data from multiple sources into data warehouses.
• Develop and maintain data integration processes using Stambia and other ETL tools.
• Implement automated data quality checks to ensure data reliability, consistency and integrity.
• Maintain data documentation, including data dictionaries, data definitions and data lineage.
• Collaborate with Data Engineers and other stakeholders to deliver scalable and efficient data solutions.
• Contribute to the continuous improvement of data processes, performance and reporting capabilities.

What you need to bring

• Bachelor's or Master's degree in Computer Science, Data Science, Statistics, Finance, or a related field.
• At least 3 years of professional experience in a similar role, such as Data Analyst, Analytics Engineer or BI Developer.
• Strong knowledge of SQL, including complex queries, joins, stored procedures and query optimization.
• Solid understanding of relational databases, data warehousing and data modeling, particularly the Kimball methodology.
• Hands‑on experience with ETL/ELT tools such as Stambia, Talend, Informatica, SSIS, Azure Data Factory or dbt.
• Willingness to learn and adapt to Stambia if you have experience with other ETL technologies.
• Professional proficiency in French (minimum B2 level) to interact with French‑speaking stakeholders.
• Fluent English, both written and spoken.

The following will be considered a plus:

• Experience with Power BI, including DAX and Power Query/M.
• Previous experience in the banking, financial services or insurance sector.
• Familiarity with cloud platforms such as Azure, AWS or GCP.
• Knowledge of Python or Unix/Linux scripting.

By applying, you accept our GDPR policies. Your personal data in your CV and documents will be used solely for processing your application at SYONE. SYONE, S.A. (NIPC 504729624) is the data controller, located at Rua Alfredo da Silva, 8‑A, Edifício Stern, Piso 3D, 2610‑016 Amadora. We will use your data to tailor your application to relevant vacancies and for potential employment contracts. If selected, your data will be kept during your employment and for at least two years after. If not selected, your data will be kept for two years for future vacancies and then deleted, except for your contact details. You can exercise your rights (access, rectification, erasure, etc.) by emailing [e-mail]. Your data may be shared with our HR service providers and will be stored securely. You can withdraw your consent at any time. We will not use your data for other purposes without your express consent. For more information, email [e-mail]. Your data will not be used for other purposes without your express consent.