At a Glance
- Tasks: Design and manage data warehousing solutions for banking and financial systems.
- Company: Join a long-established international financial institution with a strong UK presence.
- Benefits: Competitive salary, hybrid working environment, and opportunities for professional growth.
- Why this job: Make an impact in the finance sector while developing your technical skills.
- Qualifications: 5+ years of experience in Oracle databases and data warehousing design.
- Other info: Collaborative culture with a focus on diversity, equity, and inclusion.
The predicted salary is between 36000 - 60000 Β£ per year.
We are recruiting on behalf of an international financial institution operating in the UK, who are seeking a Senior ODI ETL & OAS/OBIEE BI Banking Data Developer to join their team on a 2-year fixed-term contract. London based.
The Senior ODI ETL & OAS/OBIEE BI Banking Data Developer will play a key role in the design, development, and ongoing management of data warehousing solutions, advanced analytics, and data integration processes across core banking and financial systems.
Key responsibilities include:
- Data Warehouse Management
- Design, implement, and manage data warehouse schemas and data marts to store and organise high-volume banking and financial datasets.
- Implement data models and schemas to support efficient data retrieval and analysis.
- Perform regular maintenance, enhancements, and updates to ensure smooth operation of warehouse services.
- Data Management
- Manage, optimise, and maintain data for efficient storage and retrieval.
- Write complex SQL and PL/SQL queries to manipulate, transform, and analyse data.
- Data Integration
- Integrate data from multiple internal and external systems, ensuring seamless data flow, consistency, and quality.
- Collaborate closely with IT and business teams to understand data needs and deliver effective integration solutions.
- ETL Development & Maintenance
- Design, develop, and maintain ETL pipelines using Oracle Data Integrator (ODI).
- Ensure data quality, consistency, and integrity throughout the ETL life cycle.
- Optimise workflows for performance, scalability, and reliability.
- Business Intelligence Development
- Develop and maintain Business Intelligence solutions using Oracle Analytics Server (OAS/OBIEE).
- Build interactive dashboards, reports, extracts, and visualisations to support banking and finance decision-making.
- Perform data analysis and present insights to technical and non-technical stakeholders.
- Retail Banking & Accounting Knowledge
- Apply understanding of retail banking, treasury products, and accounting to interpret data requirements accurately.
- Ensure compliance with industry standards and financial regulations.
Profile
- Domain Expertise
- Strong understanding of core banking systems such as Flexcube, Oracle ERP, and associated data structures and interfaces.
- Experience working with retail banking, treasury products, and accounting datasets.
- Technical Skills
- 5+ years of hands-on industry experience with Oracle databases and data warehousing design principles.
- Proficient in ODI ETL, OAS/OBIEE, PL/SQL, SQL, and Oracle Forms.
- Experience with ER modelling and data modelling tools.
- Proven ability to translate business and regulatory requirements into robust technical solutions.
- Analytical Skills
- Ability to analyse complex data sets and derive actionable insights.
- Strong problem-solving skills to diagnose and resolve data-related issues efficiently.
- Professional Skills
- Excellent communication skills, able to explain technical concepts to non-technical teams.
- Ability to collaborate across cross-functional departments including finance, IT, and operations.
- Capable of working independently as well as part of a team.
Company
A long-established, international financial institution with a strong presence in the UK market. Hybrid working environment, London based.
Salary & Benefits
The salary range/rates of pay are dependent upon your experience, qualifications, and training.
Senior ODI ETL & OAS/OBIEE BI Banking Data Developer in London employer: Robert Half
Contact Detail:
Robert Half Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Senior ODI ETL & OAS/OBIEE BI Banking Data Developer in London
β¨Tip Number 1
Network like a pro! Reach out to your connections in the banking and finance sector. Attend industry events or webinars, and donβt be shy about asking for introductions. We all know that sometimes itβs not just what you know, but who you know!
β¨Tip Number 2
Prepare for those interviews by brushing up on your technical skills. Make sure you can confidently discuss your experience with ODI ETL, OAS/OBIEE, and SQL. We recommend doing some mock interviews with friends or using online platforms to get comfortable with the questions you might face.
β¨Tip Number 3
Showcase your projects! If youβve worked on any relevant data warehousing or BI solutions, create a portfolio or case studies to share during interviews. This will help us see your hands-on experience and how you tackle real-world problems.
β¨Tip Number 4
Donβt forget to apply through our website! Itβs the best way to ensure your application gets noticed. Plus, we love seeing candidates who take the initiative to engage directly with us. So, go ahead and hit that apply button!
We think you need these skills to ace Senior ODI ETL & OAS/OBIEE BI Banking Data Developer in London
Some tips for your application π«‘
Tailor Your CV: Make sure your CV is tailored to the job description. Highlight your experience with ODI ETL, OAS/OBIEE, and any relevant banking data projects. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Share specific examples of your past work that relate to data warehousing and integration processes.
Showcase Your Technical Skills: Donβt forget to emphasise your technical skills in SQL, PL/SQL, and data modelling. We love seeing candidates who can demonstrate their expertise and how theyβve applied it in real-world scenarios.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you donβt miss out on any important updates!
How to prepare for a job interview at Robert Half
β¨Know Your Tech Inside Out
Make sure you brush up on your knowledge of Oracle Data Integrator (ODI), OAS/OBIEE, and SQL. Be prepared to discuss your past projects and how you've used these tools to solve real-world problems in data warehousing and integration.
β¨Showcase Your Analytical Skills
Prepare to demonstrate your ability to analyse complex datasets. Think of examples where you've derived actionable insights from data and be ready to explain your thought process clearly to both technical and non-technical stakeholders.
β¨Understand the Business Context
Familiarise yourself with retail banking and treasury products. Being able to relate your technical skills to the business needs will show that you understand the bigger picture and can contribute effectively to the team.
β¨Practice Your Communication
Since you'll need to collaborate with various departments, practice explaining technical concepts in simple terms. This will help you convey your ideas clearly during the interview and demonstrate your excellent communication skills.