Senior ODI ETL & OBIEE BI Developer

Proactive Appointments; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A well-established financial services organisation in Greater London seeks an experienced Senior ODI ETL & OAS/OBIEE BI Developer for a hybrid role. The successful candidate will manage data warehouse platforms while ensuring data integrity across banking systems. This position requires strong Oracle data warehousing and ETL skills, knowledge of banking operations, and the ability to deliver impactful BI solutions. Candidates must have experience in financial data environments, supporting retail banking, treasury, and finance operations.

Qualifications

• Extensive experience in Oracle data warehousing and ETL.
• Strong analytical skills in banking and finance domains.
• Ability to develop and maintain scalable BI solutions.

Responsibilities

• Design and maintain data warehouse schemas and marts.
• Develop ETL pipelines for banking data integration.
• Create dashboards and reports for actionable insights.

Skills

Oracle data warehousing

ETL development

Business intelligence

SQL

PL/SQL

Data quality assurance

Analytical skills

Tools

Oracle Data Integrator (ODI)

Oracle Analytics Server (OAS)

Job description

Senior ODI ETL/OBIEE BI Developer

2 Year FTC - Hybrid

Our client, a well-established financial services organisation, is seeking an experienced Senior ODI ETL & OAS/OBIEE BI Developer to support the design, development and ongoing management of enterprise banking data platforms.

This is a hands‑on senior role suited to a specialist with strong Oracle data warehousing, ETL and BI experience, combined with deep banking domain knowledge, particularly across Oracle Flexcube, Oracle ERP, and ideally Finastra OPICS.

You will play a key role in delivering high-quality data integration, reporting and analytics solutions that support retail banking, treasury and finance operations.

Key Responsibilities

Data Warehouse & Data Mart Management

• Design, implement and maintain data warehouse schemas and data marts
• Develop scalable data models to support efficient reporting and analytics
• Perform ongoing maintenance to ensure stability, performance and reliability

ETL Development & Data Integration

• Design, build and support ETL pipelines using Oracle Data Integrator (ODI)
• Integrate data from multiple banking and finance systems
• Ensure data quality, consistency and reconciliation across platforms
• Optimise ETL performance for large-scale financial data volumes

Data Management & Analysis

• Develop complex SQL and PL/SQL for data transformation and analysis
• Manage data structures to support efficient storage and retrieval
• Troubleshoot data-related issues and support root cause analysis

Business Intelligence & Reporting

• Develop and maintain BI solutions using Oracle Analytics Server (OAS/OBIEE)
• Create dashboards, reports and extracts for business and regulatory use
• Analyse financial and banking data to deliver actionable insights

Banking & Finance Domain Support

• Apply strong knowledge of retail banking, treasury products and accounting data
• Work with stakeholders to understand business requirements and translate them into technical solutions
• Support data governance, audit and regulatory standards

Proactive Appointments Limited operates as an employment agency and employment business and is an equal opportunities organisation.

We take our obligations to protect your personal data very seriously. Any information provided to us will be processed as detailed in our Privacy Notice, a copy of which can be found on our website.