Data Analyst / Business Analyst Intern

We are seeking a highly analytical and tech-savvy professional to leverage AI tools and data analytics to generate actionable insights from retail sales and customer data. The ideal candidate will analyse retail clients, product performance, inventory trends, and customer behavior to drive strategic decisions across merchandising, marketing, and operations.

⸻

🎯 Key Responsibilities

1️⃣ Retail Sales & Product Analysis

• Analyse sell-through rates, margins, product mix, category performance

• Identify bestsellers, slow movers, and seasonal trends

• Study store-wise and region-wise performance

• Recommend assortment optimization strategies

2️⃣ Customer & Client Analysis

• Perform RFM analysis (Recency, Frequency, Monetary value)

• Segment customers based on purchase behavior

• Analyse repeat purchase rates and lifetime value (LTV)

• Identify VIP / high-value clients

• Study cross-selling and bundling opportunities

3️⃣ AI-Driven Insights

• Use AI tools (ChatGPT, Claude, Power BI Copilot, etc.) to process large datasets

• Build predictive models (demand forecasting, churn prediction, etc.)

• Create dashboards and automated reporting systems

• Identify hidden patterns and business opportunities

4️⃣ Inventory & Buying Insights

• Recommend optimal stock levels

• Forecast demand

• Identify overstock and understock risks

• Suggest pricing or discount strategies

5️⃣ Strategic Reporting

• Present insights to leadership in clear visual dashboards

• Translate data into actionable retail strategies

• Support merchandising, marketing, and CRM teams

⸻

🧠 Required Skills

Technical

• Strong Excel (Advanced formulas, pivot tables)

• Power BI / Tableau

• SQL (preferred)

• Experience using AI tools for business analysis

• Basic Python (bonus, not mandatory)

Analytical

• Strong statistical understanding

• Retail KPI knowledge (sell-through %, ASP, GMROI, etc.)

• Ability to work with large datasets

Domain Knowledge (Very Important)

• Retail or fashion/jewellery industry experience preferred

• Understanding of merchandising & inventory cycles

• Knowledge of CRM systems

⸻

🎓 Qualifications

• Bachelor’s/Master’s in Business Analytics, Data Science, Statistics, Economics, or related field

• 3–7 years in retail analytics or business intelligence

📊 KPIs for This Role

• Improvement in sell-through rates

• Reduction in dead stock

• Increase in repeat purchase rate

• Improved inventory turnover

• Actionable insights adopted by business

• It is a Full Time IT / Software / Data Analyst job for candidates with 3 - 6+ years Experience.