So I applied for a general "analyst" position, but I was contacted to be consider for a position as a multi channel marketing analyst. I first had to answer a few questions through email from the recruiter and then I was sent a quick questionnaire, followed by a video interview. After completing the video interview, I had a phone call with my potential manager and the hiring manager. I thought it went well, but a couple weeks later I learned that they had decided to go with someone else. However, my recruiter (She was so helpful and considerate! Their HR team is great!) reached out with another position as a market research analyst. After reading the description and conducting my own research, I realized that this type of role greatly aligned with my career development goals, so I said yes. Instead of starting from the beginning, I was scheduled to do another phone interview with my potential manager and with the hiring manager. However, the start date of IQVIA's Academy was coming up soon, so they decided to forgo the phone interview and moved me up for a final round interview! I really wanted this job so I prepared 10+ hours for it, which was worth it in the end. The final round interview lasted about half a day starting in the morning and ending in the afternoon. I first spoke to my potential manager for about an hour or so. After I had a 30 minute interview with an engagement manager. During both of those interviews, I had to answer behavioral questions and a small "case" study that involved looking at charts and graphs. Following that was lunch with the two. The final part of the interview process was an excel test that lasted about 30 minutes. To study I used Youtube, which was extremely helpful. Think pivot tables and knowing how to use certain formulas. I'm not even sure I did the best on it, but I believed I showed potential (i.e willingly to self teach myself Excel for this position). Over the next few days, I heard back from the recruiter that I got the job!