BI Architect: Oracle Analytics & Legacy Access Modernization

Randstad Technologies Recruitment; City Of London; Presencial; GBP 85 000 - 120 000; Tempo integral

Resumo da oferta

Randstad Technologies Recruitment seeks an BI Architect to lead the replacement reporting framework for a legacy MS Access/VBA application. You will work across data layer engineering, OAS/BI Publisher builds, and Python ETL/automation in a financial services environment.

The role oversees Oracle SQL tuning, OBIEE/OAS development, Python scripting for automation, and migration of Access/VBA components, with CI/CD and enterprise schedulers in scope.

Qualificações

• 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.
• Experience with DevOps concepts, Git, CI/CD, and enterprise schedulers (e.g., Control-M, Autosys).

Responsabilidades

• Discovery & Assessment: Inventory legacy MS Access databases, 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.
• OAS & BI Publisher: Build interactive dashboards, analyses, and BI Publisher data models, layouts, bursting, and automated schedules.
• Python Automation: Design Python scripts 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.

Conhecimentos

Oracle DB development

SQL performance tuning

OAS / OBIEE

BI Publisher development

Python development

Data extraction/automation

Legacy Access/VBA migration

DevOps concepts

Git

CI/CD

Control-M

Autosys

Ferramentas

Git

CI/CD

Control-M

Autosys

Descrição da oferta de emprego

Randstad Technologies Recruitment seeks an BI Architect to lead the replacement reporting framework for a legacy MS Access/VBA application. You will work across data layer engineering, OAS/BI Publisher builds, and Python ETL/automation in a financial services environment.

The role oversees Oracle SQL tuning, OBIEE/OAS development, Python scripting for automation, and migration of Access/VBA components, with CI/CD and enterprise schedulers in scope.