Junior Financial Analyst CV: How to Tailor It to Any Job Description (UK)

Junior financial analyst roles span corporate FP&A, management accounting, commercial finance, and financial planning teams. The CV challenge is consistent: evidence numerical rigour, commercial understanding, and the Excel proficiency that every finance team runs on.

What financial analyst employers look for

Core technical skills:

Excel: financial modelling, pivot tables, VLOOKUP/INDEX-MATCH, Power Query, scenario analysis, data validation, dynamic charts
Financial accounting: P&L, balance sheet, cash flow — understanding the mechanics of all three
Management accounting: variance analysis, cost centre reporting, budget vs actual
Financial modelling: DCF, LBO (for corporate finance roles), three-statement models

FP&A specific:

Budgeting and forecasting cycles
Management information reporting
Driver-based modelling
KPI dashboard development (Excel, Power BI, Tableau)

Commercial finance:

Business partnering — presenting financial data to non-finance stakeholders
Pricing analysis, margin analysis, cost reduction identification
Scenario and sensitivity analysis

Professional development:

CIMA, ACCA, or ACA study — most FP&A and management accounting roles expect part-qualification or willingness to study
CFA Level I — particularly relevant for corporate finance and investment analysis roles

Personal statement example

"Analytically rigorous Finance graduate (University of Leeds, 2:1, 2024) with strong Excel financial modelling skills and a commercial mindset developed through a placement year in the FP&A team at [Company]. Built a rolling 18-month cash flow forecast model and owned monthly variance commentary for three cost centres. Currently studying for CIMA CGMA and intending to complete the Certificate level by December 2024. Seeking a junior financial analyst or FP&A analyst role where I can build on my placement experience and develop into a business-partnering finance function."

How to evidence Excel and modelling skills

Excel is the core tool of financial analysis. Be specific:

"Built a dynamic three-statement financial model in Excel for the annual budget exercise, incorporating 14 driver assumptions and producing automated variance outputs for the CFO's monthly board pack."

"Developed a cost centre reporting dashboard in Excel using Power Query to consolidate data from 6 ERP exports, reducing the monthly reporting close from 3 days to 4 hours."

"Created a DCF sensitivity analysis model for a capital expenditure proposal, varying discount rate and revenue growth assumptions across a 5-year forecast — presented to the Finance Director with a recommendation for approval."

Variance analysis: language to use

Many junior finance JDs mention variance analysis. Use the language correctly:

"Produced monthly P&L variance commentary for 5 cost centres, identifying and explaining a £140k adverse variance in logistics costs driven by fuel surcharge increases not captured in the original budget assumptions — contributed to a revised Q3 forecast adjustment."

Skills section

Excel: Advanced (pivot tables, Power Query, INDEX-MATCH, scenario analysis, financial modelling)

Financial systems: SAP, Oracle, Hyperion, Workday (list what you have used)

Reporting/BI: Power BI, Tableau, Looker (if applicable)

Qualifications: CIMA Certificate / ACCA Applied Knowledge (if studying — include completion date or study status)

Other: Python (financial data analysis), SQL (basic queries), Bloomberg Terminal (if applicable)

Tailoring to FP&A vs corporate finance vs management accounting

FP&A: Emphasise budgeting, forecasting, driver modelling, management reporting, KPI development, and stakeholder communication.

Corporate finance (M&A, transactions): Emphasise financial modelling (DCF, LBO, accretion/dilution), Excel proficiency, deal research, and quantitative analytical strength.

Management accounting: Emphasise cost centre reporting, variance analysis, month-end close processes, and accounting software proficiency.

Frequently asked questions

Should I start CFA Level I before applying?

Registering for CFA Level I before applying signals serious intent and differentiates you for corporate finance, investment analysis, and commercial finance roles. If you have passed it, lead with it prominently. If you are registered and sitting it, state "CFA Level I — sitting [month/year]."

Do I need to be CIMA or ACCA part-qualified already?

Not for entry-level analyst roles. Most employers offering study support will provide CIMA or ACCA training as part of the employment package. Demonstrating awareness of the qualification pathway and intention to study is sufficient.

Is Power BI or Tableau important for junior analysts?

Increasingly yes — particularly for FP&A and commercial finance roles where self-service dashboards are replacing static Excel reports. Even basic Power BI proficiency is a differentiator at junior level.