Share this Job

BI Analyst

Date: 10-May-2022

Location: London, GB, W1U 8AN

Company: Knight Frank

Reference No 20695 
Job Title BI Analyst 
Type Permanent 
Salary Range Competitive
Division Business Services 
Sub Division Business Services 
Department Group Projects (10000926) 
Location 55 Baker Street 


Knight Frank is looking to hire a BI Analyst to strengthen and advance the consolidation production of our dashboard and reporting capability. The role will require someone who has strong PowerBI and SQL experience to build compelling dashboards that enable the business to quickly digest the data. 


You will have excellent visualisation skills and the tenacity to see through complex problems 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.


This is a role where creativity is a must where the individual will propose the design and solution as part of the investigation.



  • To work with the business to understand what insight they need and propose the solution
  • Develop PowerBI to present the data in an engaging and interactive way
  • To fully understand the customer, customer journey and the market to produce compelling dashboards that can be easily understood
  • Review multiple existing reports and consolidate into them into a manageable dashboard
  • To be able to work with a degree of independence on projects
  • To be able to disseminate findings within the team and to wider parties
  • To work with other members of the data team on wider projects
  • To be able to analyse complex datasets and cleanse data
  • To be able to advise other parties on best practice regarding data analysis



  • Creating PowerBI dashboards at enterprise level
  • Strong data visualisation skills
  • Demonstrable examples of using UX/UI principles within data visualisations
  • Write clean, effective and reusable code with notes for others throughout
  • Proactive to remain up to date with latest technologies and techniques




Strong experience with the following:

  • Power BI
  • SQL Azure DB or DW


Experience of the following or similar desirable but not essential@

  • Power BI Embedded
  • Power BI Report Builder
  • Alteryx
  • Azure Data Factory
  • Azure Storage (Blob or Data Lake)
  • Tabular cube development


Particular Aptitudes/Skills Required

  • Highly organised, systematic and adaptable with an excellent attention to detail, with the ability to recognise the relative importance of software issues and to prioritise work effectively
  • Ability to communicate clearly and deal with others at all levels in a polite, professional, friendly and helpful manner, both face to face, by email and on the telephone and maintain a good working relationships at all times
  • Demonstrated an ability to work on multiple projects simultaneously
  • Ability to work with all members of the  team, in a professional and yet dynamic and creative environment, fostering an open, friendly and constructive working relationship with all members of the Knight Frank team
  • Ability to work within a high pressure environment, balance priorities and remain calm under pressure
  • The successful candidate will be flexible, self-motivated, organised and pro-active with excellent computing and administration skills and the ability to adapt to a wide range of tasks. They will also have a “hands on” attitude and possess the necessary skills, manner and experience to provide an effective support service to the department/office
  • Desire to learn new technologies and continuously develop new skills and expertise
  • Ability to work out of hours to deliver application upgrades in agreed maintenance windows





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