My client a Mining Consumables privately owned business are seeking a Finance Analyst with good Power Bi and Pronto.

Responsible for ensuring effective planning, analysis and reporting of production activities, as well as effective management of a group of subcontractors. Key Accountabilities or Activities Include key measures and outputs (how the performance of the incumbent is to be objectively measured using qualitative or quantitative data).

1) Ownership and Development of Pricing and Costing Model

Develop costing and freight costs in conjunction with Engineering and Logistics

Develop competitive pricing models

Benchmark pricing against known competitors to help win tenders

Develop price review mechanisms in conjunction with Commercial

Develop margin analysis models by category

Develop margin analysis models by customer

2) Planning

Regular benchmark planning report against known market moves in pricing

Set the process for price review per contract and overall within the market

Develop forecasting models for potential cost impacts based on raw material costs, exchange rates and shipping rates

Lead review of stock holding / category reliance based on cost structures

3) Creation of reporting structures within Power BI

Power BI experience is essential for this role

Analysis of all operational aspects of the business

Reporting on inventory trends

Creating customer focused Power BI Reports monthly and quarterly

Creating stock management reporting within Power BI

Creating Operations and Site Dashboards within Power BI

4) Analysis

Recoverable reports

Efficiency reports

Batch costs and costing of individual inventory items

Gross margin reporting

5) Financial Reporting

Ownership of all gross margin reporting

Ownership of inventory holding and inventory stock turn reporting within warehouse and customer based stocks

Contribute to Board pack reporting with all of the above

Knowledge:

Industry experience and knowledge of product highly desirable, not essential

Analytical understanding

Effective presentation delivery

Well developed training and documentation skills

Ability to learn and absorb knowledge