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

Dudley
10 months ago
Applications closed

Related Jobs

View all jobs

Data Engineer

Data Engineer

Lead Data Engineer

Lead Data Engineer

Data Architect

Data Engineer

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

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.

Careers

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

Jobs

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

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

Education

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.