Randstad Digital UK
Oracle Database Developer
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
?%
Hiring: Lead Oracle Analytics, Python & Access Reporting Modernisation Architect
📍 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
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.
- 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, SQLAlchemy, 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 DevOps concepts, Git, CI/CD, and enterprise schedulers (e.g., Control-M, Autosys).
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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! sajeel.sharief@randstaddigital.com
#LegacyModernisation #DataMigration #SolutionArchitect #ReportingAutomation #BusinessIntelligence #ETL#OracleAnalytics #OAS #BIPublisher #Python #PLSQL #OracleDB #DataEngineering#JobOpportunity #ContractJobs #LondonJobs #CanaryWharfJobs #Hiring #TechJobs #FinancialServices
“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
Location