Sales and Inventory Analyst

Power Crank Batteries; Melbourne; On-site; AUD 80,000 - 110,000; Full time

Job summary

Power Crank Batteries is seeking a Sales and Inventory Analyst to transform business data into actionable insights across its branch and warehouse network in Australasia. You will support demand planning, track actions to completion, and collaborate with Sales, Procurement, Operations and Finance to optimize stock availability and profitability.

The role focuses on delivering timely reports, dashboards and recommendations to improve stock turnover, reduce excess inventory and drive profitable

Qualifications

• Experience in sales analysis and inventory reporting.
• Experience extracting data from ERP or inventory systems.
• Familiarity with Power BI or similar dashboards is desirable.

Responsibilities

• Prepare daily, weekly and monthly reports by branch, salesperson, customer, product and channel.
• Compare sales and gross margin to budgets and forecasts; explain variances.
• Analyse product mix and customer buying patterns to prioritise activity.
• Provide dashboards and summaries with findings and recommended actions.
• Report stock on hand, stock on order, in transit, backorders and inventory value by location.
• Identify shortages and slow-moving items; elevate risks early.
• Recommend transfers to balance stock and meet demand.
• Monitor stock age and rotation; flag items for rotation or recharge.

Skills

Pivot tables

Excel

Power Query

Power BI

Demand planning

Sales analysis

Data reconciliation

Education

Business/Analytics/Finance or Supply Chain qualification

Tools

ERP systems

Inventory management software

Job description

The Sales and Inventory Analyst creates accurate, timely reports that help Power Crank Batteries understand sales performance and manage inventory across its branch and warehouse network. The role turns business data into clear insights and practical recommendations to improve stock availability, reduce excess inventory and support profitable sales growth. Working with Sales, Procurement, Operations, Finance and branch teams, the analyst identifies risks and opportunities, supports demand planning and tracks agreed actions through to completion.

Key responsibilities

• Prepare daily, weekly and monthly sales reports by branch, salesperson, customer, product and sales channel, including retail, trade and OEM
• Compare sales and gross margin against budgets, forecasts and prior periods; explain material variances, trends and growth opportunities
• Analyse product mix, customer buying patterns and inactive or declining accounts to help sales teams prioritise activity
• Provide concise dashboards and management summaries with clear findings, recommended actions and follow-up measures
• Report on stock on hand, stock on order, goods in transit, backorders, stock cover and inventory value by product and location
• Identify shortages, excess stock, slow-moving items, ageing stock and potential obsolete inventory; elevate risks early
• Recommend branch and warehouse transfers to balance stock, meet demand and reduce unnecessary purchasing
• Monitor battery stock age and flag items requiring rotation, inspection or recharge under company procedures
• Use sales history, seasonality, customer forecasts and planned promotions to prepare demand forecasts and replenishment recommendations
• Validate and reconcile reporting data with Finance and operational teams; investigate discrepancies before issuing reports

About you

• Demonstrated experience in sales analysis, inventory reporting, demand planning or a related analytical role
• Strong Excel skills, including pivot tables, lookup formulas and data cleansing; Power Query experience is desirable
• Experience extracting and analysing data from ERP, inventory or business management systems. Power BI or similar dashboard experience is desirable
• Understanding of sales, gross margin, stock turns, stock cover, replenishment and the relationship between inventory and working capital
• Strong attention to detail and the ability to reconcile data, investigate causes and explain findings in plain language
• Ability to turn analysis into practical recommendations, prioritise competing deadlines and follow up agreed actions
• Confident communication and collaboration with branch teams, salespeople, managers and Finance
• Experience in wholesale distribution, automotive products, batteries or a business with multiple branches is desirable. A relevant qualification in business, analytics, finance or supply chain is advantageous

About us

Power Crank Batteries is a an Australasian business with a branch and warehouse network across Australia and New Zealand managing sales performance and inventory across multiple locations.