Lead Oracle Database Architect
About the company
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.
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.
Your tasks
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.
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.
- 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.
Requirements
- 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.
Other
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