Merchandiser Planning Analyst

PT Ramayana Lestari Sentosa Tbk; Jakarta Pusat; On-site; IDR 492.368.000 - 820.614.000; Full time

Job summary

A leading retail company in Indonesia is looking for a Merchandising Planning Analyst to optimize product assortment and inventory. In this role, you will leverage data analysis to develop strategic merchandising plans and collaborate with cross-functional teams. The ideal candidate holds a Bachelor's degree in a related field and possesses 3–5 years of experience in data analysis or merchandising. Proficiency in Excel and SQL is essential, along with strong communication skills.

Qualifications

• 3–5 years of experience in Data Analysis, Business Intelligence, or Merchandising Planning.
• Familiar with machine learning or AI is a plus.
• Basic leadership skills.

Responsibilities

• Collect, clean, and analyze sales, inventory, and market trend data.
• Develop data-driven merchandising plans including pricing strategy.
• Build and maintain dashboards for management decision-making.

Skills

Data analysis

Communication skills

Critical thinking

Attention to detail

Education

Bachelor’s degree in IT, Mathematics, Statistics, or related field

Tools

Microsoft Excel

SQL

Power BI

Tableau

Job description

About the role

As a Merchandising Planning Analyst at PT Ramayana Lestari Sentosa Tbk, you will play a crucial role in the company's retail and consumer product planning. You will be responsible for analysing data and developing strategies to optimise our product assortment and inventory, ensuring we meet the evolving needs of our customers.

Key Responsibilities

• Collect, clean, and analyze sales, inventory, and market trend data using Excel, SQL, and BI tools.
• Develop data-driven merchandising plans (assortment planning, pricing strategy, promotion effectiveness).
• Build and maintain dashboards and regular reports to support management decision-making.
• Collaborate with marketing, buying, and supply chain teams to ensure plans align with company targets.
• Perform root cause analysis to investigate anomalies in sales or inventory data.
• Present insights and recommendations to management and stakeholders in a clear and actionable way.
• Propose initiatives for automation and digitalization of data analysis using scripts or AI technology.

Requirements

• Bachelor’s degree from a reputable university in IT, Mathematics, Statistics, or a related field.
• 3–5 years of experience in Data Analysis, Business Intelligence, or Merchandising Planning.
• Proficient in Microsoft Excel (pivot tables, complex formulas) and SQL.
• Familiar with Power BI, Tableau, or other BI tools (knowledge of machine learning/AI is a plus).
• Strong communication skills with the ability to deliver insights to management effectively.
• Basic leadership skills
• Highly detail-oriented, critical thinker, and able to work under tight deadlines.

About us

PT Ramayana Lestari Sentosa Tbk' is a leading retail company in Indonesia, operating a network of department stores and supermarkets across the country. With a strong focus on providing quality products and exceptional customer service, we have built a reputation for being a trusted and reliable brand. Our commitment to sustainability and corporate social responsibility is at the heart of our business, and we are proud to be a part of the communities we serve.