Skip to content

Robert Walters

Lead Oracle Database Architect

Posted Updated

Description

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

Skills

What Lead Architecture jobs ask for — and how much of it you have →
Apply

Apply to Lead Oracle Database Architect at Robert Walters

Create a free account first, or go straight to the employer.

Free RoleWatch account

  • Get an email when new jobs match your search
  • Save jobs and track every application
  • See how well your CV matches each job

Already have one?

No account needed. Opens the employer's own site in a new tab.

See also

Architecture jobs by country — openings, pay and top skills →