Sr. Executive – Buying & Merchandising

SkillYT; Gurugram District; On-site; INR 600,000 - 1,000,000; Full time

Job summary

SkillYT in India seeks a detail‑oriented Buying & Merchandising analyst to join the team. You will work with Excel, sales and inventory data, and planning trackers to support buying decisions, launches, and notable sales initiatives.

You will track SKU performance, maintain OTB sheets, assist demand forecasting, coordinate with production and supply teams, and prepare dashboards and reports while ensuring data accuracy. This role requires strong numerical skills and experience in retail planning.

Qualifications

• 2–5 years of experience in Buying, Inventory Planning, Merchandising, or Data Analysis.
• Strong proficiency in MS Excel / Advanced Excel.
• Good analytical, reporting, and data interpretation skills.
• Understanding of retail metrics: Sell-through, Stock Cover, ROS, ageing, SKU performance.

Responsibilities

• Support data analysis, reports, and planning inputs for the Buying & Merchandising team.
• Track SKU performance across size, colour, category and other parameters to identify trends.
• Maintain OTB sheets, stock reports, sales contribution reports, and planning trackers.
• Assist with demand forecasting, stock planning, and stock-cover tracking.
• Coordinate with production and supply teams for data follow-ups and execution.
• Maintain PO trackers and monitor dispatch and procurement status.
• Monitor inventory across D2C, retail, marketplace, and QC channels and flag inventory gaps.
• Support sales planning through pre-sale and post-sale analysis.
• Execute website merchandising and discounting updates while ensuring listing accuracy.
• Track slow-moving and ageing inventory and support liquidation analysis.
• Prepare weekly/monthly dashboards and reports while ensuring data accuracy.
• Coordinate with Sales, Supply Chain, Inventory, Production, Brand, and Marketing teams for timely updates and execution.
• Maintain accurate SKU-level data and ensure timely flow of information across teams.

Skills

Advanced Excel

Data analysis

Merchandising data

Inventory planning

Cross-functional collaboration

Tools

Excel

Job description

About The Role

We are looking for a detail-oriented and analytical professional to join the Buying & Merchandising team. The role involves working extensively with Excel, sales and inventory data, planning trackers, and cross-functional teams to support buying decisions, inventory planning, replenishment, launches, and sales initiatives.

The ideal candidate should be comfortable working with numbers and large datasets, have strong Excel and analytical skills, and possess an understanding of retail/e-commerce planning and inventory metrics.

Key Responsibilities

• Support the Buying & Merchandising team with data analysis, reports, and planning inputs.
• Track SKU performance across size, colour, category, and other parameters to identify trends.
• Maintain OTB sheets, stock reports, sales contribution reports, and planning trackers.
• Assist with demand forecasting, stock planning, and stock-cover tracking.
• Coordinate with production and supply teams for data follow-ups and execution.
• Maintain PO trackers and monitor dispatch and procurement status.
• Monitor inventory across D2C, retail, marketplace, and QC channels and flag inventory gaps.
• Support sales planning through pre-sale and post-sale analysis.
• Execute website merchandising and discounting updates while ensuring listing accuracy.
• Track slow-moving and ageing inventory and support liquidation analysis.
• Prepare weekly/monthly dashboards and reports while ensuring data accuracy.
• Coordinate with Sales, Supply Chain, Inventory, Production, Brand, and Marketing teams for timely updates and execution.
• Maintain accurate SKU-level data and ensure timely flow of information across teams.

Required Skills & Qualifications

• 2–5 years of experience in Buying, Inventory Planning, Merchandising, or Data Analysis.
• Strong proficiency in MS Excel / Advanced Excel.
• Good analytical, reporting, and data interpretation skills.
• Understanding of retail metrics such as:
  • Sell-through
  • Stock Cover
  • ROS (Rate of Sale)
  • Inventory ageing
  • SKU performance
• Basic understanding of assortment planning, demand forecasting, inventory management, and SKU management.
• Experience in e-commerce, retail, or D2C brands preferred.
• Experience with apparel/innerwear or consumer brands will be an advantage.
• Strong coordination and follow-up skills.
• Ability to work effectively with cross-functional teams.

Ideal Candidate

• Detail-oriented and highly organized.
• Strong with numbers and data.
• Comfortable working on Excel-based trackers and reports.
• Able to identify trends and translate data into actionable insights.
• Proactive in following up with multiple stakeholders.
• Comfortable working in a fast-paced, cross-functional environment.

Skills: buying & merchandising,inventory management,buying planning