Oracle Data Warehouse Architect

Overview

My Financial Services client is seeking to recruit an Oracle Data Warehouse Architect on an initial 6 month contract for a Financial Services client based in London. It is hybrid and will require 3x days onsite per week. You will design, optimize, and maintain Oracle-based data warehouse solutions to ensure high performance, scalability, and alignment with business intelligence and analytics needs. This role requires the individual to design and optimize Oracle-based data warehouse systems, ensuring they are scalable, high-performing, and aligned with business analytics needs.Responsibilities

Collaborate closely with the head of the data team and .NET developers to apply advanced data modelling, performance tuning, and problem-solving skills.Translate complex technical insights into clear, actionable recommendations for both technical and non-technical stakeholders.Design and maintain Oracle-based data warehouse solutions to ensure stability, performance, and scalability in production and non-production environments.Monitor data integrity, system health, and capacity planning; troubleshoot and resolve issues related to data warehouse performance, ETL processes, and data availability.Coordinate with global Oracle support teams as needed and ensure coordination with development, application support, and technical teams to address data-related issues.Design and implement disaster recovery strategies for the Oracle Data Warehouse to ensure business continuity and alignment with enterprise recovery objectives.Support the rollout of development changes in collaboration with global DBA teams, ensuring proper documentation and version control of modifications.Participate in a second-line support rotation, including occasional early morning or late-night support during critical data loads or performance incidents.Qualifications

Strong experience in designing and developing efficient ETL processes to support enterprise-scale Oracle Data Warehouse environments.Proven ability to optimize and tune complex SQL and PL/SQL scripts for performance, while guiding development teams on best practices for data modelling, indexing, and partitioning strategies.Skilled in troubleshooting and resolving issues in ETL workflows and data pipelines, with a focus on maintaining data quality and system ..... full job details .....