BUSINESS ANALYST - Financial | POWER BI

SUMMARY:
OVERVIEW:

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.

POSITION INFO:
Qualification and Experience

• Accounting Degree (BCom or BAcc)
• CA(SA) recommended
• Experience with MS Excel Power Query preferred
• MS Excel – advanced level
• Experience with ERP systems
• Financial background

• Automating existing reporting systems, whether financial or non-financial, using tools like Excel Power Query
• Centralising reporting of financial and non-financial data

• 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.

• 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.

• 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.

• Conduct in-depth financial analysis, including ratio analysis, trend analysis, and benchmarking.
• Prepare accurate and timely financial reports, including monthly, quarterly, and annual reports.