After applying to the job with my resume and cover letter, there were three stages: 1) A small technical project that I had 48 hours to complete: We were given a dataset in Excel format and told to clean up any data quality issues and look for correlations to answer a few particular questions. We were suggested to use PostgreSQL or SQL Server to manage the data and Tableau for creating visualisations. Expected output was a brief report with answers to the questions supported by visualisations and descriptions/screenshots of tool use (e.g. SQL queries). 2) A phone interview with HR where they went over the usual questions: -Why do you want to work here? -What experience do you have working with SQL and R? -What are your salary expectations? 3) A technical interview at their head office where I talked to two analysis team members: I was given a few simple R and SQL questions, what is the output of this bit of code, how does R handle multiplying vectors, what SQL code would you write to find this particular info. They were looking for just straight code, not talking through what you would do. Following those simple questions, I was asked to describe the process I went through to do the project in part 1). Then I was given a hypothetical project: given a large dataset of simple GPS data (vehicleID, lat, long, timestamp), what interesting/useful visualisations could I make for a client? I was required to describe in detail (showing architecture on a whiteboard) what tools I would use, transformations required, etc.