Skills you need to be a treasury 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 competent treasury analyst — not mastery, and not a passing acquaintance.
-
Excel
Essential
Builds financial models, forecasts, and analyzes large datasets.
Deep -
SQL
Essential
Extracts and transforms financial data from databases.
Strong -
Cash flow forecasting
Essential
Projects short and long-term liquidity positions.
Strong -
Financial modeling
Important
Creates three-statement models for scenario analysis.
Strong -
Treasury management system (TMS)
Important
Manages bank relationships and automates cash positioning.
Strong -
Variance analysis
Important
Explains deviations between actuals and forecasts.
Strong -
Power BI or Tableau
Useful
Visualizes treasury KPIs for management reporting.
Working -
Foreign exchange (FX) risk management
Useful
Analyzes currency exposures and hedging strategies.
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.
Start here
Essential to the role, and reachable from a standing start. Everything below rests on these.
- SQL
- Treasury management system (TMS)
- Variance analysis
Then this
The rest of what the role is assessed on. Harder, and it builds on the foundation above.
- Excel
- Cash flow forecasting
- Financial modeling
What sets you apart
Not what gets you hired, but what separates doing the job from being trusted with it.
- Power BI or Tableau
- Foreign exchange (FX) risk management
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 treasury analyst