Deskripsi Pekerjaan
Are you a data enthusiast with a keen eye for detail? Eraya is seeking a dedicated Category Planner & Support Staff to join our growing team. In this pivotal role, you will be the backbone of our planning operations, ensuring that our inventory data is accurate, actionable, and ready to drive business decisions. You will leverage advanced Excel skills to transform complex datasets into clear, insightful reports that support our merchandising strategies.
As a key support staff member, you will work closely with the Category Planning team to monitor stock levels, analyze sales trends, and forecast demand. Your expertise in Days of Stock (DOS) analysis will help us optimize our supply chain and ensure our products are available when our customers need them. If you are looking for a challenging role in a dynamic retail environment where your analytical skills will make a tangible impact, we want to hear from you.
Tanggung Jawab
- Develop and maintain complex spreadsheets and reporting tools using advanced Excel functions, including Pivot Tables, VLOOKUP, and XLOOKUP.
- Conduct comprehensive Days of Stock (DOS) analysis to monitor inventory turnover and optimize stock levels across multiple categories.
- Support the Category Planning team in preparing accurate sales forecasts and seasonal inventory reports.
- Manage and update product databases to ensure data integrity and consistency across all reporting channels.
- Collaborate with internal stakeholders to align inventory strategies with sales targets and promotional calendars.
- Create visual dashboards and summary reports to communicate key performance indicators (KPIs) to management.
- Assist in the coordination of stock takes and data reconciliation processes.
Kualifikasi
- Proficiency in Microsoft Excel, with strong hands-on experience in Pivot Tables, VLOOKUP, XLOOKUP, and data modeling.
- Bachelor's degree in Business Administration, Logistics, Supply Chain Management, or a related field.
- Strong analytical mindset with the ability to interpret large datasets and identify actionable insights.
- Excellent attention to detail and high level of accuracy in data entry and reporting.
- Good communication skills, with the ability to present complex data findings to non-technical audiences.
- Ability to work independently and collaboratively within a fast-paced team environment.
- Familiarity with retail planning software or ERP systems is a plus.