Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9syxdyzw5jzs1oyxj2zxkvanbnl2pvyl9kzwzhdwx0x2jhbm5lci5qcgcixv0

Data Warehouse Architect

Data Warehouse Architect

Job Title: Data Warehouse Architect
Contract Type: Permanent
Location: London, England
Industry:
ERP
CRM
HCM
Salary: Up to £75000 per annum + pension
Start Date: ASAP
Reference: BN/HQ00112721_1573827815
Contact Name: Brad Newton
Contact Email: b.newton@lawrenceharvey.com
Job Published: November 15, 2019 14:23

Job Description

Data Warehouse Architect

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.

Role

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

Experience

- 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 and 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

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