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

Dudley
9 months ago
Applications closed

Related Jobs

View all jobs

Data Engineer

Data Engineering Team Lead

Data Engineer

Data Engineer

Data Engineer

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.

Jobs Careers

Data Engineering Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data engineering in your 30s, 40s or 50s? You’re not alone. In the UK, companies of all sizes — from fintechs to government agencies, retailers to healthcare providers — are building data teams to turn vast amounts of information into insight and value. That means demand for data engineering talent remains strong, but there’s a gap between media hype and the real pathways available to mid-career professionals. This guide gives you the straight UK reality check: which data engineering roles are genuinely open to career switchers, what skills employers actually look for, how long retraining really takes and how to position your experience for success.

Jobs

How to Write a Data Engineering Job Ad That Attracts the Right People

Data engineering is the backbone of modern data-driven organisations. From analytics and machine learning to business intelligence and real-time platforms, data engineers build the pipelines, platforms and infrastructure that make data usable at scale. Yet many employers struggle to attract the right data engineering candidates. Job adverts often generate high application volumes, but few applicants have the practical skills needed to build and maintain production-grade data systems. At the same time, experienced data engineers skip over adverts that feel vague, unrealistic or misaligned with real-world data engineering work. In most cases, the issue is not a shortage of talent — it is the quality and clarity of the job advert. Data engineers are pragmatic, technically rigorous and highly selective. A poorly written job ad signals immature data practices and unclear expectations. A well-written one signals strong engineering culture and serious intent. This guide explains how to write a data engineering job ad that attracts the right people, improves applicant quality and positions your organisation as a credible data employer.

Education Jobs

Maths for Data Engineering Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data engineering jobs in the UK, maths can feel like a vague requirement hiding behind phrases like “strong analytical skills”, “performance mindset” or “ability to reason about systems”. Most of the time, hiring managers are not looking for advanced theory. They want confidence with the handful of maths topics that show up in real pipelines: Rates, units & estimation (throughput, cost, latency, storage growth) Statistics for data quality & observability (distributions, percentiles, outliers, variance) Probability for streaming, sampling & approximate results (sketches like HyperLogLog++ & the logic behind false positives) Discrete maths for DAGs, partitioning & systems thinking (graphs, complexity, hashing) Optimisation intuition for SQL plans & Spark performance (joins, shuffles, partition strategy, “what is the bottleneck”) This article is written for UK job seekers targeting roles like Data Engineer, Analytics Engineer, Platform Data Engineer, Data Warehouse Engineer, Streaming Data Engineer or DataOps Engineer.

🍪 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.