Two-stage recruitment process.
1. Telephone interview with the Director of the practice: This is really just a sanity check and broad discussion of the candidates CV and about the company's background/profile to ascertain mutual suitability.
If the candidate and company are happy to proceed, then a date shall be set for a face to face interview. The candidate shall also be provided with a case study to work in his/her spare time prior to the interview.
2. The second stage consists of two parts: A) a presentation of the solution to the case study and B) a detailed conversation.
A) Prior to attending this second stage interview, the candidate shall be expected to build a solution (in Power BI or something similar) based on data extracts provided. This should demonstrate the candidates basic ability to work with data and build a reasonable solution in a matter of days. This doesn't have to be absolutely perfect but the candidate shall be asked questions about the design and development of the data model and the visualisations.
B) A detailed discussing experience, aspirations, skills and interests. This is a pretty standard interview and will involve some technical questions and questions to probe the candidates consultancy skills.