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

Dudley
3 weeks ago
Create job alert

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

Related Jobs

View all jobs

Datawarehouse ERP Lead (Informatica, Azure Cloud, ETL, SQL, BI)

Datawarehouse Lead (ERP, Informatica, Azure, ETL, SQL, BI)

Datawarehouse Manager (ERP, Manufacturing, Azure, Cloud)

Data Engineer / Analytics Engineer

Data Engineer

Lead Data Engineer - MLOps

Get the latest insights and jobs direct. Sign up for our newsletter.

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

Industry Insights

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

Negotiating Your AI Job Offer: Equity, Bonuses & Perks Explained

Artificial intelligence (AI) has proven itself to be one of the most transformative forces in today’s business world. From smart chatbots in customer service to predictive analytics in finance, AI technologies are reshaping how organisations operate and innovate. As the demand for AI professionals grows, so does the complexity of compensation packages. If you’re a mid‑senior AI professional, you’ve likely seen job offers that include far more than just a base salary—think equity, bonuses, and a range of perks designed to entice you into joining or staying with a company. For many, the focus remains squarely on salary. While that’s understandable—after all, your monthly take‑home pay is what covers day-to-day expenses—limiting your negotiations to salary alone can leave considerable value on the table. From stock options in ambitious startups to sign‑on bonuses that ‘buy you out’ of your current contract, modern AI job offers often include elements that can significantly boost your long-term wealth and job satisfaction. This article aims to shed light on the full scope of AI compensation—specifically focusing on how equity, bonuses, and perks can enhance (or sometimes detract from) the overall value of your package. We’ll delve into how these elements work in practice, what to watch out for, and how to navigate the negotiation process effectively. Our goal is to provide mid‑senior AI professionals with the insights and tools to land a holistic compensation deal that accurately reflects their technical expertise, leadership potential, and strategic importance in this fast-moving field. Whether you’re eyeing a leadership role in machine learning at an established tech giant, or you’re considering a pioneering position at a disruptive AI startup, the knowledge in this guide will help you weigh the merits of base salary alongside the potential riches—and risks—of equity, bonuses, and other benefits. By the end, you’ll have a clearer sense of how to align your compensation with both your immediate lifestyle needs and long-term career aspirations.

AI Jobs in the Public Sector: MOD, NHS & Gov Digital Service Opportunities

Artificial intelligence (AI) has rapidly evolved from a niche field of computer science into a transformative force reshaping industries across the globe. From healthcare to finance and from education to defence, AI-driven tools and techniques are revolutionising how we approach problems, improve efficiency, and make data-driven decisions. Nowhere is this transformation more apparent than in the United Kingdom’s public sector. Key government entities, including the Ministry of Defence (MOD), the National Health Service (NHS), and the Government Digital Service (GDS), are increasingly incorporating AI into their operations. Consequently, AI jobs within these bodies are growing both in number and strategic importance. In this comprehensive blog post, we will explore the landscape of AI jobs across the UK public sector, with a close look at the MOD, the NHS, and the Government Digital Service. We will delve into the reasons these organisations are investing heavily in AI, the types of roles available, the essential skills and qualifications required, as well as the salary ranges one might expect. Whether you are a new graduate keen to make a meaningful impact through your technical skills or a seasoned professional looking for your next career move, the public sector offers a wealth of opportunities in AI. By the end of this article, you will have a clearer understanding of why AI is so crucial to the public sector’s success, which roles are in demand, and how you can tailor your application to stand out in a competitive and rewarding job market.

Contract vs Permanent AI Jobs: Which Pays Better in 2025?

n the ever-evolving world of technology, the competition for top talent in artificial intelligence (AI) is intense—and the rewards are significant. By 2025, AI roles in machine learning, natural language processing, data science, and robotics are expected to be among the highest-paid professions within the UK technology sector. As an AI professional, deciding between contracting (either as a day‑rate contractor or via fixed-term contracts) and permanent employment could drastically impact your take‑home pay, job security, and career trajectory. In this article, we will delve into the various types of AI roles in 2025—particularly focusing on day‑rate contracting, fixed-term contract (FTC) roles, and permanent positions. We will compare the earning potential across these three employment types, discuss the key pros and cons, and provide practical examples of how your annual take‑home pay might differ under each scenario. Whether you are already working in AI or looking to break into this booming field, understanding these employment options will help you make an informed decision on your next move.