Merchandising Data Analyst

SATURDAYS; Jakarta Selatan; Hybrid; IDR 18,000,000 - 36,000,000; Full time

Job summary

SATURDAYS in Jakarta Selatan seeks a Merchandising Data Analyst who turns merchandising and sales data into actionable insights to support assortment, pricing, and promotions.

You will gather and clean data from multiple sources, build dashboards in Excel/Google Sheets, analyze product performance, monitor campaigns, and collaborate with merchandising, marketing, and operations to optimize margins and customer experience.

Qualifications

• Bachelor's degree in a quantitative field or equivalent practical experience.
• Strong data analysis skills in retail/e-commerce context a strong plus.
• Ability to translate data into insights for non-technical, cross-functional teams.

Responsibilities

• Collect, clean, and consolidate sales, inventory, and merchandising data from multiple sources
• Build and maintain reports, trackers, and dashboards using Excel/Google Sheets
• Analyze product performance, sell-through, stock levels, and pricing trends
• Monitor promotional and campaign performance; provide data-backed recommendations
• Support demand forecasting and replenishment planning based on historical sales
• Identify patterns in customer behavior and product performance to inform assortment planning
• Prepare clear, digestible reports and presentations for cross-functional stakeholders
• Assist in performance reviews of new product collections and sales channels
• Support test-and-learn initiatives with structured data analysis

Skills

Analytical mindset

Excel / Google Sheets

Clear communication

English proficiency

Education

Bachelor's degree in a quantitative field

Tools

Google Looker Studio

Job description

About the Role

The Merchandising Data Analyst at SATURDAYS is responsible for turning merchandising and sales data into clear, actionable insights that support assortment, pricing, and promotional decisions.

Day-to-day, this person gathers and cleans data from multiple sources, builds and maintains spreadsheet-based reports and dashboards, and conducts detailed sales and inventory analyses to uncover trends in product performance and customer behavior. The role works closely with merchandising, marketing, and operations teams to recommend actions that optimize product mix, improve margins, and enhance the overall customer experience, while also supporting forecasting, test‑and‑learn initiatives, and performance reviews of new collections and sales channels.

Key Responsibilities

• Collect, clean, and consolidate sales, inventory, and merchandising data from multiple sources (POS, e-commerce platforms, internal systems)
• Build and maintain reports, trackers, and dashboards primarily using Excel/Google Sheets (advanced formulas, pivot tables, lookup functions, etc.)
• Analyze product performance, sell-through rates, stock levels, and pricing trends to support assortment and inventory decisions
• Monitor promotional and campaign performance, providing data‑backed recommendations to merchandising and marketing teams
• Support demand forecasting and replenishment planning based on historical sales trends
• Identify patterns in customer behavior and product performance to inform assortment planning
• Prepare clear, digestible reports and presentations for cross‑functional stakeholders
• Assist in performance reviews of new product collections and sales channels
• Support test‑and‑learn initiatives (e.g., pricing tests, promo mechanics, new product launches) with structured data analysis

Qualifications

• Strong analytical mindset with hands‑on experience in data analysis (retail, e‑commerce, or merchandising context is a strong plus)
• Strong proficiency in Excel/Google Sheets is required : comfortable working with formulas (VLOOKUP/XLOOKUP, INDEX‑MATCH, pivot tables, conditional logic, array formulas, etc.) to build and maintain reports.
• Experience organizing and analyzing large, messy datasets into clean, usable formats
• Clear communication skills, with the ability to translate data into insights for non‑technical, cross‑functional teams (merchandising, marketing, operations)
• Familiarity with BI/visualization tools such as Google Looker Studio (Data Studio) is a plus;
• Bachelor's degree in a quantitative field (e.g., Engineer, Statistics, Mathematics, Economics, Business, Data Science) or equivalent practical experience
• Ability to manage multiple priorities and deadlines
• High attention to detail, curiosity about customer and sales behavior, and a data‑driven approach to problem‑solving
  Merchandising / Business Analytics Reports to: Head of Merchandising / Merchandising Manager

Nice to Have

• Prior experience in a merchandising, retail buying, or category management role
• Proficiency in English