Applied online, received a sql exercise to do at home, then an interview with the hiring manager as well as an analyst to step through a case study. Most of the case study was about SQL (JOINS, VIEWS, Dims, Facts, and analyzing data )