This test is designed for prospective applicants pursuing a fresh career in data analytics. The test simulates similar take-home exams given to applicants for entry-level positions. Users of this test are expected to complete this test over a weekend and make use of Excel, although experienced applicants may also use Tableau as an alternative. Applicants will be evaluated on their ability to transform and manipulate raw data into useable information, perform analysis and thoroughly investigate all information available, and visualise and convey insights uncovered while providing useful recommendations.
The expected deliverables of this test are a PowerPoint slide deck addressing the questions below, as well as the Excel file showing any formulas and any other work done on the raw data. Once received and reviewed, applicants must be prepared to present their findings and answer questions.
PROFESSIONAL INTERVIEW TEST BANK
BY JOB CATEGORY
If you are going to attend the interview, it will be vital for you to spare no effort to show the interviewer your analytical skills, communication skills and attention to detail.
While you should always be prepared for common job interview questions, there are some behavioural and technical questions that you’ll want to make sure you have practiced beforehand.
JOB OFFERS OUR STUDENTS RECEIVED
Relevant job offers in finance our students received in the past two years:
Investment Banking Analyst
Risk Management Analyst
Investment Banking Associates
Companies our students received job offers from：
Morgan Stanley, JP Morgan, RBC, Goldman Sachs, TD, Scotiabank and more.
PWC, Deloitte, KPMG, EY, McKinsey and more.
Desjardins, State Farm, Intact, Geico, Manulife and more.
Facebook, Amazon, Google, Oracle, Apple and more.
PwC, BDO, RSM, Baker Tilly, Grant Thornton and more.
Former VP at CIBC & Scotiabank
Head of Treasury
Sydney has been working in finance for over 35 years.
His specialties include risk management, equity trading, portfolio management and Fin-tech.
Sydney has led teams at major North American banks overseeing portfolios worth more than USD $50 Billion.
Vice President & Recruitment Officer at JP Morgan
CFA and FRM Charterholder
Industry veteran with expertise in both the buy-side (fund) and sell-side (bank)
Relevant field in finance: Quantitative research, trading, risk management, data analysis and machine learning.