Robert Walters
Lead Oracle Analytics / Python Developer - Investment Bank
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London