US Jobs US Jobs     UK Jobs UK Jobs     EU Jobs EU Jobs


Snr Datawarehouse Administrator (AWS/Python)

Snr Datawarehouse Administrator (AWS/Python) -Remote/ UK

£85k basic

My client, an award-winning Publishing House is looking for a Senior Datawarehouse Administrator who will lead on the design and implementation of an enterprise data warehouse (EDW).

The Publishing House is one of the largest commercial publisher and digital platforms in the UK and is home to the UK and Ireland's most iconic digital platforms, magazines and newspapers.

This role reports to the Head of Data.

100% Home based (within the UK).

Job Introduction

Publishing House currently utilises Tableau as their visualisation platform.

The dashboards are sourced from data held within a customer data lake housed within AWS.

Currently the business intelligence team uses queries built in Athena to create tables and views that support the dashboards within Tableau.

We are looking to create an EDW to improve the reporting capability within the business intelligence team.

As the data lake already exists within the AWS suite of services, Redshift has been chosen as the platform to house the EDW.

There are multiple sources of data that are brought into the data lake via the Ingestion team.

You will work closely with the Ingestion team and Data Architect to gain an understanding of the data.

This will feed into how the EDW will need to be configured in order to take advantage of MPP within Redshift amongst other features.

The EDW alongside the data lake will be used to power reporting and analytics across the organisation.

Due to the nature of the analytics and data science teams within the agency, there is a requirement for data marts to be included in the design.

The Ideal Candidate

Degree-level education Computer Science or Information Management, or equivalent experience.

Professional qualifications appropriate to DBA roles such as Amazon's AWS Certified Big Data - Specialty (in relation to Redshift).

Ability to work effectively remotely and resourceful, with excellent r

Share Job