Share this Job

Data Automation Analyst

Date: 06-Mar-2021

Location: London, GB, W1U 8AN

Company: Knight Frank

Reference No 9441 
Job Title Data Automation Analyst 
Type Permanent 
Salary Range Competitive
Division Business Services 
Sub Division Business Services 
Department Projects (10000894) 
Location 55 Baker Street 


Due to the rapid growth of data and analytics capabilities within the organisation, an exciting new role has opened up for a specialist in Data Automation to strengthen and advance the consolidation and automation of our existing data sets. Supported by the wider Data and Operations teams you will review current data processes and automate them to improve efficiencies and improve reporting and analysis.  You will streamline and consolidate data sets as well as advice on best practice. 


The role will require someone who has an Automation/ ETL background (strong Alteryx experience would be an advantage) that will enable the business to quickly digest the data.  You will have the tenacity to see through complex problems and automating laborious tasks, as well as the vision and spontaneity to contribute new ideas that gain traction within the team.  Coming up with new ideas is actively encouraged.


Main responsibilities include


  • To work with the Operations team to extend the team’s data modelling and reporting capabilities
  • Develop ETL process to import new data sets, either via API or internal sources
  • To fully understand the data journey to ensure that the correct data is captured to automate
  • To ensure the Operations team have easy access to their data
  • To be able to analyse complex datasets and cleanse data
  • To be able to advise other parties on best practice regarding data analysis




  • Using Alteryx to automate and consolidate multiple data sets
  • Building dashboards in the main softwares (Tableau/ PowerBI/ Qlik)
  • Solid experience with data modelling, data warehouse design and data lake concepts and practices
  • Working with multiple stakeholders across multiple disciplines
  • Automating processes
  • Ability to connect to APIs
  • Write clean, effective and reusable automation processes with notes for others throughout
  • Proactive to remain up to date with latest technologies and techniques




I         An indepth knowledge of 2 or more of the following (or similar):


  • Alteryx
  • Power BI
  • Tableau
  • MS Azure Data Platform environment
  • Azure Data Factory
  • Azure Storage (Blob or Data Lake)
  • SQL Azure DB or DW
  • BluePrism
  • Python



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