Assistant Business Analyst – Inventory Planning

PARKnSHOP (HK) Limited; Sha Tin; On-site; HKD 180,000 - 240,000; Full time

Job summary

PARKnSHOP Supermarket is seeking an Assistant Business Analyst in Inventory Planning to optimize stock levels across banners. You will analyze data on inventory management, forecasting and demand planning, develop reports and dashboards, and support replenishment systems to improve stock allocation and service levels.

The role requires a university degree in supply chain related field, 2 years’ experience in FMCG/retail, and strong Excel/SQL skills; Power BI and Python are a plus.

Qualifications

• University graduate in Supply Chain Management, Statistics, Economics or related discipline.
• 2 years’ working experience, preferably in FMCG or retail industry.
• Proficient in MS Office applications (Excel, VBA & SQL) and statistical/data-mining tools.
• Knowledge on Power BI & Python will be an advantage.

Responsibilities

• Provide analytical support on stock management to enhance the efficiency of supply chain activities and forecasting accuracy.
• Review inventory and stock allocation plans by producing and compiling reports (e.g. Slow Movement, Stock Week Coverage and On-Shelf Availability).
• Analyze product demand considering market and seasonal factors, and develop inventory planning proposals.
• Maintain the database accuracy and review replenishment system setting regularly.

Skills

Excel

VBA

SQL

Power BI

Python

Analytical thinking

Problem solving

Attention to detail

Education

Supply Chain Management

Tools

MS Office

Job description

Assistant Business Analyst – Inventory Planning

Working as a Business Analyst in Inventory Planning team, you will oversee and optimize the inventory levels of the designated product category across all banners under PARKnSHOP. You will analyze data in related to inventory management, forecasting, and demand planning to ensure effective stock allocation plans and replenishment systems. Additionally, you will be involved in developing reports and dashboards to track inventory performance metrics, contributing to process enhancements in inventory planning strategies.

A typical day in this Role:

Provide analytical support on stock management to enhance the efficiency of supply chain activities and forecasting accuracy.

Review inventory and stock allocation plans by producing and compiling reports (e.g. Slow Movement, Stock Week Coverage and On-Shelf Availability).

Analyze product demand considering market and seasonal factors, and develop inventory planning proposals.

Maintain the database accuracy and review replenishment system setting regularly.

This job a good fit for You if:

You are an Evaluator – You prefer to analyze information and ideas both from within and outside the team, studying their feasibility in terms of the team’s objectives.

You are a Collaborator – You enjoy exploring outside resources and develop contacts that may be helpful to the team. You value diverse opinions and love to collaborate.

Success will depend on:

University graduate in Supply Chain Management,Statistics, Economic or related discipline.

2 years’ working experience, preferably in FMCG or retail industry.

Proficient in MS Office applications (Excel, VBA & SQL) and statistical/data-mining tools.

Knowledge on Power BI & Python will be an advantage.

Attentive to details with good problem solving and analytical skills.

Self-driven, independent and able to meet tight deadlines and work under pressure.

Candidate with more experience will be considered as Business Analyst - Inventory Planning

We are an equal opportunity employer and welcome applications from all qualified candidates. The information provided will be treated in strict confidence and be used only for consideration of your application for relevant / similar posts within the AS Watson Group. All personal data of unsuccessful applicants will be destroyed within 12 months from the date of application.

PARKnSHOP Supermarket is part of AS Watson Group, the world’s largest international health and beauty retailer operating over 17,000 stores across 12 retail brands in 31 markets, with 130,000 people globally.

Founded in 1972, PARKnSHOP, under the AS Watson Group is the largest O+O supermarket chain in Hong Kong and one of the most trusted brands among local consumers. With over 240 stores across Hong Kong and Macau, PARKnSHOP operates several well-known retail brands, including FUSION, TASTE, TASTE x FRESH, FOOD PARC, and GREAT FOOD HALL.