Finance FP&A Data Analyst

Hybrid Full TimeCape Town, Western Cape, South AfricaEuromonitor

The Finance FP&A Data Analyst plays a central role in transforming how Finance, Operations, and Commercial teams leverage data to drive decision making. The role blends deep financial expertise with analytics, data modelling, and visualisation/presentation capabilities.

Requirements

  • Deliver advanced financial analysis, modelling, and scenario planning.
  • Support FP&A cycles, including budgeting, forecasting, and performance reviews.
  • Translate complex datasets into actionable recommendations for senior leadership.
  • Provide insight across revenue, cost, margin, headcount, and operational KPIs.
  • Support people analysis to ensure we understand our cost base and are able to report/forecast/scenario plan efficiently to a high standard.
  • Apply analytical thinking to solve ad hoc and strategic business challenges.
  • Develop robust Power BI dashboards using Power Query, DAX, and strong data modelling practices.
  • Enhance and maintain existing dashboards including financial performance, workforce planning, sales compensation, and operations insight.
  • Build automated data refresh processes and reporting pipelines.
  • Translate business requirements into intuitive, high impact dashboards.
  • Validate and map data from core systems including Dynamics 365 Finance, Salesforce, and SaaS billing platforms.
  • Own and maintain finance KPI definitions, ensuring alignment across reporting tools.
  • Embed reconciliation logic, audit requirements, and financial controls within data pipelines.
  • Work closely with Data Engineering to ensure models are scalable, well documented, and governed.
  • Lead and manage analytical projects spanning FP&A, Commercial, Ops, HR/Reward, and Tech.
  • Support the business with modelling for compensation, sales commissions, workforce analytics, bonus modelling, and scenario analysis.
  • Collaborate with stakeholders to refine project objectives, timelines, and deliverables.
  • Support monthly, quarterly, and annual modelling cycles (e.g., bonus files, salary review models, workforce dashboards).
  • Champion the evolution of finance data architecture and reporting standards.
  • Identify opportunities for automation and operational efficiency.
  • Promote data literacy within Finance and the wider business.
  • Collaborate with the Data Product Manager to define data requirements and analytics priorities.

Benefits

  • Competitive salaries
  • Enhanced healthcare
  • Pensions
  • Generous holiday allowances
  • Hybrid working
  • Core Hours policy
  • Two volunteering days a year
  • Donation amount on joining

Tagged as: , ,

Before applying for this position you need to submit your online resume. Click the button below to continue.

Tired of manual job applications?

JobCopilot auto-applies to thousands of RevOps and GTM roles on your behalf — so you can focus on interviews, not applications.

Applying for this role?

Tailor your resume to this exact role — hiring managers notice the difference.

Latest articles on the blog

RECRUITERS!

Reduce the risk of your recruitment process (applicant quality, long and inefficient process) by selecting from a relevant pool of candidates.

POST A NEW JOB NOW!