Oracle Data Warehouse Architect

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. They will collaborate closely with the head of the data team and .NET developers, applying advanced data modelling, performance tuning, and problem-solving skills. The ideal candidate will be able to translate complex technical insights into clear, actionable recommendations for both technical and non-technical stakeholders.

Skills Required:

• 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 reliability.
• This role may occasionally require early morning or late-night support as part of a second-line support rotation, particularly during critical data loads or performance incidents.
• Ensure the stability, performance, and scalability of production and non-production Oracle Data Warehouse environments, including regular monitoring of data integrity, system health, and capacity planning.
• Troubleshoot and resolve issues related to data warehouse performance, ETL processes, and data availability, including coordination with global Oracle support teams in New York and Ireland when necessary.
• Design and maintain disaster recovery strategies for the Oracle Data Warehouse, ensuring business continuity and alignment with enterprise recovery objectives.
• Collaborate with development, application support, and technical teams to address data-related issues, acting as a second-line support resource for complex warehouse and ETL challenges.
• Engage with global technical teams to review and discuss architectural improvements, performance trends, and development impacts on the data warehouse environment.
• Serve as a technical consultant on data architecture, modelling, and performance optimization for cross-functional projects and initiatives.
• Evaluate the impact of proposed changes by development teams on the data warehouse structure and performance, recommending alternative solutions where appropriate.
• Support the rollout of development changes in collaboration with global DBA teams, ensuring proper documentation and version control of all modifications.