Was told by the agency that they were in rush to fill the position- so overnight interview was requested with limited flexibility regarding dates/times. Interviewer was the Director, who wanted to know how to resolve some issues he had with data and reporting - see some of the questions below. I answered all the questions because I worked a lot to bring the solutions as a Consultant. Therefore the interview was easy for me. However at the very end I felt used - as if spent my time offering free consultative service. I was told that agency got the response (late yesterday evening?) that they decided to move with another candidate. Which is good as the Director changed job description during our conversation - it appeared that his Analysts know everything (just they did not have time to implement all the solutions and then basically they do need help (support), as they are very busy . And he basically did need someone for just reporting part (initial job description cited cross functional work) and then for ad hoc reports. There were some more questions, but I could not add them here using the button below. When I said initially I did not work with taxonomy as I did not understand the question, he appeared kind of pleased. At the very end I remembered that I actually did some reporting in the past using exactly the taxonomy pulling the queries and creating reports.