l/s pod analysts, do you code much?

Is there any value to learning python + sql still? Or has claude made it obsolete?

I'm curious if the data you are using for your models is clean or siloed/unstructured (in which case claude prob cannot help you pull it)

4 Comments
 

Based on the most helpful WSO content, learning Python and SQL still holds significant value, even in the era of advanced AI tools like Claude. Here's why:

  1. Data Retrieval and Organization: SQL remains the primary method for harvesting data from databases. It allows you to retrieve specific data points, such as trades of a particular security or companies meeting certain criteria. This is crucial for building models, especially when dealing with structured data.

  2. Data Analysis and Manipulation: While SQL is excellent for retrieving and organizing data, Python shines in analyzing and manipulating it. With libraries like Pandas, Python enables you to work with data in more complex ways, such as backtesting strategies or running scenarios efficiently.

  3. Unstructured or Siloed Data: If the data you're working with is unstructured or siloed, tools like Claude may struggle to pull and process it effectively. In such cases, having the ability to write scripts in Python or SQL to clean, structure, and analyze the data becomes invaluable.

  4. Flexibility and Efficiency: Python is highly flexible and allows for quick prototyping and drafting of solutions. While it may not be as robust as some other languages for advanced use cases, its ease of use and extensive libraries make it a go-to tool for many finance professionals.

  5. Long-Term Career Benefits: Even if AI tools like Claude can assist with certain tasks, understanding the underlying processes and being able to code provides a deeper level of control and insight. It also makes you more self-reliant and adaptable to various data challenges.

In summary, Python and SQL are far from obsolete. They complement AI tools by enabling you to handle data more effectively, especially when it's messy or unstructured. Plus, they enhance your efficiency and problem-solving capabilities, which are critical in roles like L/S pod analysts.

Sources: Programming/Technical Skills for Finance: SQL and Python, Programming/Technical Skills for Finance: SQL and Python

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

Et laboriosam et blanditiis rerum. Nulla libero dolores quo porro quia fugiat est. Laudantium cum ut et voluptatem ea libero. Exercitationem et voluptatibus illum non maxime tempore voluptatem. Beatae qui maiores cumque molestiae et animi quas. Vero odio rerum cum et soluta qui voluptates.

Career Advancement Opportunities

July 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.1%
  • Citadel Investment Group 97.1%
  • AQR Capital Management 96.2%
  • Magnetar Capital 95.2%

Overall Employee Satisfaction

July 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.1%
  • Citadel Investment Group 96.1%
  • Millennium Partners 95.1%

Professional Growth Opportunities

July 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.1%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.2%
  • Magnetar Capital 95.2%

Total Avg Compensation

July 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (12) $423
  • NA (9) $320
  • Engineer/Quant (86) $288
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (77) $191
  • Analysts (242) $181
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (282) $96
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

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...”