FP&A Analyst: Master Forecasts & Data-Driven Reporting

123 Consulting; Johannesburg; On-site; ZAR 600,000 - 900,000; Full time

Job summary

123 Consulting in Johannesburg is seeking an FP&A Analyst to join the finance team. You will be central to month-end reporting, turning large volumes of financial data into accurate, timely reporting.

The role includes budgeting, forecasting and ad-hoc analysis, with strong Excel skills and Power BI experience. You will work across multiple entities, ensuring data integrity and delivering clear management reporting on time.

Qualifications

• A recognised degree in Finance, Accounting, Economics or a related field.
• 3+ years’ experience in finance, accounting or FP&A.
• Experience in preparing management accounts, budgeting and forecasting, and presentations.
• Advanced Excel skills, including lookup functions (XLOOKUP/INDEX-MATCH), SUMIFS, PivotTables and working efficiently with large datasets. Experience with Power Query is advantageous.
• Proficiency in the wider Microsoft 365 suite, particularly PowerPoint and Word, for clear, professional reporting.
• Exceptional organisation and attention to detail, with a proven ability to deliver accurate work to strict timelines.
• Comfortable working across multiple entities or organisations, and managing differing requirements, data formats and priorities.
• Familiarity with financial reporting processes and accounting systems (e.g. Xero, Fathom).
• Strong written and verbal communication skills, and a collaborative approach to working with a team in a different location.
• Experience with Power BI, including building or maintaining dashboards and reports.
• Practical experience using AI tools to improve analysis, reporting or productivity, or an interest in doing so.

Responsibilities

• Month-end reporting: Prepare, consolidate and validate financial data from multiple organisations to support monthly, quarterly and annual reporting.
• Modelling and forecasting: Maintain and update financial models, budgets and forecasts, ensuring formulas, links and assumptions are accurate and well documented.
• Analysis: Track and analyse KPIs, investigate variances, and summarise findings clearly for senior finance staff.
• Presentation of results: Build and refine reports and presentations for management, ensuring consistent formatting and accuracy.
• Data integrity: Perform reconciliations and data updates in financial systems, and maintain the integrity and organisation of financial databases.
• Planning and delivery: Manage competing deadlines across multiple entities, keeping files, trackers and version control in good order.
• Ad-hoc and improvement: Support ad-hoc analysis, projects and process improvements, including opportunities to automate recurring tasks.

Skills

Advanced Excel

Budgeting

Forecasting

Data analysis

Presentation skills

Power Query

Xero familiarity

Education

Finance/Accounting/Economics degree

Tools

Power BI

Microsoft 365

PowerPoint

Word

Job description

123 Consulting in Johannesburg is seeking an FP&A Analyst to join the finance team. You will be central to month-end reporting, turning large volumes of financial data into accurate, timely reporting.

The role includes budgeting, forecasting and ad-hoc analysis, with strong Excel skills and Power BI experience. You will work across multiple entities, ensuring data integrity and delivering clear management reporting on time.