Skip to content

Skills you need to be a investment analyst

8 skills a hiring manager would actually test for, each with the level this role expects and what it is used for. Not a syllabus — the shape of the job.

Build my path to this role

Upskili checks what you can already do, then sequences only what is missing. No account needed.

What the role requires

Ordered by how much the job depends on it. The bar is the proficiency expected of a competent investment analyst — not mastery, and not a passing acquaintance.

  • Financial modeling

    Essential

    Builds and maintains three-statement models to forecast company performance.

    Strong
  • Excel

    Essential

    Performs data analysis, scenario testing, and creates investment committee materials.

    Deep
  • Bloomberg Terminal

    Important

    Sources real-time market data, company financials, and industry research.

    Strong
  • Valuation techniques

    Essential

    Applies DCF, comparable company, and precedent transaction analyses.

    Strong
  • Investment memo writing

    Important

    Drafts clear, concise recommendations for portfolio managers or committees.

    Strong
  • SQL

    Useful

    Extracts and manipulates large datasets from internal databases.

    Working
  • Python

    Useful

    Automates data gathering and builds basic analytical tools.

    Working
  • FactSet

    Useful

    Supplements Bloomberg for portfolio analytics and industry data.

    Working

An order worth learning it in

A list of ten skills is the same unhelpful answer a catalogue gives, just sorted. This is where to actually start.

1

Start here

Essential to the role, and reachable from a standing start. Everything below rests on these.

  • Bloomberg Terminal
  • Investment memo writing
2

Then this

The rest of what the role is assessed on. Harder, and it builds on the foundation above.

  • Financial modeling
  • Excel
  • Valuation techniques
3

What sets you apart

Not what gets you hired, but what separates doing the job from being trusted with it.

  • SQL
  • Python
  • FactSet

You almost certainly have some of this already.

That is the point of starting from the role rather than a course. Upskili checks what you can do, then builds a path across only the gap.

See my path to investment analyst