Junior Financial Analyst test Dubai

Employers in Dubai usually test junior candidates with three practical tasks: Excel modelling, valuation questions, and a short case study. These tests check your number skills, your logic, and how fast you work under pressure. If you want to find roles in the field, start by practising these common exercises and browse banking and finance jobs in Dubai to see real hiring ads.

What the junior financial analyst test Dubai includes

Most tests fall into three types. Employers often mix them in one interview.

• Excel modelling test — build or fix a small financial model in Excel. Expect formulas, simple forecasts, and error checks.
• Valuation question — a short exercise on DCF (discounted cash flow) or comparables. They check you know the key steps and assumptions.
• Mini case study — a written problem with numbers. You read, calculate, and give 1–3 quick recommendations.

How an Excel modelling test looks (sample tasks)

Excel is the most common. Tests are short. You usually get 30–60 minutes.

Sample task 1 — Forecast a P&L for 3 years

You get last year numbers: revenue AED 100,000, cost of goods sold 60% of revenue, operating expenses AED 20,000. Forecast revenue growth: Year 1 = 10%, Year 2 = 8%. Build a simple Profit & Loss and show net income each year.

What the interviewer checks:

• Correct formulas for growth and margins.
• Use of cell references, not typing numbers repeatedly.
• A quick sanity check (gross margin should remain close to 40%).

Sample task 2 — Fix broken formulas

You are given a sheet that sums costs incorrectly. Find and fix the error. Add one conditional format rule to highlight negative values.

What they want to see: fast debugging, clear steps, and tidy formatting.

Sample task 3 — Quick sensitivity table

Make a small sensitivity table that shows how net income changes if revenue growth is 5%, 10% or 15% and if margin is 35%, 40% or 45%. Use a two-way table and show the outcome cells clearly.

This shows you can present different scenarios quickly.

Common valuation interview questions in Dubai

Valuation questions are short. They test the method and the assumptions.

• Explain the DCF steps and why you choose a discount rate.
• Do a simple DCF on one forecast year and a terminal value. Show the math.
• Give one comparable company and explain the logic behind the multiple you picked.

Mini valuation exercise (small example)

Starter figures: projected free cash flow next year AED 1,000, discount rate 10%, long-term growth 3%. Calculate a simple terminal value using the Gordon Growth formula and one-year discounted value. Show the answer and the formula used.

Interviewers look for: correct formulas, clear assumptions, and how you explain the result in one sentence.

Sample mini case study you can practice

Practice with this short case. Keep answers to a page.

Case: A local retailer has revenue AED 5m, gross margin 30%, operating costs AED 800k. Management asks if opening a second store is viable. Do a 3-line model: forecast revenue growth of 15% in year 1 for the new store, same margins, and initial store cost rising 5% due to shared overheads. Give a one-paragraph recommendation and one sensitivity (e.g., what if sales are 20% lower).

This tests quick math, clear recommendation, and risk thinking.

Skills employers look for (by city/country)

Hiring needs change across the Gulf. Below are practical differences you will meet when applying for junior roles.

Dubai (UAE)

• Strong Excel and presentation skills. Employers expect tidy models and clear charts.
• Banking, asset managers, and corporate finance teams hire junior analysts regularly.
• English plus basic Arabic can help but is not always required.

Abu Dhabi (UAE)

• Similar technical needs to Dubai, but more government-owned firms and energy sector roles.
• Employers value long-term modelling and sector knowledge. You can browse banking and finance jobs in Abu Dhabi to see what they list.

Riyadh (Saudi Arabia)

• Higher volume of corporate finance roles linked to large local groups. Many tests include compliance and regulatory basics.
• Local market knowledge and Arabic are more often asked for. See active roles by checking banking and finance jobs in Riyadh.

Doha (Qatar)

• Smaller market. Tests are similar to Dubai but often done by multinational consultancies or bank branches.
• Expect a mix of Excel tasks and short presentation questions.

Certifications and qualifications that help

• CFA Level I — shows basic finance knowledge and is well recognised across the Gulf.
• ACCA or accounting degree — useful if the role is close to reporting or audit.
• Recognised Excel/financial modelling courses (for example, Corporate Finance Institute programmes or Microsoft Excel certifications) to prove hands-on skills.
• A bachelor’s degree in finance, accounting, economics, or a related field.

Estimated salary range (junior levels)

Estimate: in Dubai, junior financial analyst pay typically ranges from AED 6,000 to AED 15,000 per month. This depends on the employer type, your skills, and whether benefits like housing or health cover are included. Use this only as a guide and check current job ads.

How to practise these tests at home

• Build the same 3-year P&L and cash-flow model from the Excel example above.
• Time yourself. Try a 45-minute run-through combining one Excel task and one valuation question.
• Record a one-minute explanation of your valuation assumptions. Employers want clear, short explanations.
• Apply to open roles and practise with real job descriptions. Start by visiting category pages like accounting and auditing, business and management, information technology, or purchasing and procurement to see related openings and the skills they ask for.

Related jobs to consider

• Accounting and auditing — close to financial reporting and controls.
• Business analyst or management trainee — learn corporate finance from the operations side.
• Data analyst / BI roles — use Excel and basic SQL for finance tasks.
• Procurement analyst — good if you like cost analysis and supplier data.

People also ask

See short answers to real questions candidates search for.

How long is a junior financial analyst test in Dubai?

Most tests last 30–90 minutes. Short phone or online tests can be 20–30 minutes. In-person case tests or combined technical rounds may take up to 90 minutes. Always ask the recruiter how much time to expect before the test.

What should I bring to an Excel modelling test?

Bring a clean laptop with Excel installed if asked. Also bring a calculator and a printed copy of your CV. If the test is online, ensure a quiet place and a stable internet connection. Confirm rules about external resources with HR beforehand.

Are valuation questions common in Dubai interviews?

Yes. Many banks and corporate finance teams include at least one valuation or DCF question. The depth varies — sometimes they only ask you to explain the steps and assumptions rather than build a full model.

How can I practice a junior finance case study Dubai style?

Practice with one-page cases that include revenue, margins, and a single ask (e.g., open a store). Build a quick 3-line model, write a one-paragraph recommendation, and prepare one sensitivity. Time yourself to improve speed and clarity.

Is the Excel modelling test different across Gulf cities?

The core skills are the same. Differences are in the sector and language needs. For example, energy firms in Abu Dhabi may ask industry specifics, while Riyadh roles might place higher value on Arabic and local-market knowledge.