Data Warehouse Architect - Greenfield - MS BI/Azure

Data Warehouse Architect - Greenfield - MS BI/Azure

Job Title: Data Warehouse Architect - Greenfield - MS BI/Azure
Contract Type: Permanent
Location: City of London, London
Salary: £80000.00 - £95000.00 per annum + bonus, healthcare, pension
Start Date: ASAP
Reference: HQ00093411_1558454014
Contact Name: Mason Nathaniel
Contact Email:
Job Published: May 21, 2019 16:53

Job Description

Data Warehouse Architect - Greenfield - MS BI/Azure

I am working with a leading Lloyd's of London Insurer and have been asked to urgently find an experienced Data Warehouse Architect to join their growing BI team in London.


The company has grown steadily and now through the acquisition of two syndicates they are embarking on a major change program that will see the Data Warehouse Architect leading the design, development and implementation of a Greenfield enterprise data warehouse platform for the global group providing the business a data repository for one version of the truth. This will involve the decommissioning of legacy systems and introduction of PowerBI as the companies data visualization tool of choice.

The Data Warehouse Architect can expect to set BI Strategy & roadmaps, lead & mentor junior BI developers, work with the latest technologies in the Microsoft BI stack and Azure, with methodologies such as CI/CD, TDD, Dev/DataOps etc and lots of work to design and build new BI apps, data leads and more..


- Previous successful experience in a similar role designing and implementing enterprise data warehouse platforms/solutions

- Expert knowledge of DW/BI Solution design and architecture

- Exceptional technical skills in the Microsoft BI Stack (SQL Server, TSQL, SSIS, SSAS Tabular, SSRS, PowerBI etc)

- Solid expertise in database management and ETL/ELT such as change tacking, columnar indexes, partitioning etc

- Strong experience in designing data visualisation solutions in Tableau or Qlikview/Qlik Sense

- Must have experience deploying cloud based BI solutions - Azure, GCP, AWS


The following would be a bonus, but training will be provided:


- Microsoft certifications

- LM1 or CII Insurance Qualification

- Exposure to Cloud tech such as the Azure Data Platform


- Up to £95,000 + 10% bonus

- 25 days holiday + BHs

- 10% contributory pension

- Income protection

- Health

- Cycle to work

- Vouchers/Discounts

- Fully funded training/certs etc

- Travel loan

- And more....

This is a great opportunity for someone who wants to be involved in building a Greenfield data warehouse and also be part of a technically strong, experienced and growing BI team!

Apply as above and lets arrange a chat.

Data Warehouse Architect - Greenfield - MS BI/Azure

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