Skills you need to be a junior financial 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 roleUpskili 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 junior financial analyst — not mastery, and not a passing acquaintance.
-
Excel
Essential
Builds financial models, forecasts, and performs data analysis.
Strong -
Financial modeling
Essential
Creates three-statement models and valuation analyses.
Working -
SQL
Important
Extracts and manipulates data from company databases.
Working -
PowerPoint
Important
Prepares presentations and pitch books for stakeholders.
Working -
Accounting principles
Important
Interprets financial statements and ensures reporting accuracy.
Working -
Data visualization (e.g., Tableau, Power BI)
Useful
Creates dashboards to track KPIs and business performance.
Familiar -
Bloomberg Terminal
Useful
Gathers market data and conducts company research.
Familiar -
VBA
Useful
Automates repetitive Excel tasks and reporting processes.
Familiar
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.
Start here
Essential to the role, and reachable from a standing start. Everything below rests on these.
- Excel
- Financial modeling
- SQL
- PowerPoint
- Accounting principles
What sets you apart
Not what gets you hired, but what separates doing the job from being trusted with it.
- Data visualization (e.g., Tableau, Power BI)
- Bloomberg Terminal
- VBA
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 junior financial analyst