Originally applied online via LinkedIn for the Professional Development Program which provides new hires with 3-4 weeks of paid training for the BSA role prior to being placed on a project. There was a 5-10 minute phone screen followed by an invitation for an all day recruiting event a week later. At the event, employees from the company give you (and a number of other invited candidates) an overview of the company and the position with a light lunch served. Afterwards, there are 4 30 minute interviews 1:1 with various managers and directors. You're assigned a current BSA to be your host for the duration of the day shuttling you from interview to interview as well as giving you a personal tour of the building. You'll have an itinerary for the day. The interviews are behavioral by nature with no technical questions involved. Because there's formal training when you start, the bar for technical aptitude is pretty low. However, if you have some VBA, SQL, Python knowledge you'll look a lot more favorable next to other candidates. That being said, even if you don't have the technical experience you have a chance. If you come off as friendly, approachable, and interested in the company and can show them that you're willing to learn, you'll definitely receive an offer. Ask targeted questions about their software and genuinely show interest. After the interviews, you and other candidates are brought back to the executive room for a debrief with snacks. I was told I'd find out within a week but was called a day and a half after the interview with an offer. Very quick.

Phone call interview with HR followed by In-person interview (multiple people interviewing you on same day for 15- 20 min) and Skill test for Advance Excel and SQL on computer.