More jobs:
BI Architect - Oracle Analytics & Access
Job in
City of London, Central London, Greater London, England, UK
Listed on 2026-10-12
Listing for:
Randstad Technologies Recruitment
Full Time
position Listed on 2026-10-12
Job specializations:
-
IT/Tech
Data Engineering
Job Description & How to Apply Below
Location: City of London
Hiring: BI Architect - Oracle Analytics & Access
📍
Location:
London (Canary Wharf)
⏳ Duration: 12-Month Contract
💼 Workstream:
Finance / Operations Reporting Modernisation
Are you an experienced Solution Architect / Lead Engineer with deep expertise in Oracle Analytics, Python, and legacy Access modernization? We are looking for a hands-on Lead Architect to drive the end-to-end migration and modernization of an enterprise Microsoft Access & Oracle reporting environment into a modern Oracle Analytics Server (OAS), BI Publisher, and Python-driven automation architecture.
Role Overview
In this role, you will lead the assessment, design, build, and deployment of a replacement reporting framework for a legacy MS Access/VBA application. You will work across data layer engineering, OAS/BI Publisher builds, Python ETL/automation, and stakeholder engagement within a financial services / enterprise environment.
🔑 Key Responsibilities
Discovery & Assessment:
Inventory legacy MS Access databases (.mdb/.accdb), linked tables, pass-through queries, macros, and VBA logic to define target-state architecture.
Oracle DB Engineering:
Develop and tune complex Oracle SQL, PL/SQL, views, materialized views, and stored procedures. Analyze execution plans, AWR/ASH evidence, and TEMP/PGA usage for high-volume workloads.
OAS & BI Publisher:
Build interactive OAS dashboards, analyses, and BI Publisher data models, layouts, bursting, and automated schedules.
Python Automation:
Design production-grade Python scripts (pandas, oracledb, SQL Alchemy, openpyxl, etc.) to replace Access macros, automate extraction, and deliver automated report packs.
Testing & Delivery:
Conduct parallel runs, complete data reconciliation, establish rollback plans, and deliver production runbooks and team support handovers.🎯 Required Experience & Skills
8+ years of Oracle DB development and SQL performance tuning.
5+ years in OAS / OBIEE and BI Publisher development.
5+ years in Python development for data extraction, transformation, and reporting automation.
3+ years migrating legacy Microsoft Access / VBA applications.
Strong experience in Financial Services or highly regulated enterprise environments preferred.
Experience with Dev Ops concepts, Git, CI/CD, and enterprise schedulers (e.g., Control-M, Autosys).
How to Apply
If you are a seasoned Solution Architect / Lead Engineer ready to take ownership of an enterprise reporting modernization project, apply now or drop a message directly! (url removed)
Randstad Technologies is acting as an Employment Business in relation to this vacancy
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×