Data Warehouse Manager

Job Description

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 - Hybrid - 2 days on site
Start Date: ASAP
Salary: Up to £83,000

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:
build, and test corporate data warehouse.
test, and document ETL and ELT solutions.
accurate documentation, including lineage, for all solutions.
and assess solution performance and suitability.
data models, schemas, and metadata repositories.
operational data warehouse issues promptly.
compliance with standards and controls.
user functionality and productivity with new solutions.
processes to standardise their data warehouse environment.

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

Competencies:
Knowledge of data warehouse management best practices.
Solution design, build, and testing.
ETL design and dimensional, OLAP, and relational-based solutions.
Kimball and Inmon architectures.
Design data quality and master data management processes.
Thinking
Orientation
Acumen
Collaborative Relationships
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.