SCROLL

DATA

ANALYTICS

INTERVIEW

QUESTIONS

​& TEST

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.

DATA

ANALYTICS

INTERVIEW

QUESTIONS

​& TEST

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. 

Applicants will be evaluated on their ability to:

  • Transform and manipulate raw data into useable information

  • Perform analysis and thoroughly investigate all information available

  • Visualise and convey insights uncovered while providing useful recommendations

Once received and reviewed, applicants must be prepared to present their findings and answer questions.

PROFESSIONAL INTERVIEW TEST BANK 

BY JOB CATEGORY

Data Analyst
Product Management
Digital Advertising

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 

Credit Analyst

Business Analyst

Data Analyst 

Financial Analyst

Commercial Analyst     

Financial Advisor

Risk Management Analyst

Mortgage Advisor

Investment Banking Associates

Treasury Analyst

Companies our students received job offers from:

Banking

Morgan Stanley, JP Morgan, RBC, Goldman Sachs, TD, Scotiabank and more.

Consulting

PWC, Deloitte, KPMG, EY, McKinsey and more.

Insurance

Desjardins, State Farm, Intact, Geico, Manulife and more.

Tech

Facebook, Amazon, Google, Oracle, Apple and more.

Accounting

PwC, BDO, RSM, Baker Tilly, Grant Thornton and more.

 
 

OUR MISSION 

 Providing the most comprehensive & dedicated employment training offered by top industry executives.

 Helping students launch their dream careers in two months.

Number of students entering Fortune 500 firms each year.

 

OUR

MENTORS

SYDNEY BROER

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.

JASON WONG

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.

 

GET IN TOUCH

We'd love to hear from you

Wechat

647-771-6166

Tel.

OFFER

STREETS

HOURS OF OPERATION

Mon-Thu: 9AM to 8PM

Friday: 9AM to 3PM

Sat-Sun: Closed

CONTACT US

30 Wellington St W, Toronto, ON Canada. M5L 1E2

261 Madison Ave, New York, NY United States. 10016

 

Mail: info@offerstreets.com

Tel: 647-771-6166