ER Internship Advice

Hi all,

I’m currently a sophomore studying Business Analytics with a minor in CS, and was looking for recommendations regarding ER Internship recruiting for next summer. I’m already late for some opportunities, but I just recently learned about ER and am highly interested in. I’m planning on spending this summer coding with Python and SQL to build a project portfolio that I can showcase and will potentially be interning at a consulting firm. What other skills should I seek to build that are often used in the role? Do analysts code often, and what types of programs do they build?

 

For an ER (Equity Research) internship, your focus on Python and SQL is a solid start, especially considering your background in Business Analytics and Computer Science. These technical skills are increasingly valuable in the finance sector, including ER, for data analysis and automation tasks. Here are some additional skills and areas you might consider focusing on, based on insights from the Wall Street Oasis discussions:

  1. Financial Modeling and Valuation: Understanding how to build and interpret financial models is crucial in ER. This includes proficiency in Excel, being able to construct three-statement models, DCF models, and comparables analysis. The WSO Financial Modeling Resources can be a great place to start.

  2. Industry Knowledge: Deep dive into specific industries you're interested in covering as an analyst. ER analysts often specialize in sectors, so having a strong grasp of industry trends, key players, and regulatory environments can set you apart.

  3. Writing and Communication Skills: ER analysts spend a significant amount of time writing reports and communicating their findings and recommendations. Practice writing concise, impactful reports, and work on your presentation skills.

  4. Bloomberg Terminal and FactSet: Familiarity with financial data platforms like Bloomberg and FactSet is highly beneficial. These platforms are widely used in ER for data gathering, financial analysis, and market monitoring.

  5. Regulatory Knowledge: Understanding the regulatory environment of the industries you're interested in can provide valuable insights into your analyses. This includes knowing key regulations, upcoming legislative changes, and their potential impacts on the sectors.

Analysts in ER do engage in coding, primarily for data analysis, automating repetitive tasks, and sometimes for building proprietary models or tools. Python is particularly valued for its versatility in data analysis, financial modeling, and machine learning applications. SQL is essential for database management and complex data queries.

Building a project portfolio that showcases your ability to apply these skills in real-world scenarios can be a strong differentiator. Consider projects that involve financial data analysis, predictive modeling related to stock performance, or automation of financial reporting tasks.

Remember, networking is also key in landing an ER internship. Connect with professionals in the field, attend industry events, and consider reaching out to alumni from your program who are working in ER. Your technical skills combined with industry knowledge and networking efforts can significantly boost your chances of securing an ER internship.

Sources: Learn SQL, Python, R at current job or seek RE opportunity? Career Advice., How to be a good S&T Intern, I want to intern at BW or P72, Q&A: Former ER Associate now FAANG Engineer, Programming/Technical Skills for Finance: SQL and Python

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 
Most Helpful

Eveniet sequi non magnam enim aperiam. Eum molestias dolor iusto quae veritatis atque possimus sit. Iste temporibus at ratione officiis vel corrupti.

Quia odit quas et quidem nemo dicta nisi et. Fuga consectetur necessitatibus aut aspernatur incidunt corporis est.

Rem atque voluptatem eos. Id doloremque id qui qui. Tenetur voluptatem magni qui esse.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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
Secyh62's picture
Secyh62
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
numi's picture
numi
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...”