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

Dudley
5 days 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 Manager (ERP, Manufacturing, Azure, Cloud)

Data Engineer

Data Scientist

UK 2025 Data Engineer Internship

Lead Data Engineer

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.

AI Programming Languages for Job Seekers: Which Should You Learn First to Launch Your AI Career?

Artificial Intelligence (AI) is no longer confined to academic research; it now sits at the core of countless modern industries. From healthcare diagnostics powered by machine learning to autonomous driving and natural language processing, organisations are investing heavily in AI capabilities. This surge in AI adoption has created a thriving job market for talented professionals—data scientists, machine learning engineers, AI researchers, and more. Yet if you’re aiming to break into this fast-growing field, one of the first questions you’ll ask is, “Which AI programming language should I learn first?” Given the array of options available—Python, R, Java, C++, Julia, among others—understanding the strengths, community support, and industry relevance of each is crucial. In this extensive guide, tailored for www.artificialintelligencejobs.co.uk, we’ll explore the top AI programming languages that can help you stand out to employers, accelerate your learning curve, and equip you with the skills to succeed in a competitive job market. By addressing both beginners and experienced programmers, we aim to provide actionable insights to help you choose the right language, master essential tools, and build a compelling career in AI.

UK Visa & Work Permits Explained: Your Essential Guide for International AI Talent

The United Kingdom has long been a hub of innovation, drawing some of the world’s brightest minds to its shores. In recent years, the country’s thriving technology ecosystem has been propelled by advances in Artificial Intelligence (AI), Machine Learning (ML), Robotics, Data Science, and related fields. From deep-tech start-ups in Silicon Roundabout to established global powerhouses, the UK remains at the forefront of AI research and development. Yet, for international AI professionals hoping to contribute to the UK’s tech growth, one of the most challenging hurdles can be understanding the visa and work permit landscape. The UK immigration system has its unique nuances, and it can be overwhelming to decide which route is best suited for your career aspirations. This comprehensive guide will help you navigate the main visa and work permit options for AI professionals, provide insight into the eligibility criteria, and offer practical tips on securing your dream role in the British AI sector.

Top UK AI Research Labs & Institutes: Best Places for AI Jobs

In recent years, the United Kingdom has emerged as one of the leading global hubs for artificial intelligence (AI) innovation. With a strong academic tradition, active technology communities, and robust government support, the UK has seen the rise of numerous world-class AI research labs and institutes. Many of these organisations not only drive significant academic breakthroughs but also foster powerful industry collaborations, creating thriving ecosystems where talent, investment, and creativity converge. If you are keen on pursuing an AI career—be it in academia or industry—understanding where these AI powerhouses are located, what they specialise in, and how they collaborate can help you map a clear route to success. In this blog post, written specifically for ArtificialIntelligenceJobs.co.uk, we delve into the top UK AI research labs and institutes, outline the career paths available, and highlight how you can be at the heart of Britain’s AI innovation.