Demand and Inventory Analyst
Responsibilities
As an integral part of the Commercial Operations team, reporting to the Demand Manager, the individual will be responsible for:
* Monthly review of forecasted demand by sku, aligned to the Demand Review and S&OP process timelines.
* Review of projected demand, stock, and replenishments to identify risks of stock shortage or obsolescence in advance. Work with the supply planners to adjust replenishments as necessary to reduce such risks.
* A weekly review of current stock holding to identify any slow-moving inventory, possible expiry date risk and stock shortages.
* Prepare and manage Request of Changes to Master Arrival Schedule and get corresponding approvals (formal RCMAS process).
* Prepare and review forecast accuracy reports, KPI reports and other reports for discussion at Demand Reviews, highlighting the main messages for the commercial and finance teams
* Perform stock reconciliation activities on a regular basis to ensure stock holding is reported accurately in SAP
* Ongoing review, maintenance, and submission of the affiliate’s Material Master Data
* Reporting of actual and potential back orders for the affiliate through the back-order tool
* Preparation and review of the stock provision accrual, based on current stock holding, forecasted demand and expiry/artwork changes
* Support the 3PL with the smooth processing of inbound shipments and support as necessary
* Analyse the 3PL monthly stock counts to ensure that all inventory is counted as per policy
* Ad-hoc analysis where demand is consistently ahead of forecast to ensure a thorough understanding is gained of what the drivers are
* Support the use of the Statistical Forecasting process, ensuring that the forecast is accurate and support the correct stock levels
* Provide monthly reporting on inventory, summarised by brand
* Support Customer Service queries related to outbound deliveries and inventory
* Providing support for:
* the Crisis Management Team where possible stock shortages are identified
* new asset launches and product discontinuations as required
* the customer service team as required
Skills, Knowledge and Qualifications
Systems
Microsoft Suite, including excel
SAP (preferred)
JDA (preferred)
Business Knowledge
Previous Demand or Supply experience
Strong analytical skills
Knowledge and experience of the Supply Chain processes
Previous experience working in an international business setting (desirable)
Pharmaceutical Industry background (preferred)
Qualifications and Competencies
Highly analytical with a desire and ability to learn quickly
Ability to prioritise and work to tight deadlines.
Highly results driven. Comfortable working in a fast-moving, multi-tasking environment and able to cope with high degrees of uncertainty
High attention to detail and accuracy
Strong inter-personal skills to enable the smooth implementation of changes
Good commercial acumen
Excellent communication skills, both oral and written