Job Description

About us

We are a global consultancy that helps ambitious businesses solve tricky problems, overcome complex challenges, and achieve great things.



Working with global blue chips, SMEs, ambitious scale-ups, and inspiring charities, we bring decades of cross-sector expertise alongside our passionate, collaborative, and practical problem-solving process to deliver the right approach and real impact that gets our clients the results they want.



At Lancia Consult, our people have the freedom to think innovatively, work autonomously, and be empowered to make their own decisions, whilst working in a collaborative and supportive environment.

We are looking for a top achiever, a Junior Financial Analyst to join our team based in our Somerset West office, Cape Town.

Please note that this position will be based on-site and attendance in office will be expected four days a week.



This individual needs to have at least 1-2 years of relevant experience to support our team in financial modelling, financial data analytics, and strategic decision-making. The role will provide exposure to both traditional corporate finance work and modern data-driven analytics. The ideal candidate will be eager to learn, detail-oriented, and comfortable working with complex datasets as well as building forward-looking financial models.

Key Responsibilities

Financial Modelling

+ Assist in building, maintaining, and enhancing detailed financial models (three-statement, valuation, scenario, and sensitivity analysis).
+ Support development of increasingly complex models to guide client and internal decision-making.
+ Contribute to forecasting, budgeting, and scenario planning processes.

Financial Data Analytics

+ Analyze financial and operational data to identify trends, risks, and opportunities.
+ Support data cleansing, transformation, and integration into reporting models.
+ Work with BI tools (e.g., Power BI, Excel, SQL, Python preferred) to create dashboards and reports.
+ Conduct variance analysis, profitability reviews, and performance measurement.

Decision Support & Reporting

+ Prepare client-ready presentations and reports that translate analysis into actionable insights.
+ Collaborate with senior analysts and managers to deliver investor-grade materials (board packs, deal support documents, strategic reviews).

Technology & AI Enablement

+ Gain exposure to modern data platforms such as

Microsoft Fabric, Snowflake, and Databricks

.
+ Leverage AI tools extensively for financial analysis, forecasting, data transformation, and insight generation.
+ Opportunity to develop skills in

machine learning and predictive analytics

as part of advanced client work.

Continuous Learning & Development

+ Develop expertise in advanced financial modelling techniques and analytical tools.
+ Stay updated with industry standards, valuation methodologies, and emerging technologies in finance and analytics.

Qualifications

A completed degree in Finance, Accounting, Economics, or related field. Exceptional recent graduates with a top academic record in Finance, Data, or Statistics -- and demonstrable experience in financial modelling or financial data analytics (through internships, projects, or certifications) -- will also be considered.

Preferred certifications

: CFA (any level), FMVA, or equivalent.

Experience and Skills

1-2 years of relevant experience in financial analysis, corporate finance, investment banking, or consulting. Excellent Excel skills (advanced formulas, financial modelling best practices, data manipulation). Exposure to BI / analytics tools (Power BI, SQL, Python) is an advantage. Interest in modern data tools (Fabric, Snowflake, Databricks) and a willingness to learn. Strong analytical and problem-solving skills, with strong attention to detail. Clear communication skills with the ability to present findings to non-financial audiences. Ability to work under pressure, manage deadlines, and thrive in a high-performance environment.

Growth Path

This role is designed as an entry point into advanced financial modelling and analytics. The Junior Financial Analyst will have the opportunity to take on increasing responsibility in:



Complex valuation work and strategic financial modelling. Advanced data analytics, machine learning, and predictive modelling. Extensive use of AI in day-to-day workflows. Direct client engagement and presentation of insights. Progression towards Senior Analyst and Associate roles

How to apply

Thank you for taking the time to apply! If you are interested in a conversation with us to learn more, please

s

ubmit your CV & cover letter

to apply directly.



At Lancia Consult we are truly committed to positive, inclusive and accessible recruitment and are proud to be an equal opportunities employer. We actively encourage all applications and know that an empowered team with varied perspectives and relevant experience, operating in an inclusive environment allows us all to reach our full potential.