Excel take home + Resume deep Dive Excel pivot table and vlookup for calculations Very basic concept of ETL and bq questions Overall easy all basic concepts and nothing over expections

Met with 7 people of various titles in analytics. Everyone I met was very kind, however, it was evident that the culture was siloed and the analysts were the stereotypical "cave coders." The company is proud of their remote culture which may be a pro to many employees, but I was looking for a bit more opportunity to meet my coworkers and have a bit of an in person company culture. There is no travel for the job and it seemed the only in person opportunities were quarterly in person town halls. This in combination with the secluded nature of the anayst dept was not attractive to me. In addition to all of this, the impending merger between IPG and Omnicom (though it has yet to pass through legal regulations) was a deterring factor to me. When I asked the team about their thoughts on how this may affect Solve(d) no one seemed to know, which made me uneasy about potential duplicative roles being eliminated.