Data Warehouse Lead (ERP, SQL, BI, ETL)

Dudley
11 months ago
Applications closed

Related Jobs

View all jobs

Data Science / Data Mining Specialist

Data Scientist

Senior Data Scientist

Data Scientist

Data Science Manager – Property Tech – London

Data Scientist - Supply Chain Optimisation

Job Title: Data Warehouse Manager
Location: Dudley, West Midlands - Hybrid Working
Job Type: Full time, Permanent
Salary: £70k - £90K Base per annum (Depending on experience) Plus Standard Company Benefits

Our leading, Midlands based manufacturing client is seeking a hands on, technical Data Warehouse Lead/Manager to oversee the design, development and maintenance of their data hub, as part of their corporate data warehouse solutions.

As well as being responsible for the design and development of the data platform, this is also a hands on role - 60% hands on development with 40% Team Leading including work allocation, pastoral care. The Datawarehouse Manager will have 2 people in the US to lead, along with a BI Analyst.

Responsibilities:

Designing, building, testing, and documenting ETL/ELT solutions.
Ensuring up-to-date and accurate documentation, including lineage, for all production solutions.
Monitoring and optimising the performance of data warehouse systems.
Managing data models, schemas, and metadata repositories.
Maintaining operational data warehouse builds and resolving issues promptly.
Ensuring adherence to agreed standards and controls for data marts and operational data stores.
Leading the release and promotion of new solutions to enhance functionality and productivity.Requirements:

Experience designing, writing, editing, debugging and testing advanced SQL code, stored procedures and database schemas for Microsoft SQL Server and ideally Oracle as well.
Data warehousing, data modelling, insights creation, data science, cloud solutions and data management.
ETL development and orchestration experience using Azure Data Factory and ideally Informatica.
Experience using both Cloud (Azure) and On-prem data platform configurations.
Working within an end-to-end BI life-cycle.
Experience with development using the Microsoft Fabric suite of tools is preferred.
Knowledge and experience of working with ERP systems within the manufacturing industryOur client is ideally looking for someone who is located in the Midlands and able to come into the office a couple of days a week.

If this opportunity appeals to you and aligns closely to your background - please submit your application to Jackie Dean at Jumar for consideration.

Jumar takes great pride in representing socially responsible clients who not only prioritise diversity and inclusion but also actively combat social inequality. Together, we have the power to make a profound impact on fostering a more equitable and inclusive society. By working with us, you become part of a movement dedicated to promoting a diverse and inclusive workforce

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.

New AI Employers to Watch in 2026: UK and Global Companies Reshaping AI Careers

The artificial intelligence job market in the UK is evolving at an extraordinary pace. With record-breaking investment, government backing, and a surge in enterprise adoption, the landscape of AI employers is shifting rapidly. For candidates exploring opportunities on ArtificialIntelligenceJobs.co.uk, understanding who is hiring next is just as important as understanding what skills are in demand. In this article, we explore the new and emerging AI employers to watch in 2026, focusing on organisations that have recently secured funding, won major contracts, or expanded their UK footprint. From cutting-edge startups to global giants doubling down on Britain, these companies represent the next wave of AI career opportunities.

How Many AI Tools Do You Need to Know to Get an AI Job?

If you are job hunting in AI right now it can feel like you are drowning in tools. Every week there is a new framework, a new “must-learn” platform or a new productivity app that everyone on LinkedIn seems to be using. The result is predictable: job seekers panic-learn a long list of tools without actually getting better at delivering outcomes. Here is the truth most hiring managers will quietly agree with. They do not hire you because you know 27 tools. They hire you because you can solve a problem, communicate trade-offs, ship something reliable and improve it with feedback. Tools matter, but only in service of outcomes. So how many AI tools do you actually need to know? For most AI job seekers: fewer than you think. You need a tight core toolkit plus a role-specific layer. Everything else is optional. This guide breaks it down clearly, gives you a simple framework to choose what to learn and shows you how to present your toolset on your CV, portfolio and interviews.

What Hiring Managers Look for First in AI Job Applications (UK Guide)

Hiring managers do not start by reading your CV line-by-line. They scan for signals. In AI roles especially, they are looking for proof that you can ship, learn fast, communicate clearly & work safely with data and systems. The best applications make those signals obvious in the first 10–20 seconds. This guide breaks down what hiring managers typically look for first in AI applications in the UK market, how to present it on your CV, LinkedIn & portfolio, and the most common reasons strong candidates get overlooked. Use it as a checklist to tighten your application before you click apply.