Technical Skills to Prep for SA S&T

Hey yall

I will be interning at a BB this upcoming summer and was wondering if there were any technical skills in particular that I should prepare for before I start my internship. Should I primarily focus on getting acquainted with VBA or would it be helpful to dive into SQL and learn some more python? For past interns, what was your experience like, and did yall use any python, VBA or SQL? I will be working on the commodity side of things btw. 

 
Most Helpful

It is going to be desk specific. My desk and a lot of the ones I knew other SA's on were mainly given work with VBA, but I do know one person that was told to use python for his assignments. If you know python already then VBA should be really easy to pick up, I had zero use with it in college and basically learned how to use it within 1 workday (with hella Google help ofc). If you know the basics of how to code and know how to properly search on Google for your problems, then you should be fine with both python and VBA. Imo, knowing what to search in Google is like half the work when it came to these assignments lmao. You should ask your desk for specifics though they will tell you which languages they use. 

I would also definitely come into it being up to date on market trends, and thinking how your desk's product fits in to the overall macro picture. Being up to date on what is going on and how it affects your desk will be good. 

 

Every year I have people from my school reach out and ask “what technical skill should I learn?” with a follow up on “I know sql, python, etc.” essentially a running list of programs.

Unsolicited advice - spend and focus on the soft skills equally (i.e., presentation, communication, small talks, etc.) Its crazy how smart technical interns join the desk but if you ask them to present things they struggle. Or they have some cool idea but they can’t express or simplify it enough such that some MD can understand it. The more I work in this industry, the more I realize is that its not always the most technical/quant-y person that brings the revenue. Of course, if you can do both the soft and hard skills - then great!!

At the end of the day, you are interacting with people.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.9%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 05 97.7%
  • Moelis & Company 01 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (206) $159
  • Intern/Summer Analyst (148) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”