Retail Business Data Analyst

PT BUSANA AKTIF MANDIRI; Jakarta Pusat; On-site; IDR 120,000,000 - 240,000,000; Full time

Job summary

PT. Busana Aktif Mandiri is seeking a data-savvy Analyst to join its retail analytics team.

You will analyze sales trends, inventory flow, and store performance across online and offline channels to uncover opportunities and drive profitability. Collaborate with Marketing, Merchandising, and Operations to build dashboards in Power BI or Tableau, translate data into actionable recommendations, and support strategic planning.

Qualifications

• Bachelor's degree or equivalent in a quantitative field.
• 2–3 years of experience in data/Business analytics in retail, fashion, FMCG, or consumer goods.
• Strong Excel/Sheets skills (Pivot Tables, VLOOKUP/XLOOKUP,SUMIFS, COUNTIFS).
• Experienced with data visualization tools (Power BI/Tableau/Looker Studio).
• Knowledge of SQL is an advantage.
• Familiar with key retail metrics (Sales Growth, GM, ATV, UPT).
• Excellent analytical thinking, problem solving, and communication.

Responsibilities

• Analyze and evaluate overall retail business performance across stores and online channels.
• Identify sales opportunities and performance issues from sales data and market trends.
• Conduct product performance analysis by category, SKU, size, color, and seasonality.
• Monitor inventory performance and provide data-driven recommendations for optimization.
• Evaluate store performance using metrics: sales growth, ATV, UPT, sell-through, gross margin.
• Assess marketing campaigns and promotions impact on revenue and transactions.
• Develop forecasts, demand projections, and support inventory planning.
• Build and maintain dashboards and reports for management insight.
• Translate data into actionable business recommendations for management.
• Collaborate with Retail, Sales, Marketing, Merchandising, Marketplace, and Operations.

Skills

Excel

Power BI

SQL

Data analysis

Retail analytics

Education

Bachelor's degree in Statistics, Mathematics, Information Systems, Industrial Engineering, Management, Economics

Tools

Power BI

Tableau

Looker Studio

Job description

PT. Busana Aktif Mandiri is an established garment and fashion company with a strong heritage dating back to 1982. Through its brands Leevierra Active (@leevierraactive) and Leevierra Kids (@leevierrakids), the company specializes in high-quality sportswear, activewear, and swimwear designed to combine comfort, functionality, and style.

With decades of experience in the apparel industry, Leevierra continues to grow and innovate by delivering quality products that meet the evolving needs of modern consumers. We are committed to maintaining high product standards, embracing market trends, and expanding our presence in the fashion and activewear industry

Job Description / Responsibilities :

• Analyze and evaluate overall retail business performance by monitoring sales trends, revenue growth, product performance, and sales contribution across retail stores and online channels.
• Identify sales opportunities, business gaps, and performance issues through in-depth analysis of sales data, customer purchasing patterns, and market trends.
• Conduct product performance analysis to identify best-selling, slow-moving, and underperforming products based on category, SKU, size, color, and seasonal demand.
• Monitor inventory performance, stock turnover, product availability, and stock distribution to identify overstock and stock shortages, while providing data-driven recommendations for inventory optimization.
• Evaluate retail store performance using key business metrics, including sales growth, average transaction value (ATV), units per transaction (UPT), sell-through rate, and gross margin.
• Analyze the effectiveness of marketing campaigns, promotions, and sales strategies to measure their impact on revenue, transactions, and business growth.
• Develop sales forecasts, demand projections, and business performance analysis to support inventory planning, product allocation, and future business strategies.
• Build and maintain interactive dashboards, analytical reports, and business performance presentations to provide accurate and actionable insights for management.
• Translate complex data into clear business insights and strategic recommendations to improve sales performance, operational efficiency, and profitability.
• Collaborate with Retail, Sales, Marketing, Merchandising, Marketplace, and Operations teams to identify business challenges and support data-driven decision-making across the company.

Requirements / Qualifications :

• Bachelor's degree (S1) in Statistics, Mathematics, Information Systems, Industrial Engineering, Management, Economics, or other relevant fields.
• Minimum 2–3 years of experience as a Data Analyst, Business Analyst, Sales Analyst, or in a similar role, preferably within the retail, fashion, FMCG, or consumer goods industries.
• Proficient in Microsoft Excel or Google Sheets, including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, and other data processing formulas.
• Skilled in data visualization tools such as Microsoft Power BI, Tableau, or Looker Studio.
• Strong understanding of sales analysis, inventory management, product performance, and retail business operations.
• Experienced in data cleaning, data validation, data processing, and database analysis. Knowledge of SQL is an advantage.
• Familiar with key retail performance metrics, including Sales Growth, Sell-Through Rate, Inventory Turnover, Average Transaction Value (ATV), Units per Transaction (UPT), and Gross Margin.
• Strong analytical thinking and problem-solving skills, with the ability to translate data into actionable business insights and recommendations.
• Detail-oriented, communicative, proactive, and able to work independently as well as collaboratively within a team.

Unlock job insights

Hirer responsiveness Salary match Number of applicants