Senior ODI ETL / OBIEE BI Developer

Proactive.IT Appointments Limited; Greater London; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading financial services recruitment agency seeks a Senior ODI ETL & OBIEE BI Developer for a hands-on role supporting the design, development, and management of enterprise banking data platforms. The ideal candidate will possess extensive experience in Oracle data warehousing, ETL, and BI, alongside deep banking domain knowledge. Responsibilities include managing data warehouse schemas, developing ETL pipelines, and producing insightful reports. This opportunity offers a competitive salary and hybrid work flexibility.

Qualifications

• Experience in data warehousing and ETL development.
• Strong SQL and PL/SQL skills for data transformation.
• Deep knowledge of the banking and finance domain.

Responsibilities

• Design and maintain data warehouse schemas and data marts.
• Develop and optimise ETL pipelines for data integration.
• Create dashboards and reports for business insights.
• Apply knowledge of retail banking and finance.

Skills

Oracle data warehousing

ETL

BI experience

SQL

PL/SQL

Banking domain knowledge

Tools

Oracle Data Integrator (ODI)

Oracle Analytics Server (OAS)

OBIEE

Job description

11409AC
£80k – 100k per year

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

Senior ODI ETL / OBIEE BI Developer

Due to the volume of applications received for positions, it will not be possible to respond to all applications and only applicants who are considered suitable for interview will be contacted.

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 http://proactive.it/privacy-notice/