Data Warehouse Architect

Who we are looking for

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.

Preferred skills and experience

• Knowledge 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 Responsibilities

• Developing 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 - http://www.bet365careers.com/privacypolicy.pdf"