Job Details:

• We are seeking a highly analytical and detail-oriented Financial Analyst to join our team.
• The ideal candidate will play a key role in driving gross profit visibility, optimising working capital efficiency, and providing actionable financial insights to support business decision-making. This role requires expertise in financial analysis, Power BI reporting, and stakeholder engagement.
• If you are ready for a challenge, please apply.

Requirements:

Educational

• Grade 12 or equivalent.
• Finance Degree (B. Com Accounting or BCompt).

Experience

• 3+ years in in a similar role.
• Experience with business intelligence tools preferably Power BI.

Skills

• Strong administrative skills with high attention to detail.
• Excellent interpersonal and communication skills across various stakeholders.
• Strong Interest in data
• Ability to adapt to change quickly and easily.
• Proficient in MS Office suite, specifically advanced skills in Excel.

Personal Attributes

• You remain calm under pressure, maintaining composure and focus in high-stress situations.
• You are performance and deadline-oriented, ensuring tasks are completed efficiently and on time.
• You are proactive and able to use initiative, anticipating challenges and taking action without needing direction.
• You are able to multi-task, effectively managing multiple responsibilities while maintaining quality and accuracy.
• You are assertive, confidently expressing your ideas and standing by your decisions while respecting others.
• You think outside the box, bringing creativity and innovation to problem-solving and decision-making.

Responsibilities

Gross Profit (GP) Visibility

• Conduct detailed gross profit analysis by customer, product, and category using Power BI.
• Identify GP trends, problem areas, and underlying reasons for fluctuations.
• Provide weekly commentary and insights to the business based on Power BI analytics.

ROFI Analysis

• Enhance working capital efficiency through the analysis of ROFI components for customers and products.

Target Setting

• Establish and monitor the achievement of product and sales targets monthly.
• Compare actual performance to budget and target achievements.

Commissions and Rebates

• Calculate monthly commission earnings based on GP performance.
• Manage the collation and calculation of all customer rebates.
• Ensure accurate recording and reporting of vendor rebates and special pricing mechanisms.

Financial Analysis and Reporting

• Interpret monthly financial performance, including expense analysis, cost driver identification, and branch performance.
• Assist with budgeting and forecasting processes.
• Automate reports and enhance business intelligence insights from the ERP system.
• Utilise Power BI to visualize financial data and improve reporting accuracy.
• Ensure the monthly reconciliation between Cube and General Ledger (GL).

Business Operations and Stakeholder Engagement

• Collaborate with product managers, sales teams, executives, and finance to ensure effective communication and data-driven decision-making.
• Ensure BI reporting aligns accurately with ERP system data.
• Perform any additional tasks as required by management.