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.
 

Suscipit dolor neque veritatis quam fuga fuga suscipit. Repellat non repellendus corporis quisquam. Et animi libero quaerat. Ea dolorum consequatur est odit corporis sunt nostrum.

Expedita est ratione doloremque suscipit perferendis. Commodi saepe enim dolor molestiae animi sit. Quos dolores nemo natus dolore accusantium perspiciatis vero suscipit. Quaerat asperiores odio delectus aliquam eveniet ullam.

Corporis sed magni distinctio. Placeat totam aliquid quis voluptates alias illum. Reprehenderit natus fugiat vitae velit quod est ad.

Career Advancement Opportunities

September 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.0%
  • Citadel Investment Group 97.0%
  • AQR Capital Management 96.0%
  • Magnetar Capital 95.0%

Overall Employee Satisfaction

September 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.0%
  • Citadel Investment Group 96.0%
  • Two Sigma Investments 94.9%

Professional Growth Opportunities

September 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.0%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.1%
  • Magnetar Capital 95.1%

Total Avg Compensation

September 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (11) $372
  • NA (9) $320
  • Engineer/Quant (83) $287
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (76) $193
  • Analysts (234) $178
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (276) $95
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...”