Share this Job

Data Architect

Date: 06-Jan-2023

Location: London, GB, W1U 8AN

Company: Knight Frank

Reference No 27731 
Job Title Data Architect 
Type Permanent 
Salary Range Competitive
Division Residential 
Sub Division Research 
Department Residential Research (10000116) 
Location 55 Baker Street 


Knight Frank is the leading independent property consultancy in the UK offering agency and professional advice across Commercial, Residential and Rural sectors. Established in 1897, Knight Frank now comprises a global network of over 400 offices.


Due to the rapid growth of data and analytics capabilities within the organisation, an exciting new role has opened for a Data Architect to strengthen and advance efficiencies and organisation of multiple company datasets. Supported by the wider team you will be required to review the current database structure and tables and highlight tables for archive. You will advise on best practice within architecture, design, and coding areas.


The role will require someone who has strong SQL Server and Data Warehouse developer background. You will have the tenacity to see through complex problems as well as the vision and spontaneity to contribute new ideas that gain traction within Residential Research.





Review of Residential Research’s server structure and tables

Archive redundant datasets

Apply consistent naming convention

Maintain accurate and complete architecture documents

Perform performance optimisation and maintenance on tables

Write clean, effective, and reusable code with notes for others throughout




Building Enterprise Data Warehouse

Have strong experience with Microsoft SQL or T-SQL for querying data

Experience in the Property sector

Experience in working with MS Azure Cloud Platform

Experience with Alteryx


Particular Aptitudes/Skills Required


Highly organised, systematic and adaptable with an excellent attention to detail, with the ability to prioritise work effectively

Ability to work within a high-pressure environment, balance priorities and remain calm under pressure

The successful candidate will be self-motivated, organised and pro-active with excellent computing and administration skills. 

A “hands on” attitude and possess the necessary skills, manner and experience to provide an effective


#1 #LI-AL1



To view other vacancies within the Knight Frank Group click here.