An opportunity has arisen to join a leading global financial services organisation supporting institutional investors and operating at the heart of the global financial markets. This is a hands-on role combining solution design, database engineering, reporting development and automation, with ownership from initial assessment through to implementation and production handover.

Lead Oracle Analytics & Python Reporting Modernisation Specialist

Location: London
Contract: 12 months
Rate: £500–£600 per day
Working pattern: Hybrid – 3 days onsite, 2 days remote

The Opportunity

An opportunity has arisen to join a leading global financial services organisation supporting institutional investors and operating at the heart of the global financial markets.

You will lead the end-to-end modernisation of a legacy reporting environment built around Microsoft Access and Oracle databases, replacing desktop-dependent processes with scalable, secure and production-ready reporting solutions using Oracle Analytics Server (OAS), BI Publisher and Python.

This is a hands-on role combining solution design, database engineering, reporting development and automation, with ownership from initial assessment through to implementation and production handover.

Key Responsibilities

• Assess and reverse-engineer existing Microsoft Access databases, VBA, macros, queries and reporting workflows.
• Design and deliver a modern reporting architecture using Oracle Analytics Server, BI Publisher, Python or a combination of these technologies.
• Develop and optimise Oracle SQL, PL/SQL, views and stored procedures to support complex reporting requirements.
• Build automated reporting solutions using Python, including data extraction, transformation, validation and Excel/PDF/CSV output generation.
• Develop dashboards, report templates, scheduling and distribution workflows, ensuring appropriate security and access controls.
• Implement robust testing, data reconciliation, performance tuning and production deployment processes.
• Produce technical documentation, operational runbooks and knowledge transfer materials for ongoing support.

Essential Experience

• Strong Oracle database development skills, including advanced SQL, PL/SQL and performance tuning.
• Proven experience with Oracle Analytics Server (OAS) or OBIEE and Oracle BI Publisher.
• Strong Python development experience, particularly in data processing and reporting automation.
• Hands-on experience with Microsoft Access, VBA, macros and migrating legacy reporting applications.
• Experience delivering enterprise-grade reporting solutions, including testing, deployment, scheduling and production support.
• Excellent stakeholder management skills and the ability to lead a technical workstream independently.

Desirable: Financial services experience, Git-based version control, CI/CD and enterprise scheduling tools such as Control-M or Autosys.

The Ideal Candidate

A senior, hands-on technical specialist who can independently assess a complex legacy reporting environment, recommend the right target architecture and deliver a robust replacement from discovery through to production. You will be comfortable working with business stakeholders and technical teams in a controlled, enterprise financial services environment.

Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates