Snr Datawarehouse Engineer (AWS/Python)

Reference

PCO/AR/056577

Sector

IT & Internet

Salary

£85,000 Per Annum

Town/City

London

Contract Type

Permanent

Closing Date

31/12/2021

Share this Job

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

£85k basic

My client, an award-winning Publishing House is looking for a Senior Datawarehouse Engineer 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 remote management and communication skills.

6+ years working with data warehouse’s in an architect or administrator role, ideally including roles in media companies or technology companies.

Extensive hands-on experience with the varied AWS services and knowledge of their limitations.

Experience building pipelines and orchestration of workflows in an enterprise environment.

Experience in optimizing the cost for service being utilised on AWS in particular Redshift.

Thorough, in-depth knowledge of the AWS tooling landscape.

Good database architecture knowledge specifically Redshift.

Proven PostgresSQL experience (database and development skills).

Proven with data management and governance in large scale with big data.

Good understanding of batch data processing.

Proficiency with Python.

Experience with other programming and machine learning languages is a plus.

Understanding of the Kimball methodology for data warehousing where and when to apply to take advantage of MPP Redshift.

Good experience of CI/CD and AWS SAM.

Expert knowledge and experience of OLAP, Data Mart and Data warehouse Data

Important Information: We endeavour to process your personal data in a fair and transparent manner. In applying for this role, Additional Resources will be acting in your best interest and may contact you in relation to the role, either by email, phone or text message. For more information see our Privacy Policy on our website. It is important you are aware of your individual rights and the provisions the company has put in place to protect your data. If you would like further information on the policy or GDPR please contact us.

Additional Resources Ltd is an Employment Business and an Employment Agency as defined within The Conduct of Employment Agencies & Employment Businesses Regulations 2003.

You may also be interested in...

Middle Weight Graphic Designer - Cheltenham, GL50 1DY Salary - £22,000 - 28,000 D.O.E. This Middle Weight Graphic Designer position offers the opportunity to operate in a studio which specialis
Salary: £22,000 to £28,000 Per Annum Sector: IT & Internet Contract Type: Permanent Town/City: Cheltenham
Full Stack Developer - Brighton or Remote Salary: £33,000 - £36,000 (Based on experience) The Company: Our client is an award-winning games publishing agency. They have been around for 13 y
Salary: £33,000 to £36,000 Per Annum Sector: IT & Internet Contract Type: Permanent Town/City: Brighton ,Remote
AWS Cloud Infrastructure Architect, Remote UK/Remote £75 to £80k + bonus + shares Do you want to take your career to the next level as part of one of the big five IT and business
Salary: £75,000 to £80,000 Per Annum Sector: IT & Internet Contract Type: Permanent Town/City: London
Mid/Snr Product Manager, Remote or Hybrid (Growth/B2B/SaaS) – Remote/UK £60 to 69k basic + bonus + stock options My client is a digital start-up AI Software Builder, that specialise
Salary: £60,000 to £69,000 Per Annum Sector: IT & Internet Contract Type: Permanent Town/City: London
IT Service Desk Analyst - Manchester £25-£29K basic The client: My client, an insurance risk and commercial law based in Manchester are looking for a IT Service Desk Analyst to provide a prof
Salary: £25,000 to £29,000 Per Annum Sector: IT & Internet Contract Type: Permanent Town/City: Manchester