Data Engineer: ETL, Data Warehousing & BI Dashboards

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

Job summary

SYONE is seeking a Data Engineer/Data Analytics Engineer in Porto to collaborate with business stakeholders, translate requirements into technical specifications, and design robust data models for analytics. You will build and optimize ETL/ELT pipelines, develop BI dashboards, and ensure data quality and lineage across multiple sources.

The role requires 3+ years of experience, strong SQL skills, and proficiency in data warehousing concepts. Knowledge of Stambia and Power BI is a plus.

Qualifications

• Bachelor's or Master's degree in Computer Science, Data Science, Statistics, Finance or related field.
• At least 3 years of professional experience in data-focused roles (Data Analyst, Analytics Engineer, BI Developer).
• Strong knowledge of SQL, complex queries, joins, stored procedures and query optimization.

Responsibilities

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

Skills

SQL

Data modeling

English (fluent)

French (B2)

Education

Bachelor's or Master’s in Computer Science, Data Science, Statistics, Finance

Tools

Stambia

Talend

Informatica

SSIS

Azure Data Factory

dbt

Power BI

Job description

SYONE is seeking a Data Engineer/Data Analytics Engineer in Porto to collaborate with business stakeholders, translate requirements into technical specifications, and design robust data models for analytics. You will build and optimize ETL/ELT pipelines, develop BI dashboards, and ensure data quality and lineage across multiple sources.

The role requires 3+ years of experience, strong SQL skills, and proficiency in data warehousing concepts. Knowledge of Stambia and Power BI is a plus.