One you submit your application and talent profile, it gets reviewed, and a coordinator arranges a phone interview based on your availability. As in many places, the phone interview is the first in a series of interviews. The phone interview came across as very poor. The interviewer was difficult to understand over the phone due to a thick accent, and the interviewer made no effort to make their department the least bit attractive to a potential candidates. Even when a reference was made to a publication that the interviewer co-authored, the interviewer showed no interest whatsoever and chose not to comment. To be perfectly honest, it sounded like the department likely already had candidates in mind and was just going through the interview process to look fair. The interview was incredibly dry. After asking questions about statistical analyses, the interviewer then admitted that a "junior biostatistician" (this is how the interviewer referred to the position) would spend most of their time extracting and cleaning data and doing very little analysis. Then why is this title called biostatistician? Additionally, this position was titled "Biostatistician I/II-Epidemiologic Research". Although such positions usually overlap, such departments should understand that those with epidemiologic training will have a different perspective than those who are trained in biostatistics. The interviewer appeared to have a biostatistics bias. Also, not everyone is going to come from a place with a sophisticated setup where SAS directly connects to SQL server, so it should not be a big deal if you haven't done that before. At some places, you have to write the SQL yourself in separate system, manually save the extracted data into excel files, and write a macro in SAS to mass import them.
Some time after the initial interview, I received a message asking me to schedule a 2-hour long "biostats assessment". Once again, the first interviewer, who was a biostatistician, informed me that this "junior" position was not going to involve much analysis and was going to be mainly data extraction, cleanup, and manipulation. If that was the case, why was there any need for a two-hour long biostatistics assessment?