13 Data Warehouse jobs in the United Kingdom

Data Warehouse Engineer
Location: Newark
Salary: £35,000-£40,000

A well-established organisation in the Newark area is seeking a Data Warehouse Engineer to take ownership of its centralised data platform. With a current team member transitioning out at the end of July, this role is ideal for someone confident in SQL, data warehousing, and Power BI, who can hit the ground running in a collaborative, technically strong environment.

You'll join a close-knit data team and work alongside a colleague focused on reporting to deliver meaningful insights and maintain a robust, scalable data infrastructure. This position offers exposure to a wide range of ERP systems and an opportunity to shape the business's approach to data and reporting.

Key Responsibilities:
Manage and maintain the central data warehouse across multiple ERP platforms
Develop and optimise SQL queries to support reporting and data access
Build and maintain Power BI dashboards and visualisations
Collaborate with internal teams to understand reporting needs and translate them into data solutions
Ensure consistency, accuracy, and performance across data pipelines and warehouse models
Document and maintain clear data flows, models, and reporting logic

Requirements:
Strong experience with SQL (writing queries from scratch)
Proven ability to manage and optimise data warehouse environments
Hands-on experience with Power BI and related tools (e.g. DAX, Power Query)
Familiarity with ERP systems and large-scale, varied data sources
Some background in reporting and BI delivery
Excellent communication and problem-solving skills

This is a great opportunity for someone looking to take real ownership in a technically strong team, with the ability to directly influence reporting and data strategy from day one.

Data Warehouse Manager

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.

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.

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.

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.

Data Warehouse Solution Engineer

London | £80,000 – £90,000 (flexible for exceptional experience) + benefits

We’re searching for a skilled data engineering professional who enjoys solving complex problems and turning data into actionable insights. This role sits at the heart of a collaborative, forward-thinking team that values innovation, curiosity, and a willingness to take on new challenges.

In this position, you’ll be the primary owner of a recently deployed Azure-based data warehouse , ensuring it continues to evolve to meet the needs of a fast-growing organisation. You’ll partner with colleagues across technology, finance, and data governance to guarantee that data is accurate, secure, and ready to drive informed decisions.

With the platform foundation already in place, your mission will be to scale, optimise, and operationalise it — from designing new integrations to building tools and processes that extract

maximum business value.

Key Responsibilities

• Develop and maintain a roadmap for expanding the Azure data warehouse to support advanced reporting and analytics.
• Enhance and maintain the existing environment, embedding data engineering best practices.
• Design and implement ETL workflows, transformations, and data mapping solutions.
• Monitor and uphold data quality, privacy, and compliance with all relevant regulations.
• Improve performance and scalability while researching emerging data technologies.
• Act as a go-to expert for available datasets and collaborate with teams to design suitable data models.

Essential Skills & Experience

• 5+ years in data engineering, ideally at senior or lead level.
• Strong hands-on experience with Python , Azure Databricks , and Azure Synapse Analytics .
• Advanced SQL skills, including stored procedures and formal database design.
• Proven data modelling capabilities.
• Proficiency with Microsoft Azure data services and CI/CD pipelines.
• Experience integrating data across systems using APIs.
• Analytical mindset and excellent problem-solving abilities.
• Strong communication skills, able to work with both technical and non-technical stakeholders

Desirable Skills

• Knowledge of C# , Logic Apps , or Azure Integration Services.
• Experience with NoSQL or unstructured datasets.
• Familiarity with Power BI for dashboarding and reporting.
• Previous exposure to regulated environments (e.g., GDPR, ISO27001).

If you’re passionate about using modern cloud data technologies to deliver business impact — and want a role where you can directly influence data strategy — we’d love to hear from you.

Apply here: LinkedIn Job Link

#DataEngineering #Azure #DataWarehouse #SQL #Python #Hiring #LondonJobs #AzureDataEngineer

Data Warehouse Solution Engineer

London | £80,000 – £90,000 (flexible for exceptional experience) + benefits

We’re searching for a skilled data engineering professional who enjoys solving complex problems and turning data into actionable insights. This role sits at the heart of a collaborative, forward-thinking team that values innovation, curiosity, and a willingness to take on new challenges.

In this position, you’ll be the primary owner of a recently deployed Azure-based data warehouse , ensuring it continues to evolve to meet the needs of a fast-growing organisation. You’ll partner with colleagues across technology, finance, and data governance to guarantee that data is accurate, secure, and ready to drive informed decisions.

With the platform foundation already in place, your mission will be to scale, optimise, and operationalise it — from designing new integrations to building tools and processes that extract

maximum business value.

Key Responsibilities

• Develop and maintain a roadmap for expanding the Azure data warehouse to support advanced reporting and analytics.
• Enhance and maintain the existing environment, embedding data engineering best practices.
• Design and implement ETL workflows, transformations, and data mapping solutions.
• Monitor and uphold data quality, privacy, and compliance with all relevant regulations.
• Improve performance and scalability while researching emerging data technologies.
• Act as a go-to expert for available datasets and collaborate with teams to design suitable data models.

Essential Skills & Experience

• 5+ years in data engineering, ideally at senior or lead level.
• Strong hands-on experience with Python , Azure Databricks , and Azure Synapse Analytics .
• Advanced SQL skills, including stored procedures and formal database design.
• Proven data modelling capabilities.
• Proficiency with Microsoft Azure data services and CI/CD pipelines.
• Experience integrating data across systems using APIs.
• Analytical mindset and excellent problem-solving abilities.
• Strong communication skills, able to work with both technical and non-technical stakeholders

Desirable Skills

• Knowledge of C# , Logic Apps , or Azure Integration Services.
• Experience with NoSQL or unstructured datasets.
• Familiarity with Power BI for dashboarding and reporting.
• Previous exposure to regulated environments (e.g., GDPR, ISO27001).

If you’re passionate about using modern cloud data technologies to deliver business impact — and want a role where you can directly influence data strategy — we’d love to hear from you.

Apply here: LinkedIn Job Link

#DataEngineering #Azure #DataWarehouse #SQL #Python #Hiring #LondonJobs #AzureDataEngineer

At Clarion, our people are at the absolute heart of what we do. We’re proud that our core values of PASSION , CARE , IMAGINATION , and TRUST define the way we carry out our work across all of our exhibitions and conferences.

If you share our values and want to be a part of a successful, dynamic, and creative global business then we want to hear from you.

The Opportunity:

We have an exciting opportunity for a Data Warehouse Architect to join a rapidly growing data team in Clarion. The role will report into the Senior Architect, with responsibility to analyse product offerings against business requirements. Working with the Analytics team, developers, and testers you will be evaluating and identifying solutions to meet business needs. You will have the autonomy to be creative with design techniques, seeking to overcome complex challenges, and grow your design through developing skills with the new initiatives we are looking to explore.

Key Responsibilities:

• Analyse existing data design and suggest improvements that promote performance, stability, and interoperability.
• Work with product management and business subject matter experts to translate business requirements into good database design.
• Work with internal and external resources to develop robust Extract/Transform/Load (ETL) processes for disparate data sources.
• Strong knowledge of setting up and maintaining synapse pipelines within Azure.
• Good knowledge of acquiring data from various Rest, Soap, SFTP, Landing Zones and obtaining data for processing within Azure.
• Strong knowledge of setting up and maintaining deployment pipelines within Azure devops.
• Participate in the development of database architecture and roadmaps in support of business strategies.
• Provide technical expertise, estimates, and recommendations to the Senior Architect and Head of Data and Insight.
• Participate in the evaluation of emerging technology and tools.
• Provide technical expertise, estimates, recommendations, risks, and issues to Senior Architect and/or Project Management.
• Cloud security and compliance: Ensure that all data solutions comply with industry standards and company policies regarding security, data privacy, and compliance.
• Cost management and optimisation: Monitor and optimise cloud spending to ensure efficient use of Azure resources. Implement cost-saving measures such as automated scaling, choosing the right service tiers, and identifying underutilised resources.
• Develop and maintain disaster recovery and business continuity plans for Azure-based data solutions, ensuring minimal downtime and data loss in the event of a disruption.
• Regularly analyse system performance against key metrics, identify bottlenecks, and implement optimisations to improve efficiency and reduce latency.
• Design and manage dimensional data models and data warehousing strategies to support BI and analytics workloads. Ensure scalability and flexibility to accommodate future data growth.

Requirements

Knowledge, Skills & Behaviours:

• Proven experience as a data architect delivering solutions utilising:
• Azure Data Analytics platform including Azure Synaps
• Azure Logic Apps, Azure Functions, Azure Storage
• Azure SQL Data Warehouse, Azure Data Lake, Azure Databricks
• Azure Cosmos DB, Azure Data Factory, Azure Search, Azure Stream Analytics
• Delta Lake and Data Lakes
• Apache Spark Pools, SQL Pools (dpools and spools)
• Experience in Python, C# coding, Spark, PySpark, Unix shell/Perl scripting experience.
• Experience in API data sourcing using REST, Soap, and other API methodologies.
• Experience working with structured and unstructured data.
• Project management/agile delivery methodology in a leading role as part of a wider team.
• Power BI development experience using Azure technology and providing data.
• Experience designing and implementing machine learning solutions as part of high-volume data ingestion and transformation pipelines.
• Data Governance, Data Quality, MDM, Lineage, Data Catalog etc.
• Development experience using Presto/Hive, Digdag, YAML.

About Clarion Events

Clarion Events is one of the world’s leading event organisers, producing and delivering innovative and market-leading events since 1947. ( )

Clarion Events embrace diversity and equal opportunities in all that we do. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

Clarion is private equity backed and owned by Blackstone. Blackstone is one of the world’s leading global investment funds, investing capital for the long term in order to build successful, resilient businesses. ( )

Our purpose is to deliver exceptional customer outcomes and experiences, by making every connection count.

Our vision is we want every one of our products to be a market leader in customer satisfaction and delight.

Benefits

• 25 days’ holiday plus bank holidays
• End of year wellbeing shutdown (closed for the last week of the year)
• Celebration day off (e.g. birthday, Diwali, Eid, etc)
• Summer Hours in August (3pm finish on Fridays)
• Helping Our World (HOW) Days – one paid day per quarter to carry out charity work
• Pension Scheme
• Private Medical Insurance
• Health Cash Plan
• Wellbeing Library (MYNDUP)
• Mentoring Programme
• Subsidised Café
• Season Ticket Loan
• Cycle to Work Schemes
• Free on-site gym and shower facilities
• Free eyesight tests
• Free flu vaccination – offered on site once a year for all employees