Engineer the Quantum RevolutionYour expertise can help us shape the future of quantum computing at Oxford Ionics.

View Open Roles

Oracle Data Warehouse Architect

London
1 week ago
Create job alert

Job Title: Oracle Data Warehouse Architect
Pay Rate: £415.16 PWD via Umbrella

Location: London

Hybrid model: 3:2 - Office: Home

Length of Contract: 6 Months

About Client: Headquartered in Tokyo, this banking group is Japan's second largest and a globally recognized financial institution with around US $2 trillion in assets. Operating in nearly 40 countries with over 80,000 employees, it offers corporate, retail, investment, and consumer banking services. A leader in sustainable finance, it drives major green and social initiatives while embracing digital innovation, including AI tools, to enhance efficiency and client experience.

About the Role:
We are seeking an experienced Oracle Data Warehouse Architect AVP to design, optimize, and maintain high-performance, scalable Oracle-based data warehouse solutions. This role is integral to supporting business intelligence and analytics initiatives and collaborating closely with .NET developers and global DBA teams across London, New York, and Ireland.

Key Responsibilities:

Design, implement, and optimize Oracle Data Warehouse systems, ensuring scalability, performance, and alignment with analytics needs.
Develop efficient ETL processes and optimize complex SQL and PL/SQL scripts.
Provide guidance on data modelling, indexing, and partitioning strategies.
Troubleshoot and resolve performance, ETL, and data pipeline issues while maintaining data quality.
Support .NET development teams with day-to-day database issues and liaise with global DBA teams.
Follow Change Management Control procedures for production updates and maintenance reporting.
Design and maintain disaster recovery strategies and ensure business continuity.
Serve as a technical consultant for cross-functional projects, advising on data architecture and performance optimization.Key Skills & Experience:

Strong expertise in Oracle Database, PL/SQL, SQL, ETL design, data modeling, indexing, and partitioning.
Experience in supporting enterprise-scale Oracle Data Warehouse environments.
Proven ability to troubleshoot complex data and ETL issues.
Familiarity with working in multi-location teams and providing second-line support.
Excellent problem-solving and communication skills to translate technical insights to stakeholders.Why Join Us:
This is a unique opportunity to work in a global, collaborative environment, contributing to critical enterprise-scale data solutions and shaping the architecture of our Oracle Data Warehouse systems.

Please be advised if you haven't heard from us within 48 hours then unfortunately your application has not been successful on this occasion, we may however keep your details on file for any suitable future vacancies and contact you accordingly.

Pontoon/Adecco is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive

Related Jobs

View all jobs

Oracle Data Warehouse Architect

Oracle Data Warehouse Architect

Cloud Data Architect

Data Engineer

Data Architect, Global PV Systems

Data Architect

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Pre-Employment Checks for Data Science Jobs: DBS, References & Right-to-Work and more Explained

Pre-employment screening in data science reflects the discipline's unique position at the intersection of statistical analysis, machine learning innovation, and strategic business intelligence. Data scientists often have privileged access to comprehensive datasets, proprietary algorithms, and business-critical insights that form the foundation of organisational strategy and competitive positioning. The data science industry operates within complex regulatory frameworks spanning GDPR, sector-specific data protection requirements, and emerging AI governance regulations. Data scientists must demonstrate not only technical competence in statistical modelling and machine learning but also deep understanding of research ethics, data privacy principles, and the societal implications of algorithmic decision-making. Modern data science roles frequently involve analysing personally identifiable information, financial data, healthcare records, and sensitive business intelligence across multiple jurisdictions and regulatory frameworks simultaneously. The combination of analytical privilege, predictive capabilities, and strategic influence makes thorough candidate verification essential for maintaining compliance, security, and public trust in data-driven insights and automated systems.

Why Now Is the Perfect Time to Launch Your Career in Data Science: The UK's Analytics Revolution

The United Kingdom stands at the forefront of a data science revolution that's reshaping how businesses make decisions, governments craft policies, and society tackles its greatest challenges. From the machine learning algorithms powering London's fintech innovation to the predictive models guiding Manchester's smart city initiatives, Britain's transformation into a data-driven economy has created an unprecedented demand for skilled data scientists that far outstrips the available talent. If you've been contemplating a career transition or seeking to position yourself at the cutting edge of the digital economy, data science represents one of the most intellectually stimulating, financially rewarding, and socially impactful career paths available today. The convergence of big data maturation, artificial intelligence mainstream adoption, business intelligence evolution, and cross-industry digital transformation has created the perfect conditions for data science career success.

Automate Your Data Science Jobs Search: Using ChatGPT, RSS & Alerts to Save Hours Each Week

Data science roles land daily across banks, product companies, consultancies, scaleups & the public sector—often buried in ATS portals or duplicated across boards. The fix: put discovery on rails with keyword-rich alerts, RSS feeds & a reusable ChatGPT workflow that triages listings, ranks fit, & tailors your CV in minutes. This copy-paste playbook is for www.datascience-jobs.co.uk readers. It’s UK-centric, practical, & designed to save you hours each week. What You’ll Have Working In 30 Minutes A role & keyword map spanning Core DS, Applied/Research, Product/Decision Science, NLP/CV, Causal/Experimentation, Time Series/Forecasting, MLOps-adjacent & Analytics Engineering overlaps. Shareable Boolean searches for Google & job boards that strip out noise. Always-on alerts & RSS feeds that bring fresh UK roles to you. A ChatGPT “Data Science Job Scout” prompt that deduplicates, scores match & outputs ready-to-paste actions. A simple pipeline tracker so deadlines & follow-ups never slip.