Category Analyst - Retail Apparel

Q2 HR Solutions; Pasig; On-site; PHP 446,400 - 725,400; Full time

Job summary

Q2 HR Solutions is seeking a Category Analyst in Pasig, Metro Manila, to support sales target planning, data analysis, and inventory management for our children's and maternity fashion lines. You will analyze trends, plan demand for new collections, and conduct competitor checks to drive category performance.

The role requires a Bachelor's degree in a related field, strong analytical skills, and proficiency in Excel and data visualization tools.

Qualifications

• Bachelor’s degree in Business, Retail Management, Marketing, Accountancy, Analytics, Economics, Statistics, Mathematics or related field.
• Strong analytical skills with the ability to interpret data and draw actionable insights.
• Proficiency in data analysis tools and software (e.g., Microsoft Excel, data visualization tools).
• Deep understanding of Retail Apparel and Fashion industry, market trends, and consumer behavior.
• Attention to detail for accurate data analysis and informed decisions.
• Ability to identify problems and develop creative solutions to improve category performance.
• Strong organizational and time management skills to handle multiple tasks and deadlines.

Responsibilities

• Assist in setting monthly sales targets based on historical sales trends per month per class category and store performance.
• Monitor sell-through of all collections launched.
• Generate monthly sales reports for assigned categories.
• Collaborate in proposed collection budgets based on historical sales trends.
• Assist in planning upcoming collection demand by analyzing class type, sub-class types, sizes, fabric, color, and design/styles.
• Support in proposing store budgets aligned with total demand planned for upcoming collections.
• Assist in allocating inventory to stores and online platforms based on targets.
• Analyze monthly inventory and three-month average sales to identify Months to Sell (MTS).
• Identify and consolidate low/broken on-hand quantities per style in all stores to the store with highest sales demand.
• Conduct regular competitor checks through online research and physical store visits.

Skills

Analytical skills

Data interpretation

Microsoft Excel

Data visualization

Retail apparel knowledge

Education

Business

Retail Management

Marketing

Accountancy

Analytics

Economics

Statistics

Mathematics

Tools

Data visualization tools

Job description

Company Overview: A premier children's and maternity fashion brand renowned for its stylish, high-quality, and age-appropriate apparel.

Job Description of Category Analyst

The Category Analyst is crucial in supporting the planning and execution of sales targets, analyzing sales data, coordinating demand planning for new collections, managing inventory effectively, and conducting competitor checks.

What you’ll do:

1. Target Setting:

• Assist in setting monthly sales targets based on historical sales trends per month per class category and store performance.
• Monitor sell-through of all collections launched.
• Generate monthly sales reports for assigned categories.

3. Demand Planning and Execution for New Collections:

• Collaborate in proposing collection budgets based on historical sales trends.
• Assist in planning upcoming collection demand by analyzing class type, sub-class types, sizes, fabric, color, and design/styles.
• Support in proposing store budgets aligned with the total demand planned for upcoming collections.
• Assist in allocating inventory to stores and online platforms based on targets.

4. Inventory Management:

• Analyze monthly inventory and three-month average sales to identify Months to Sell (MTS).
• Identify and consolidate low and broken on-hand quantities per style in all stores to the store with the highest sales demand.

5. Competitors Check:

• Conduct regular competitor checks through online research and physical store visits.

What we are looking for:

• Bachelor's degree in Business, Retail Management, Marketing, Accountancy, Analytics, Economics, Statistics, Mathematics or a related field.
• Strong analytical skills with the ability to interpret data and draw actionable insights.
• Proficiency in data analysis tools and software (e.g., Microsoft Excel, data visualization tools.
• A deep understanding of the Retail Apparel and Fashion industry, including market trends, consumer behavior, and competitive dynamics.
• Attention to detail is critical for accurately analyzing data and making informed decisions.
• The ability to identify problems and develop creative solutions to improve category performance.
• Strong organizational and time management skills to handle multiple tasks and meet deadlines.