Posted: 28 January 2025
Job Details
The main purpose of this role is to develop and implement automation and reporting solutions where there is a business need. The nature of the role is ad-hoc projects, as and when a business need is identified. Business needs can vary from automation and restructuring of management accounting, reporting of financial and non-financial indicators, as well as production reporting.
Automation
• Automating existing reporting systems, whether financial or non-financial, using tools like Excel Power Query
• Centralising reporting of financial and non-financial data
Margin Reporting
• Prepare detailed margin analysis reports, including gross margin, net margin, and contribution margin.
• Identify trends and variances, and provide explanations for significant fluctuations.
• Analyse product profitability and recommend strategies to improve margins.
Management Accounts per Business Unit and Export Country
• Prepare comprehensive management accounts for each business unit/export country/manufacturing process.
• Analyse financial performance, including revenue, cost of sales, and operating expenses.
• Identify opportunities for cost reduction and revenue growth within each business unit.
Production Cost Reporting:
• Prepare detailed production cost reports, including standard costs, actual costs, and variances.
• Analyse production variances to identify areas for improvement in efficiency and cost control.
• Work closely with operations teams to understand production processes and cost drivers.
Financial Analysis and Reporting:
• Conduct in-depth financial analysis, including ratio analysis, trend analysis, and benchmarking.
• Prepare accurate and timely financial reports, including monthly, quarterly, and annual reports.
Ad-hoc Reporting and Analysis:
• Respond to ad-hoc requests for financial information and analysis.
• Support the business in strategic planning and decision-making by providing relevant financial insights.
Health and Safety
• Participate in safety forums created by the employer for example safety meetings and safety talks
• Follow-up on any activities assigned through safety meetings / committees / representatives / management
• Report all safety incidents to the relevant people
• Attend safety education and refresher programmes
• Comply with safety policies and procedures at the employer
• Distribute safety information as and when required
• Wear protective clothing (where applicable) at all times
Qualification and Experience
• Accounting Degree (BCom or BAcc)
• CA(SA) recommended– no post-articles experience required
• Experience with MS Excel Power Query preferred
• MS Excel – advanced level
• Experience with ERP systems recommended
Knowledge, Skills and Attributes
• Data analytics
• Microsoft Excel (advanced)
• Excel Power Query and Power BI
• Financial background
• Quick learner, adaptable
• Attention to detail
• Strong analytical skills