Careers

Senior ODI ETL & OAS BI Banking Data Developer

ID: 008

2 year fixed term contract.

Department: IT

Reports to: Head of IT                                       

Controlled Function: N/A

Location: London                                                                                               

Hours of work: Full-time, Monday to Friday the role is based 5 days in the office

Job Purpose:

  • We are seeking a motivated, hands-on and experienced senior ODI ETL and OAS BI developer with prior experience in the banking industry with Oracle Flexcube, ERP and ideally Finastra OPICS.
  • In this role you will play a crucial part in the design, development and ongoing management of data warehouse and marts using Oracle Data Integrator (ODI) and Oracle Analytics Server (OAS). You will help build, optimise and support ETL pipelines, ensuring seamless integration between financial systems, and developing high-quality reports, extracts and insights covering banking and finance data.

Main Responsibilities:

  1. Data Warehouse Management:
    • Design, implement and manage data warehouse schemas and data marts to store and organize volumes of data.
    • Implement data models and schemas to support efficient data retrieval and analysis.
    • Perform regular maintenance and updates to ensure the data warehouse, marts and services operate smoothly.
  2. Data Management:
    • Manage and optimize data to ensure efficient data storage and retrieval.
    • Write complex SQL queries to manipulate and analyse data.
  3. Data Integration:
    • Integrate data from multiple sources, ensuring seamless data flow and consistency.
    • Collaborate with IT and business teams to understand data requirements and implement integration solutions.
  4. ETL Development and Maintenance:
    • Design, develop, and maintain ETL processes using Oracle Data Integrator (ODI).
    • Ensure data quality, consistency, and integrity throughout the ETL pipeline.
    • Optimize ETL workflows for performance and scalability.
  5. Business Intelligence Development:
    • Develop and maintain BI solutions using Oracle Analytics Server.
    • Create interactive dashboards, reports, and visualizations to support business decision-making.
    • Perform data analysis to derive actionable insights and present findings to stakeholders.
  6. Retail Banking & Accounting Knowledge:
    • Apply domain knowledge of retail banking and accounting to understand data requirements and provide relevant insights.
    • Ensure compliance with industry regulations and standards.

Experience & Skills required:

  1. Technical:
    • 5+ years of industry experience of Oracle databases and data warehousing principles, design and implementation.
    • Proficient in ODI ETL, OAS BI, Oracle Forms, PL/SQL and SQL.
    • Experience with ER modelling and data modelling tools.
    • Proven ability to translate business requirements into maintainable technology deliveries.
  2. Domain:
    • Understanding of Flexcube core banking modules and Oracle ERP, data structures and interfacing.
    • Experience in data analysis with strong focus on retail banking, treasury products and accounting data.
  3. Analytical
    • Ability to analyse complex data sets and derive actionable insights.
    • Strong problem-solving skills to address data-related issues.
  4. Professional
    • Ability to communicate technical concepts to non-technical stakeholders.
    • Collaboration with cross-functional teams to understand data needs and deliver solutions.
    • Ability to work independently and as part of a team.

Applicants must have the right to work in the UK. Proof of eligibility will be required as part of the hiring process.

Apply now