Oracle Database Developer

WHO WE ARE

Leonteq is a Swiss fintech company and a leading marketplace for structured investment solutions. Combining capital markets expertise with proprietary technology, the company provides access to a wide range of structured investment opportunities. Entrepreneurial thinking is central to how we work. Expertise is valued, ownership is encouraged, and employees are empowered to actively shape their areas of responsibility. Innovation and continuous improvement are part of daily life, making Leonteq a dynamic and collaborative place to grow your career.

About the role

As a Senior Oracle Database Developer, you will play a key role in the design, development, and optimization of our Oracle-based data warehouse and reporting solutions. You will collaborate closely with business stakeholders and technical teams to deliver robust and scalable systems that support mission-critical financial and regulatory processes. At Leonteq, we are a leading player in the financial industry, renowned for our innovative approaches, our commitment to excellence and our entrepreneurial spirit. Our organisational values people together, passion, dedication, quality and expertise are our guiding north star.

What you'll do

Contribute to the design and development of a Data Warehouse based on Oracle Database 19c Enterprise Edition

Develop scalable, efficient, and maintainable PL/SQL code for data movement, transformation and reporting

Implement complex reporting solutions in areas such as Risk, Finance, and Regulatory reporting

Collaborate with business users to understand requirements, workflows, and data needs

Refactor and enhance legacy systems to improve scalability, performance, and maintainability

Write clean, reliable code following Leonteq’s best practices and development standards

Optimize SQL and PL/SQL code, leveraging advanced Oracle features like parallel queries, partitioning, compression, and analytical functions

Tune database/query performance using tools such as ASH and Real-Time SQL Monitoring

Support data modeling activities using techniques such as Kimball, Data Vault, or 3NF

Work in an agile, collaborative environment, contributing to design reviews and mentoring junior developers

What you'll need

5+ years of experience in Oracle SQL and PL/SQL development

Strong understanding of data modeling for data warehouses, including dimensional modeling and normalization techniques

Deep knowledge of advanced SQL concepts, including analytical functions, hierarchical queries, complex joins, partitioning, and parallel execution

Hands-on experience in performance tuning and troubleshooting using Oracle diagnostic tools (e.g., ASH, AWR)

Strong problem-solving skills with the ability to develop creative and scalable solutions

Proactive and independent working style with high attention to detail

Fluency in English with excellent communication and collaboration skills

Solution-driven mindset and interest in investment

Nice to have

Experience in the financial or insurance industry

Developing web-applications using Oracle Application Express

Proficiency in Python programming language

Working knowledge of Git version control systems

Why you'll love working here

Experience the dynamics of a leading fintech company

Be part of a multinational team / department spread across different locations

Work in modern facilities at an exceptional location

Hybrid work system: home office and office

#J-18808-Ljbffr