ETL Data Engineer (Hibrido, Porto)

Shore; Porto; Presencial; EUR 60 000 - 90 000; Tempo integral

Resumo da oferta

Shore is seeking an Enterprise Data Engineer in Porto to design, optimise, and operate large-scale data solutions across data warehouse and data lake environments. You will develop ETL/ELT processes, enhance data integration, and ensure reliable platforms enabling data-driven decisions.

The role focuses on implementing robust data flows, data quality controls, and scalable architectures while collaborating with cross-functional teams to translate business requirements into technical data

Qualificações

• Proven track record in data engineering and ETL design.
• Advanced SQL for analysis and DB optimization.
• Experience with Informatica PowerCenter, ODI, Talend or Stambia.
• Strong knowledge of Oracle, SQL Server or PostgreSQL; NoSQL knowledge desired.
• Experience with star and snowflake data modelling.
• Independent problem solving and clear communication.

Responsabilidades

• Design and implement complex ETL/ELT solutions across multiple data sources.
• Develop and optimise advanced SQL for analysis, transformation and validation.
• Build and maintain data flows using enterprise ETL tooling.
• Implement data-quality controls, error detection, monitoring and performance optimisation.
• Translate business requirements into technical data solutions and contribute to data modelling and database design.
• Automate processing, document architectures and flows, and ensure security and compliance.

Conhecimentos

Data engineering

ETL design

SQL optimization

Data modelling

NoSQL knowledge

Problem solving

Communication

Ferramentas

Informatica PowerCenter

Oracle Data Integrator

Talend

Stambia

Descrição da oferta de emprego

Join our team as an Enterprise Data Engineer and help design, optimise, and operate large-scale data solutions across modern data warehouse and data lake environments.

You'll be responsible for developing and enhancing ETL/ELT processes, improving data integration capabilities, and ensuring reliable, scalable data platforms that support critical business operations.

If you're passionate about enterprise data engineering, modern data architectures, and building efficient solutions that enable data-driven decision-making, we'd love to hear from you.

Key Responsibilities

• Design and implement complex ETL/ELT solutions across multiple data sources.
• Develop and optimise advanced SQL for analysis, transformation and validation.
• Build and maintain data flows using enterprise ETL tooling.
• Implement data-quality controls, error detection, monitoring and performance optimisation.
• Translate business requirements into technical data solutions and contribute to data modelling and database design.
• Automate processing, document architectures and flows, and ensure security and compliance.
  
  

Requisitos mínimos

• Strong track record in data engineering and ETL solution design.
• Advanced SQL for querying, manipulation and relational-database optimisation.
• Significant experience with at least one of Informatica PowerCenter, Oracle Data Integrator, Talend or Stambia.
• Relational databases such as Oracle, SQL Server or PostgreSQL; NoSQL knowledge is also relevant.
• Data modelling, including star and snowflake schemas.
• Independent problem solving, collaboration and clear technical communication.