Merchandise Analyst (open to fresh graduates!)

RUSTAN COMMERCIAL CORPORATION; Makati; On-site; PHP 300,000 - 540,000; Full time

Job summary

Rustan Commercial Corporation is seeking a Merchandise Analyst (MPC Analyst) to support budgeting, sales and inventory planning. You will assist the MPC Officer and Senior Analyst to monitor performance and ensure timely reporting.

The role emphasizes data accuracy, coordination with IT and merchandising teams, and preparation of training materials. Fresh graduates may apply and the team values integrity and analytical rigor.

Qualifications

• College graduate in Mathematics, Economics, Accountancy, Finance or Industrial Engineering.
• Fresh graduates welcome; at least 6 months to 1 year in merchandise planning/analysis.
• Strong Excel and data reporting abilities; attention to detail required.

Responsibilities

• Assist MPC Senior Analyst in reviewing inventory requirements to prevent shortages at stores.
• Ensure all sales reports are submitted with accuracy and monitor inventory/sales data.
• Prepare monthly performance reports such as Store Sales Quota and Management Performance Sales.
• Coordinate with IS Division to ensure data accuracy in the inventory system and release price events.
• Ensure price events align with approved sale proposals and correct store pricing.
• Help prepare training materials and equipment for department trainings.
• Ensure activities comply with company policies and procedures.

Skills

Excel skills

Quantitative skills

Analytical skills

Verbal/written communication

Decision making

Education

Mathematics

Economics

Accountancy

Finance

Industrial Engineering

Tools

Inventory system

Job description

The Merchandise Analyst (MPC Analyst) shall provide assistance to the MPC Officer and Senior Analyst in monitoring the company’s budget performance/activities, sales and inventory plans in order to achieve the company’s financial objectives.

Duties & Responsibilities

A. Business Analysis

1. Assists the MPC Senior Analyst in reviewing the inventory requirement and proactively prevents shortages at the store locations
2. Ensures that all sales reports are submitted with utmost accuracy
3. Provides assistance to the MPC Senior Analyst in monitoring inventory and sales reports

B. Report Generation

1. Reports actual sales to Finance for commission calculation
2. Prepares performance reports (i.e. Store Sales Quota, Management Performance Sales, etc.) on a monthly basis
3. Assists the MPC Senior Analyst in preparing inventory reports (projected, stock on-hand, outstanding orders and actual purchases) to be submitted to the MPC Officer

C. Technical

1. Assists the MPC Senior Analyst in coordinating with the Information Systems Division to ensure the accuracy of data in the company’s inventory system
2. Releases the price events created by Merchandising in the inventory system
3. Ensures that price events are in accordance with the approved sale proposals
4. Ensures the correctness of the prices that will take effect in the stores

D. Other Responsibilities

1. Assists the MPC Senior Analyst in preparing the training materials and equipment necessary for the trainings conducted by the department
2. Ensures that activities within the department strictly comply with the company’s policies and procedures

Behavioral Competencies

• Has unquestionable credibility and integrity
• Well-organized and detail-oriented
• Able to make timely decisions and anticipate problems
• Action-oriented
• Adapts well to change
• Has good Microsoft Excel skills including word processing applications
• Has good quantitative and analytical skills
• Has good written and verbal communication skills

Minimum Education:

College graduate with a degree in Mathematics / Economics / Accountancy / Finance / Industrial Engineering

Finance or equivalent Minimum Work Experience:

At least 6 months to 1 year of relevant experience in merchandise planning and analysis/ budget allocation.

Fresh graduates are welcome to apply!