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

Dudley

1 month ago

Applications closed

Related Jobs

View all jobs

Data Warehouse Manager

Data Engineering Lead / Data Architect

Data Engineering Lead

Business Intelligence Lead

Data Engineer - London

Informatica BDM/IDMC Technical Lead

Job Title: Data Warehouse Manager
Location: Dudley, West Midlands - Hybrid Working (ideally 2 days a week onsite, rest remote)
Job Type: Full time, Permanent
Salary: £70k - £90K Base Per Annum DOE, Plus Standard Company Benefits (Pension etc)

Our leading, Midlands based manufacturing client is seeking a hands on, technical Data Warehouse Lead/Manager with ERP and Azure Cloud experience, 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 Informatica.
Experience using both Cloud (Azure) and On-prem data platform configurations.
Working within an end-to-end BI lifecycle.
Experience with development using the Microsoft Fabric suite of tools is preferred.
Knowledge and experience of working with ERP systems - essential.
Experience of working with ERP systems within the manufacturing industry a big plus.
Team Leading/Management experience.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

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

Industry Insights

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

May 30, 2025

Careers Education

Top 10 Best UK Universities for Data Science Degrees (2025 Guide)

Discover ten of the strongest UK universities for Data Science degrees in 2025. Compare entry requirements, course content, research strength and industry links to choose the right programme for you. Data is the currency of the modern economy, and professionals who can wrangle, model and interpret vast datasets are in demand across every sector—from biotechnology and finance to sport and public policy. UK universities have been at the forefront of statistics, artificial intelligence and large-scale computing for decades, making the country a prime destination for aspiring data scientists. Below, we profile ten institutions whose undergraduate or postgraduate pathways excel in data science. Although league tables vary each year, these universities have a proven record of excellence in teaching, research and industry collaboration.

May 25, 2025

Jobs Careers

Veterans in Data Science: A Military‑to‑Civilian Pathway into Analytical Careers

Introduction The UK Government’s National AI Strategy projects that data‑driven innovation could add £630 billion to the economy by 2035. Employers across healthcare, defence, and fintech are scrambling for professionals who can turn raw data into actionable insights. In 2024 alone, job‑tracker Adzuna recorded a 42 % year‑on‑year rise in data‑science vacancies, with average advertised salaries surpassing £65k. For veterans, that talent drought is a golden opportunity. Whether you plotted artillery trajectories, decrypted enemy comms, or managed aircraft engine logs, you have already practised the fundamentals of hypothesis‑driven analysis and statistical rigour. This guide explains how to translate your military experience into civilian data‑science language, leverage Ministry of Defence (MoD) transition programmes, and land a rewarding role building predictive models that solve real‑world problems. Quick Win: Take a peek at our live Junior Data Scientist roles to see who’s hiring this week.

May 15, 2025

Jobs

Quantum-Enhanced AI in Data Science: Embracing the Next Frontier

Data science has undergone a staggering transformation in the past decade, evolving from a niche academic discipline into a linchpin of modern industry. Across every sector—finance, healthcare, retail, manufacturing—data scientists have become indispensable, leveraging statistical methods and machine learning to turn raw information into actionable insights. Yet as datasets grow ever larger and machine learning models become more computationally expensive, there are genuine questions about how far current methods can be pushed. Enter quantum computing, a nascent but promising technology grounded in the counterintuitive principles of quantum mechanics. Often dismissed just a few years ago as purely experimental, quantum computing is quickly gaining traction as prototypes evolve into cloud-accessible machines. When paired with artificial intelligence—particularly in the realm of data science—the results could be game-changing. From faster model training and complex optimisation to entirely new forms of data analysis, quantum-enhanced AI stands poised to disrupt established practices and create new opportunities. In this article, we will: Explore how data science has reached its current limits in certain areas, and why classical hardware might no longer suffice. Provide an accessible overview of quantum computing concepts and how they differ from classical systems. Examine the potential of quantum-enhanced AI to solve key data science challenges, from data wrangling to advanced machine learning. Highlight real-world applications, emerging job roles, and the skills you need to thrive in this new landscape. Offer actionable steps for data professionals eager to stay ahead of the curve in a rapidly evolving field. Whether you’re a practising data scientist, a student weighing up your future specialisations, or an executive curious about the next technological leap, read on. The quantum era may be closer than you think, and it promises to radically transform the very fabric of data science.