Engenheiro de Dados

Genesis Digital Solutions; Lisboa; Hybrid; EUR 42,000 - 70,000; Full time

Job summary

Genesis Digital Solutions is seeking a Data Engineer in Lisbon, Portugal. You will design, develop and optimize data processing solutions using Oracle databases and ETL pipelines within an Agile environment.

You will collaborate with cross-functional teams, ensure data quality and performance, and contribute to continuous delivery and data-driven decision making for clients across industries.

Qualifications

• Advanced knowledge of relational databases, particularly Oracle 12c or later.
• Strong SQL skills, including CRUD operations, data modelling, transaction management, and performance tuning.
• Strong proficiency in PL/SQL.
• Experience developing and maintaining ETL processes.
• Experience with Oracle Data Integrator (ODI) is a plus.
• Strong understanding of multidimensional data modelling.
• Advanced troubleshooting and problem-solving capabilities.
• Experience working in Scrum and Agile environments.
• Knowledge of TDD and BDD practices.
• Knowledge of Continuous Delivery principles.
• Ability to work autonomously while collaborating effectively with the team.
• Strong communication skills, with the ability to adapt technical explanations to different audiences.
• Proactive, delivery-oriented mindset, with a strong sense of ownership and accountability.

Responsibilities

• Develop, maintain, and optimize data processing solutions using Oracle databases.
• Design and implement ETL processes to extract, transform, and load data from different sources.
• Develop complex SQL queries and PL/SQL procedures to support data processing and business requirements.
• Work with relational databases, data models, CRUD operations, and transactional processes.
• Apply SQL performance tuning techniques to improve query efficiency and database performance.
• Implement and maintain data models based on multidimensional modelling principles.
• Perform advanced troubleshooting, investigate data issues, and identify root causes.
• Analyse data to ensure accuracy, consistency, and reliability.
• Collaborate with cross-functional teams using Scrum and Agile methodologies.
• Apply testing practices, including Test-Driven Development (TDD) and Behaviour-Driven Development (BDD).
• Contribute to Continuous Delivery practices and the continuous improvement of development workflows.
• Work closely with team members and clients to clarify requirements, manage expectations, and ensure successful delivery.

Skills

Oracle 12c

SQL

PL/SQL

ETL

Data modelling

Multidimensional modelling

Troubleshooting

Scrum/Agile

TDD/BDD

CD/CI

Stakeholder management

Communication

Tools

ODI

Job description

Joana Figueira

Tecnologia

1

Lisboa

1200-629

Genesis Digital Solutions is a consulting and technology company that helps organizations turn ideas into measurable business impact through digital expertise and AI innovation. Founded in 2018, we operate across Portugal and the United Arab Emirates, supporting clients in multiple industries with intelligent, scalable, and secure solutions. We combine strategy, engineering, and emerging technologies such as AI, Data, Web3, and Digital Product Development to drive transformation end to end. Our focus is on building practical, human-centered solutions and long-term partnerships that enable sustainable growth, innovation, and real-world results.

We are looking for a Data Engineer with strong expertise in Oracle databases, SQL, PL/SQL, and ETL development. You will be responsible for developing and maintaining data processing solutions, optimizing database performance, and ensuring data quality and consistency. Working in an Agile environment, you will collaborate with technical teams and stakeholders to deliver reliable data solutions and continuously improve development practices.

What You'll Work On

• Develop, maintain, and optimize data processing solutions using Oracle databases.
• Design and implement ETL processes to extract, transform, and load data from different sources.
• Develop complex SQL queries and PL/SQL procedures to support data processing and business requirements.
• Work with relational databases, data models, CRUD operations, and transactional processes.
• Apply SQL performance tuning techniques to improve query efficiency and database performance.
• Implement and maintain data models based on multidimensional modelling principles.
• Perform advanced troubleshooting, investigate data issues, and identify root causes.
• Analyse data to ensure accuracy, consistency, and reliability.
• Collaborate with cross-functional teams using Scrum and Agile methodologies.
• Apply testing practices, including Test-Driven Development (TDD) and Behaviour-Driven Development (BDD).
• Contribute to Continuous Delivery practices and the continuous improvement of development workflows.
• Work closely with team members and clients to clarify requirements, manage expectations, and ensure successful delivery.

What We're Looking For

• Advanced knowledge of relational databases, particularly Oracle 12c or later.
• Strong SQL skills, including CRUD operations, data modelling, transaction management, and performance tuning.
• Strong proficiency in PL/SQL.
• Experience developing and maintaining ETL processes.
• Experience with Oracle Data Integrator (ODI) is a plus.
• Strong understanding of multidimensional data modelling.
• Advanced troubleshooting and problem-solving capabilities.
• Experience working in Scrum and Agile environments.
• Knowledge of TDD and BDD practices.
• Knowledge of Continuous Delivery principles.
• Ability to work autonomously while collaborating effectively with the team.
• Strong communication skills, with the ability to adapt technical explanations to different audiences.
• Proactive, delivery-oriented mindset, with a strong sense of ownership and accountability.
• Ability to manage stakeholder expectations, adapt to change, and work iteratively towards defined objectives.

Bonus Points

• Hands-on experience with Oracle Data Integrator (ODI).
• Experience with data warehousing and complex data integration projects.
• Experience improving database performance in large-scale environments.
• Experience implementing automated testing and Continuous Delivery practices.
• Experience working directly with clients and managing technical expectations.

Why You'll Stay

• A workplace that values innovation and personal growth.
• Opportunities to work on high-impact projects for leading clients.
• Flexible hours and hybrid work options.
• Support for professional development, including training and certifications.