Oracle Database Developer

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., * 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

• 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

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., 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.