Datawarehouse ERP Lead (Informatica, Azure Cloud, ETL, SQL, BI)
6 days ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
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. 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 2 in the US and collaborate with a BI Analyst.
Responsibilities
* Designing, building, testing, and documenting ETL/ELT solutions.
* Maintaining up-to-date documentation, including lineage, for all production solutions.
* Monitoring and optimizing 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 standards and controls for data marts and operational data stores.
* Leading the release and deployment of new solutions to improve functionality and productivity.
Requirements
* Proven experience designing, writing, debugging, and testing advanced SQL code, stored procedures, and database schemas for Microsoft SQL Server and ideally Oracle.
* Knowledge of data warehousing, data modeling, insights creation, data science, cloud solutions, and data management.
* ETL development experience using Azure Data Factory and Informatica.
* Experience working with both Cloud (Azure) and on-premises data platform configurations.
* Experience managing the full BI lifecycle.
* Familiarity with Microsoft Fabric tools is preferred.
* Knowledge and experience working with ERP systems—essential; experience within manufacturing industry is a plus.
* Team leadership and management experience.
If this opportunity aligns with your background, please submit your application to Jackie Dean at Jumar. We pride ourselves on representing socially responsible clients who prioritize diversity, inclusion, and social equity, fostering a more equitable workforce.
#J-18808-Ljbffr