Lead Oracle Analytics / Python Developer - Investment Bank

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.

Desired Skills and Experience 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