Lead BI Architect: Oracle Analytics & Automation

Randstad Technologies Recruitment; Greater London; On-site; GBP 120,000 - 160,000; Full time

Job summary

Randstad Technologies Recruitment in London (Canary Wharf) is seeking a BI Architect to lead the migration of legacy Access/VBA reporting to Oracle Analytics Server, BI Publisher, and Python-driven automation. You will oversee design, build, and deployment across data layer engineering and OAS/BI Publisher efforts within a financial services environment.

The role requires 8+ years in Oracle DB development and 5+ years in OAS/OBIEE, BI Publisher, and Python, along with experience migrating

Qualifications

• 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.

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, 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.

Skills

Oracle DB development

SQL performance tuning

OAS/OBIEE

BI Publisher

Python development

Access VBA migration

DevOps concepts

Job description

Randstad Technologies Recruitment in London (Canary Wharf) is seeking a BI Architect to lead the migration of legacy Access/VBA reporting to Oracle Analytics Server, BI Publisher, and Python-driven automation. You will oversee design, build, and deployment across data layer engineering and OAS/BI Publisher efforts within a financial services environment.

The role requires 8+ years in Oracle DB development and 5+ years in OAS/OBIEE, BI Publisher, and Python, along with experience migrating