Phone screening with a recruiter - the process made me slightly feel they didn't respect my time: Couple of minutes before calling, she asked to postpone in an hour (we scheduled a time and date a few days before). I replied "yes". After one hour she appologized, saying she won't make it and asked to reschedule for another day. She had no knowledge what the position is about and what you do in general, giving me the "you can ask that in the interview with the team lead" excuse.
In-person interview with the team lead and a senior analyst - some introduction like "tell me about youself" and some personal questions like "Why do you think you are a fit for this position?" "What do you bring to the table?" "What do you expect from your team? from you manager?"
Afterwards they gave a one hour written test - first section was 5 querying questions on one table with SQL and another 2 or 3 harder questions querying on multiple tables.
second section involved a case study - a loss in revenue of a small fictional food retail outside Madrid - give 10 question you will ask in order to find the reason/s and highlight the 5 critical ones.