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

Dudley
1 week 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

Data Warehouse Lead

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

Datawarehouse Manager (ERP, Manufacturing, Azure, Cloud)

BI / Datawarehouse Lead / Manager – Home / Prestigious Client

Data Analyst

Lead Reporting and Data Analyst

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.

Data Engineering vs. Data Science vs. Data Analytics Jobs: Which Path Should You Choose?

In the modern data-driven era, businesses in every sector—retail, finance, healthcare, and beyond—are constantly gathering large volumes of information to power insights and fuel decision-making. Consequently, the demand for data professionals has skyrocketed, with Data Engineering jobs in particular experiencing rapid growth. However, many job seekers remain unsure about how Data Engineering differs from Data Science or Data Analytics, or which role aligns best with their interests and career aspirations. This comprehensive guide will demystify the key differences among Data Engineering, Data Science, and Data Analytics. We’ll explore overlapping and distinctive skills, delve into typical job responsibilities, discuss salary ranges, and provide real-world examples of each role in action. By the end, you’ll have a clearer understanding of which path might suit you best. And when you’re ready to move forward, visit www.dataengineeringjobs.co.uk to explore the latest vacancies and take the next step in your data-focused career.

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

In an era where data is fueling decision-making and driving innovation across industries, data engineering has emerged as a pivotal career path. Rather than just collecting and storing information, data engineers design and maintain sophisticated pipelines that transport, transform, and store massive datasets—enabling data scientists, analysts, and business teams to glean meaningful insights. If you’re researching opportunities on www.dataengineering.co.uk, you may be wondering: “Which programming language should I learn first for a career in data engineering?” It’s a great question. Data engineering spans a wide range of tasks—ETL pipelines, real-time streaming, data warehousing, big data frameworks, and more—requiring a versatile toolset. Languages like SQL, Python, Scala, Java, Go, and R each play unique roles in building robust data infrastructures. In this guide, you’ll discover: Detailed overviews of the top programming languages in data engineering. Pros, cons, and industry relevance for each language. A simple beginner’s project to sharpen your data engineering skills. Essential resources and tips to help you thrive in the job market.

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

Data engineering has become a foundational pillar for organisations seeking to leverage their data assets effectively. From building robust data pipelines and integrating real-time analytics to migrating entire infrastructures to the cloud, skilled data engineers drive innovation and growth. In the United Kingdom, demand for data engineering professionals spans multiple sectors, including finance, healthcare, retail, tech start-ups, and government services. However, if you’re an international data engineering specialist looking to build or advance your career in the UK, one critical step stands before you: navigating the visa and work permit landscape. This comprehensive guide breaks down key visa routes, eligibility criteria, and practical steps to help you secure employment and settle into the UK’s thriving data ecosystem. Whether you specialise in ETL processes, big data platforms, or cloud infrastructure, understanding the UK visa system is the first step toward realising your ambitions.