Senior Oracle Data Warehouse Engineer (PL/SQL) – Hybrid Work

Leonteq AG; Lisboa; Híbrido; EUR 85 000 - 105 000; Tempo integral

Resumo da oferta

Leonteq AG is seeking a Senior Oracle Database Developer in Lisbon to design, develop and optimize our Oracle-based data warehouse and reporting solutions. You will partner with stakeholders and cross-functional teams to deliver robust, scalable systems supporting financial and regulatory processes.

Join a dynamic fintech environment that values excellence, ownership and collaboration. The role offers a hybrid work model with opportunities to mentor junior developers and influence data

Qualificações

• 5+ years of experience in Oracle SQL and PL/SQL development.
• Strong data warehouse modeling and normalization knowledge.
• Expertise in advanced SQL concepts, analytical functions, partitioning and parallel execution.
• Experience with performance tuning using Oracle tools (ASH, AWR).
• English communication and collaboration skills.

Responsabilidades

• Design and develop a Data Warehouse on Oracle 19c Enterprise Edition.
• Develop scalable PL/SQL code for data movement, transformation and reporting.
• Implement reporting for Risk, Finance and Regulatory areas.
• Collaborate with business users to gather requirements and data needs.
• Refactor legacy systems to improve scalability, performance and maintainability.
• Write clean code following Leonteq’s standards and best practices.
• Optimize SQL/PL-SQL leveraging parallel queries, partitioning and analytics.
• Tune performance using ASH and Real-Time SQL Monitoring.
• Support data modeling using Kimball, Data Vault or 3NF.
• Work in an agile, collaborative environment and mentor juniors.

Conhecimentos

Oracle SQL

PL/SQL

Data Warehousing

Performance Tuning

Analytical Functions

English Fluency

Ferramentas

ASH

AWR

Descrição da oferta de emprego

Leonteq AG is seeking a Senior Oracle Database Developer in Lisbon to design, develop and optimize our Oracle-based data warehouse and reporting solutions. You will partner with stakeholders and cross-functional teams to deliver robust, scalable systems supporting financial and regulatory processes.

Join a dynamic fintech environment that values excellence, ownership and collaboration. The role offers a hybrid work model with opportunities to mentor junior developers and influence data