Data Warehouse Architect (Manchester)

A Data Warehouse Architect who will be responsible for designing the changes and improvements required within the data warehouse.Working within a key team in the data engineering department, this role represents an opportunity to design the data warehouse where the day-to-day work is varied and interesting.You will be designing items from large scale changes linked to business transformative programmes, to minor improvements requested by a single user. You will be liaising with other departments to ensure a high quality of work is produced, whilst always looking to improve the data warehouse design to satisfy the ever changing demands of the Business.This role is eligible for inclusion in the Company’s hybrid working from home policy.Preferred skills and experienceKnowledge of database and data warehouse design, including the Kimball methodology.Commercial experience of data warehouse implementation, preferably in the Cloud.Knowledge of the relational theory, using set based processing.Excellent communication skills with the ability to work to deadlines.Ability to write complex SQL queries.Experience of working in a team focussed environment, delivering high quality solutions.Ability to work in a continually changing and reactive environment, with a committed, flexible and can-do attitude towards work.Demonstrate a keen interest in the Business value of data.Main ResponsibilitiesDeveloping the data warehouse design using Kimball methodology.Designing the logical change data capture (CDC) required to extract data from source systems.Working with the extract, transform, load (ETL) process and data warehouse developers to provide them with sufficient information to create and alter the data warehouse to satisfy Business requirements.Working alongside report developers to ensure the data warehouse design optimises reports built within MicroStrategy and SSRS.Working alongside other members of the team on multi-developer projects.Developing an intimate and detailed knowledge of the Business data structures.Developing solutions in line with departmental standards, adhering to the development process.Creating and maintaining relevant documentation.“By applying to us you are agreeing to share your Personal Data in accordance with our Recruitment Privacy Policy -
"Send me alerts about jobs like this.Please enter your email address to continue setting up an email alert for similar jobs to this one. By entering your email address and clicking apply you will sign up to Jobs4 and agree to our terms and conditions .
#J-18808-Ljbffr