Assistant Manager, Retail Analyst

adidas; Selangor; On-site; MYR 40,000 - 60,000; Full time

Job summary

A leading sportswear brand in Selangor, Malaysia, seeks a Retail Analyst to enhance retail performance through data insights. The role involves building and maintaining dashboards using Power BI, analyzing sales and stock performance, and collaborating cross-functionally to support insights-driven decisions. Ideal candidates should have a degree in Business or Analytics, with strong skills in Power BI and an understanding of retail KPIs. This position welcomes fresh graduates with proficiency in data analytics.

Qualifications

• 0–4 years of experience in retail analytics, commercial analysis, or data analytics roles.
• Strong understanding of fashion retail fundamentals and retail math.
• Ability to interpret store data and translate it into commercial insights.

Responsibilities

• Support Retail and Franchise performance by transforming data into insights.
• Build, enhance, and maintain retail dashboards using Power BI.
• Analyse store performance and retail KPIs using retail formulas.

Skills

Power BI

Retail analytics

Data visualization

Analytical thinking

Communication

Education

Degree in Business, Data Analytics, Economics, or related fields

Tools

Advanced Excel

SQL

Python/R

Job description

Purpose & Overall Relevance for the Organization

The Retail Analyst supports Retail and Franchise performance by transforming data into clear insights that improve commercial outcomes, operational efficiency, and product productivity.

Overview

The role is responsible for building dashboards, managing retail datasets, and analysing store results across sales, KPIs, stock health, and product performance, enabling teams to make faster and more informed decisions.

Key Responsibilities

• Retail Reporting & Dashboard Management
  • Build, enhance, and maintain retail dashboards using Power BI covering sales, traffic, conversion, UPT, ATV, stock availability, sell-through, and shrinkage.
  • Ensure reporting accuracy and alignment across Retail, Merchandising, and Finance teams.
  • Prepare regular and ad-hoc reports for business reviews and leadership meetings.
• Store & KPI Analysis
  • Analyse store performance and retail KPIs using retail formulas (e.g., sell-through %, WOS, SPH, conversion).
  • Evaluate product mix efficiency, category contribution, and merchandising ratios to support buying and allocation decisions.Provide insights on staffing productivity, store format differences, and operational execution indicators.
• Product, Stock & Merchandising Analytics
  • Track product performance by category, gender, concept, and franchise level.
  • Support Merchandising with data on size curves, top sellers, ageing inventory, replenishment needs, and size depth analysis.
  • Analyse inline and seasonal performance to support OTB discussions and assortment planning inputs (without owning OTB).
• Data Modelling & BI Development
  • Build data models and queries to support scalable reporting in Power BI.
  • Collaborate with IT/Data teams to improve data pipelines, database integrity, and automation.
  • Maintain clean and consistent datasets, ensuring reliable foundations for all reporting.
• Cross-Functional Support & Collaboration
  • Partner with Retail Ops, Merchandising, VM, Finance, and eCommerce to align on insights and ensure data-driven execution.
  • Provide analytical support for retail initiatives, productivity improvement workstreams, and store performance deep dives.
  • Support leadership presentations and business narratives with clear, visual data storytelling.

Key Relationships

Internal: Retail Operations, Buying, Data & Analysis Teams, & Finance

Knowledge, Skills & Abilities

Technical Skills

• Proficiency in Power BI (DAX, data modelling, dashboard design).
• Advanced Excel; familiarity with SQL, Advanced Python / R + libraries & Vega / Vega‑Lite is advantageous.
• Strong data cleaning, structuring, and visualization capability.

Retail Knowledge

• Solid understanding of fashion retail fundamentals and retail math:
  • Sell-through, WOS, productivity metrics
  • Buying & merch ratios (gender/category splits, A/B/C classifications, size curves, price points)
  • Conversion KPIs, operational KPIs, product lifecycle
• Ability to interpret store data and translate it into commercial insights.

Core Competencies

• High attention to detail and accuracy.
• Strong analytical thinking and ability to simplify complex data.
• Good communication and collaboration skills.
• Organized; able to manage multiple datasets and reporting deadlines.
• Curious, proactive, and eager to learn retail systems and processes.

Requisite Education & Experience / Minimum Qualifications

• 0–4 years of experience in retail analytics, commercial analysis, or data analytics roles.
• Fresh graduates with strong Power BI skills and understanding of retail KPIs are welcome.
• Degree in Business, Data Analytics, Economics, Statistics, Computer Science, or related fields.
• Experience in fashion, sporting goods, or FMCG retail is an advantage.