Hiring a financial modeller on Excel skills alone misses what makes a model useful. This post sets out the interview questions that test whether a candidate can explain complex problems simply, understand what drives value, and build driver-based 3-way models, scenarios and Power BI outputs.
How do you hire an expert financial modeller?
Is your hiring methodology keeping pace with the current demands in financial modelling skills?
What about influencing, communication, visualisation design and other “non technical” but creative free thinking skills.
How do you hire or even identify an expert?
Is asking them about their advanced Excel skills good enough?
How do you check the validity of their claims during or before an interview?
Do you have a quick/digital assessment process?
One of the evolving trends in finance and accounting today is the need for finance transformation (people first digital later).
What exactly is finance transformation if you don’t honestly transform all aspects of the finance team, including how you hire talent?
This is not just about technology but also the mindset.
What about the skills of the people that you bring into your organisation?
Are you hiring for growth mindset and self awareness or simply adding to the pile of fixed minds.
What interview questions should you ask a financial modeller?
You are probably now wondering how to solve some of those questions above.
You need to make sure that the right people with the right skills are hired.
But what are the right skills?
Firstly and most importantly is the way in which candidates communicate and explain themselves.
You might want to consider the following questions:
- How well can they articulate complex problems simply, get them to explain one?
- Can they really decipher complexity and convert it into simple solutions?
- Do they know what is the difference between analytics and financial modelling?
- What does value mean in the context of accounting and finance to them? Hopefully they don’t say producing a great report that is useful.
- How do they increase the value of a company?
- What might be the drivers of your company (where they are applying) in terms of how it might drive value for shareholders?
- Have they ever built a driver based rolling 3-way financial model and changed these drivers in a dynamic conversation with someone using just Excel?
- Can they build a sensitivity, scenario or simulation manager in Excel?
- Have they ever used PowerBI, PowerPivot and PowerQuery?
- What about beyond Excel and outside tools and coding languages do they know?
- What’s the most complex problem they have faced and explain the problem and how they solved it?
All of these questions are trying to get them not to talk about Finance problems but real business problems and helping them to make better decisions.
Start by putting them into deeper water on those business problems and ask how they solve them simply.
But all of this is a little useless if you don’t know how to communicate and influence with the right mindset and self awareness.
Where can you find a full stack modeller?
If you want to know more about a talented full stack modeller (soft.skills and mindset) then come along and take a look at FSM.
If you are wanting to convert your current staff to high quality talent then perhaps direct them to FSM.
If you are in the market and want to get hired, perhaps you have struggled of late, perhaps this is a great way to differentiate yourself from others who are just good at Excel.
Being just good at Excel is simply not enough.
To automate the repeatable parts of modelling, we built EXL Cloud, our own SaaS modelling platform: driver-based 3-way models in Excel, connected to Xero, with a library of Claude skills that help build, check and report on the model while the modeller keeps control of the logic.
Frequently asked questions
What does a financial modeller do?
A financial modeller builds models that turn a business’s drivers, such as volumes, prices, costs and timing, into forecast financial statements, valuations and scenarios. The model lets decision makers test options before committing money. The best modellers also explain the results clearly, so managers and boards understand what drives value and risk.
What skills should a financial modeller have?
Strong Excel and accounting knowledge are the baseline: three-statement integration, driver-based logic, and scenario and sensitivity tools. Beyond that, look for Power Query, Power Pivot and Power BI, an understanding of what drives value in a business, and the ability to explain complex problems simply. Communication and a growth mindset separate good modellers from great ones.
What questions should you ask when hiring a financial modeller?
Ask candidates to explain a complex problem simply, describe the difference between analytics and financial modelling, and identify the value drivers of your business. Ask whether they have built a driver-based rolling 3-way model and a scenario or simulation manager in Excel. Then ask about the hardest problem they have solved and how.
Is being good at Excel enough to be a financial modeller?
No. Advanced Excel skills are necessary but not sufficient. A financial modeller also needs to understand the business and its value drivers, structure models that others can follow and trust, and communicate results to people who aren’t finance experts. Hiring on Excel tests alone misses the influencing and problem-solving skills that make a model useful.
What is a full stack modeller?
A full stack modeller combines technical modelling skills with the softer skills that make models useful. That means building integrated, driver-based models in Excel and related tools such as Power Query and Power BI, plus communication, visual design, influencing and a growth mindset. The term borrows from full stack developers, who work across the whole technology stack.
Need expert modelling without making a hire? See our Financial and Business Modelling services.
Related reading: Best Practice Formula Construction for Financial Modelling and The Demand for Financial Modelling Skills Reaches new Heights.
Further reference: Financial Modelling Institute.
About the Author
Lance Rubin is CEO and Founder of Model Citizn, and founder and Chief Excel Officer of EXL Cloud, the SaaS platform that connects Xero to Excel with driver-based financial models, dashboards and Claude AI skills. He is a Chartered Accountant, FMI Certified Trainer, co-author of the CA ANZ Financial Modelling Study Guide, and creator of the AI-Powered Accountant programme on Maven, currently live at Level 1 with Level 2 in design, and author of the companion book “AI-Powered Accounting with Excel and Power BI” (Packt). He has worked at PwC, KPMG, Investec, and NAB, and is based in Melbourne, Australia.

