Data Warehouse Manager

Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions.

Data Warehouse Manager - Building a Modern Warehouse

Location: West Midlands

Start Date: ASAP

Salary: Up to £83,000

Hybrid: 2 days on site ideal

We are seeking a skilled Data Warehouse Manager to lead the design, development, and delivery of a new data hub, while also managing the existing legacy Data Warehouse. This role is crucial for ensuring that the data infrastructure meets the highest standards and supports the business needs effectively. The successful candidate will oversee a talented team and work within our client's IT function.

Principal Job Duties & Responsibilities:

• Design, build, and test corporate Data Warehouse.
• Develop, test, and document ETL and ELT solutions.
• Ensure accurate documentation, including lineage, for all solutions.
• Monitor and assess solution performance and suitability.
• Maintain data models, schemas, and metadata repositories.
• Address operational Data Warehouse issues promptly.
• Ensure compliance with standards and controls.
• Enhance user functionality and productivity with new solutions.
• Improve processes to standardise their Data Warehouse environment.

Required Skills, Knowledge, and Experience:

• Extensive experience with SQL, preferably with Microsoft SQL Server and Oracle.
• Expertise in data warehousing, data modeling, data science, and cloud solutions.
• Experience with ETL development using Azure Data Factory and Informatica.
• Previous management experience in data warehousing or data engineering.
• Familiarity with both Cloud (Azure) and On-prem data platforms.
• Proficiency in the end-to-end BI lifecycle and complex environments.
• Experience with Azure DevOps and CI/CD pipelines.

Competencies:

• Strong knowledge of Data Warehouse management best practices.
• Proficiency in solution design, build, and testing.
• Skilled in ETL design and dimensional, OLAP, and relational-based solutions.
• Experience with Kimball and Inmon architectures.
• Ability to design data quality and master data management processes.
• Forward Thinking
• Results Orientation
• Business Acumen
• Building Collaborative Relationships
• Personal Credibility

Requirements:

This role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, the ability to focus on tasks and problem-solving skills are essential. Reasonable accommodations can be provided for individuals with disabilities.

If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.