Job Description
Job Title: Data Warehouse Manager
Location: Dudley, West Midlands - Hybrid Working
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. This role involves 60% hands-on development and 40% team leadership, including work allocation and pastoral care. The Data Warehouse Manager will lead a team of two in the US and collaborate with a BI Analyst.
Responsibilities:
1. Design, build, test, and document ETL/ELT solutions.
2. Maintain accurate documentation, including lineage, for all production solutions.
3. Monitor and optimize the performance of data warehouse systems.
4. Manage data models, schemas, and metadata repositories.
5. Maintain operational data warehouse builds and resolve issues promptly.
6. Ensure adherence to standards and controls for data marts and operational data stores.
7. Lead the release and deployment of new solutions to improve functionality and productivity.
Requirements:
1. Proven experience designing, writing, debugging, and testing advanced SQL code, stored procedures, and database schemas for Microsoft SQL Server and preferably Oracle.
2. Experience in data warehousing, data modeling, insights creation, data science, cloud solutions, and data management.
3. ETL development and orchestration experience using Azure Data Factory and ideally Informatica.
4. Experience with both Cloud (Azure) and on-premises data platform configurations.
5. Familiarity with the full BI lifecycle.
6. Experience with Microsoft Fabric tools is desirable.
7. Knowledge of working with ERP systems within the manufacturing industry.
8. Team leadership and management experience.
Our client prefers candidates located in the Midlands due to weekly travel to Dudley offices.
If this opportunity aligns with your background, please submit your application to Jackie Dean at Jumar for consideration.
Jumar is committed to social responsibility and promoting diversity and inclusion within the workforce. Join us in making a positive impact on society.
#J-18808-Ljbffr