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

Dudley
1 month ago
Applications closed

Related Jobs

View all jobs

Data Engineering Specialist

Data Engineer

Data Warehouse Engineer

Jr Data Engineer_London_Hybrid

Senior Data Engineer_London_Hybrid

Senior Data Engineer

Job Title: Data Warehouse Manager
Location: Dudley, West Midlands - Hybrid Working (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 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 ideally 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.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

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

Veterans in Tech: A Military‑to‑Civilian Pathway into AI Jobs

Published on ArtificialIntelligenceJobs.co.uk – empowering the UK talent pipeline for artificial intelligence, data, and robotics. Introduction Leaving the Armed Forces is both a proud milestone and a daunting leap into the unknown. Whether you served with the Royal Navy, British Army, Royal Air Force or Royal Marines, one thing is certain: the skills you forged under pressure are in high demand—especially in the booming field of artificial intelligence (AI).  The UK’s AI market is expected to contribute £400 billion to the economy by 2030, with defence and security applications at its core. Employers from start‑ups to FTSE‑100 giants are crying out for disciplined professionals who understand mission‑critical environments. Ex‑service personnel fit the bill perfectly. This guide maps the military‑to‑civilian journey, signposts Ministry of Defence (MoD) transition programmes, and shows you exactly how to land your first AI role. Quick Win: Bookmark our live listings for Machine Learning Engineer roles to see which employers are hiring right now.

AI Summit London 2025: A Complete Guide for UK AI Engineers & Recruiters

Artificial intelligence may be a border-less technology, but every ecosystem needs a beating heart where the community meets face-to-face. For the British Isles that heart is The AI Summit London, the headline AI event of London Tech Week, returning to Tobacco Dock on 11–12 June 2025. With eight content stages, 4 500+ attendees and 300 speakers spanning government, FTSE-100 giants and rocket-ship start-ups, the Summit offers a year’s worth of insight, deal-making and career acceleration in just 48 hours. Whether you are an AI engineer optimising vector databases, a data scientist pivoting into prompt ops, or a hiring manager scouring the market for talent, this handbook distils everything you need to hit the ground running—from ticket tactics and agenda highlights to networking hacks and post-event ROI.

AI Engineer World’s Fair 2025: The Complete UK Guide to June’s Unmissable AI Engineering Event

If 2024 was the year every product team rushed to bolt an LLM onto their roadmap, 2025 is when the craft of AI engineering finally takes centre stage. From rapid-fire prompt iterations to robust eval pipelines, the discipline now demands the same rigour we once reserved for cloud infra or mobile apps. That is precisely why the AI Engineer World’s Fair, 3–5 June 2025 in San Francisco, matters more than any keynote or press release: it is the one place where the movers, makers and maintainers of production-grade AI swap battle-tested patterns in person. For UK technologists—and the recruiters who hire them—the Fair offers a rare chance to compress a year’s worth of learning, networking and tooling discovery into three intense days. Whether you are scaling RAG systems on Azure, bootstrapping an agentic start-up from your kitchen table, or simply hunting for your first AI engineer job, the sessions, workshops and hallway conversations can tilt your career trajectory. The guide that follows distils everything you need to know—programme highlights, travel hacks, ticket tips and post-event ROI—so you can decide if a flight across the Atlantic (or a virtual pass) is the smartest investment you’ll make this year.