Data Warehouse Architect

Data Warehouse Architect

Job Title: Data Warehouse Architect
Contract Type: Permanent
Location: London, England
Salary: Up to £75000 per annum + pension
Start Date: ASAP
Reference: BN/HQ00112721_1574941993
Contact Name: Brad Newton
Contact Email:
Job Published: November 28, 2019 11:53

Job Description

Data Warehouse Architect (eCommerce)

Most suitable for candidates with recent Cloud experience, ideally 1-2 years+ commercial experience using Redshift or Snowflake. Preferably from an eCommerce, Travel, Gaming background.

Our client is one of the most exciting Travel/Leisure companies in the UK.

They've enjoyed a period of hyper growth over the last 5 years and now have 500+ employees.


This is a fantastic opportunity for a Data Architect with a flair for data modelling to help build a world class data infrastructure that will be transformational for employees and customers.

- Design, implement, optimise, evolve, support and deploy new and existing data models to support many and varied use-cases across MI, analysis and data science

- Build and maintain complex business logic written in SQL that keeps up with the business

- Work cross-functionally with fellow data engineer, data scientist, analysts and other business users

- Work cross-functionally to integrate a modern BI toll with client's data warehouse

- Adapt test driven development like practices (TDD) to SQL modelling, devising and writing assertions and validation that verify complex business logic


- Writing high quality SQL code on VERY large data sets (billions, from various sources)

- Full comprehension of data modelling techniques (Star Schema, Kimball, Data Vault etc)

- Recent and plenty of experience with cloud based tech (Snowflake or Redshift or AWS preferably)

- Python would be beneficial but not essential as there would be support from the engineers on this

- Experience in a fast paced, ecommerce business would be preferred but again, not essential

Salary £75k + pension, benefits

Keywords: SQL, Redshift, Snowflake, eCommerce, Travel, Data Modelling, Data Modeller, Data Warehouse Architect, Data Architect, AWS Redshift

Lawrence Harvey is acting as an employment agency in regards to this position. Visit our website and follow us on Twitter for all live vacancies @lawharveyjobs