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
Lead Oracle Analytics / Python Developer - Investment Bank in London employer: Robert Walters Careers
Join a leading organisation in Walsall that values its employees and fosters a collaborative work culture. As a Group Financial Controller, you will benefit from competitive salary packages, opportunities for professional development, and the chance to make a significant impact on the company's financial strategy. With a commitment to compliance and efficiency, this role offers a rewarding environment where your expertise will be recognised and appreciated.
