Job Description

Minimum requirements:

• Accounting Degree (BCom or BAcc)
• 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

Role and responsibilities:
Automation

• Automating existing reporting systems, whether financial or non-financial, using tools like Excel Power Query
• Centralizing 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
• 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
• Distribute safety information as and when required
• Wear protective clothing (where applicable) at all times

ExecutivePlacements.com