Data Warehouse Developer

Data Warehouse Team

Remote UK 

Salary Banding £32,000 - £48,000 

Here at the Lush Head Office in the UK we are in the process of migrating our Data Warehouse and reporting solution to the GCP (Google Cloud Platform), BigQuery and Looker, while maintaining our current Global Data Warehouse solution (SQL Server and QlikView) containing retail and digital sales for our international operations in Europe and beyond.

As we migrate over to the GCP we’re looking to grow our team to allow us to continue our development work and maintain the high level of support that the business expects.

The job will initially involve using our in-house Python ETL Framework to load new and existing data sources into BigQuery using Python scripts, taking over the day to day tasks done by the Data Warehouse team that includes dealing with any issues regarding the 30 data feeds loaded daily/hourly from the global Digital and Retail business, supporting end users using the Looker reporting portal, maintaining Lush product information in the Data Warehouse as well as reconciliation and auditing of the data loads.  

We are happy to consider applications from remote workers who have the required skills and experience to fulfill this exciting role. Our Data Warehouse team is based in Poole so you’ll be required to commute to the office on a regular basis.

The Job:

• To help develop, maintain, update and support the ETL Python scripts used to load data into BigQuery
• To help develop, maintain, update and support the BigQuery and Microsoft SQL Server 2012 Data Warehouses
• To communicate with owners of the source data to ensure data quality and consistency is achieved
• To help reporting end users and help maintaining the Looker data models for reporting from BigQuery
• To develop, maintain and update T-SQL objects to support data loaded via SSIS, including creation of new objects and ensuring a high level of performance of the data flow process

Technical Skills:

• Good T-SQL skills demonstrating an ability to create and maintain SQL Server objects including tables, views and stored procedures
• ETL development skills with an emphasis on using Python scripts
• Experience using SQL Server Integration Services 2012 or an equivalent ETL tool
• Experience of using BigQuery and SQL Server 2012 or equivalent
• A basic understanding of Data Warehousing methodologies
• Knowledge of using Python to extract data from API's, CSV's, Storage Solutions (SFTP, Google Cloud Storage etc.) and Pub/Subs would be advantageous
• Knowledge of Linux and GitLab would be advantageous

Required Skills:

• Outstanding ability to communicate clearly, interpret user requirements, and formulate appropriate and pragmatic data warehouse solutions to meet those requirements
• Ability to effectively prioritise and execute tasks in a high-pressure, dynamic environment

Other Skills:
Lush uses data from the data warehouse to populate a series of Looker and QlikView reports which are used for self-service business discovery at all levels of the company from the shop floor to directors. As a result we have a strong data-driven decision making culture and it would be advantageous to have proven experience of working in such an environment. However, it is not essential and we will supply training for candidates with general data warehouse skill sets and experience. 

What’s it like working for Lush
People are at the heart of our business. We want you to enjoy and challenge yourself, build a career, and teach us what we don’t know, so we’ve created a culture where your job description is a starting point, not an end goal. Our working style is flexible, fluid, supportive, and authentic - if you’ve got the drive to push yourself and try different things, you will have our support.

As we pride ourselves on internal development, priority will be given to candidates who have an in-depth knowledge of Lush coupled with the relevant experience and qualifications.

If all this sounds like you, please send us your CV and covering letter, detailing why you would be a perfect fit for the role along with your current salary and expectations.

Employee perks:
50% discount on Lush products and spa treatments

Profit-based bonus

Pension scheme

Day off for weekday birthdays

Holiday purchase scheme

Cycle to work scheme

Discounted rail and bus season tickets 

Employee assistance programme

6 months’ full pay for parental leave (primary caregiver)

Financial childcare support on return to work

Flexible working

Support groups, film nights, yoga and meditation sessions and more...