BI Architect - Oracle Analytics & Access
- Hiring Organisation
- Randstad Digital
- Location
- City of London, London, United Kingdom
- Employment Type
- Contract
- Contract Rate
- £500 - £505 per day
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 ...