Category Intern - Luxury/Lifestyle
Tata CLiQ Fashion · Mumbai, Maharashtra, India
Apply & track with Apply EdgeJob Description
Category Intern - Luxury/Lifestyle
The role will involve working closely with the Category team to analyze pricing, assortment, customer behavior, brand performance, seasonal demand patterns, and portfolio opportunities, and translate insights into actionable business recommendations.What You’ll Do
- Support data preparation by reviewing the project roadmap, requesting required dataset access, documenting data quality issues, and creating a data dictionary.
- Set up Excel-based analysis models, conduct exploratory analysis, and draft analytical frameworks for business problem-solving.
- Analyze pricing and demand economics across menswear and kidswear categories, including apparel, footwear, and fashion accessories.
- Evaluate discount effectiveness across price bands and promotion levels, including revenue-volume trade-offs and optimal pricing points.
- Build category-level pricing recommendation matrices basis product type, brand positioning, price band, and customer response.
- Segment customers basis purchase frequency, basket size, AOV, repeat purchase behavior, and premium/luxury buying maturity.
- Evaluate Customer Lifetime Value, acquisition versus retention economics, repeat purchase trends, and high-value customer segment opportunities.
- Analyze brand and product performance across revenue, margin, units sold, contribution margin, inventory movement, and customer demand.
- Identify high margin versus high-volume products across categories like menswear, kidswear, apparel, footwear, accessories.
- Study cross-selling patterns, basket composition, product affinity, and products frequently bought together within menswear and kidswear baskets.
- Build a brand portfolio matrix to classify brands/products as Stars, Cash Cows, Question Marks, or Dogs.
- Analyze seasonal and occasion-led demand patterns across Diwali, New Year, weddings, summer holidays, back-to-school, gifting, and festive periods.
- Conduct geographic analysis across metros, Tier 1 and Tier 2 cities to identify regional pricing, assortment, and demand opportunities.
- Create visualizations, executive summaries, data models, recommendation frameworks, and implementation-ready business outputs.Project Expected DeliverablesProject 1: Pricing & Demand Economics Price elasticity, discount sensitivity, and pricing recommendation reports.Project 2: Customer Segmentation & Lifetime Value Customer segmentation, CLV, CAC versus retention economics, and retention strategy report. Project 3: Product & Brand Portfolio Strategy Brand portfolio matrix, margin analysis, product mix, cross-selling patterns, and portfolio optimization report. Project 4: Seasonal & Geographic Demand Patterns Occasion-led demand analysis, seasonal forecast, and regional assortment strategy recommendations. Overall Output Expected
- Four project analysis reports with actionable business recommendations.
- One integrated strategic roadmap for Luxury/Lifestyle
- Executive-ready presentation deck.
- Implementation playbook with prioritized actions, including quick wins and long-term initiatives.
- Reusable data models, templates, and analysis frameworks.Eligibility
- Strong analytical, problem-solving, and structured thinking skills.
- Proficiency in Microsoft Excel is required; knowledge of Power BI, SQL, Tableau, or Python will be an added advantage.
- Prior internship experience in e-commerce, retail, fashion, luxury, category management, or analytics will be preferred.
- Ability to work with large datasets and convert analysis into clear business insights and recommendations