Portfolio Management Intern  

About this Position

We are looking for a Portfolio Management Intern who will support the team in curating a strong product assortment by conducting product data collection, desk research, and SKU curation across multiple categories. This role requires strong attention to detail, structured thinking, and an up-to-date sense of market trends and brands.

Job Description

As our Astronaut, your missions are:

• Data Collection & Manual Product Scraping: Collect and compile product information manually from various sources, primarily e-commerce platforms (e.g., product name, brand, price, historical sales, promotions, and categorization)
• Desk Research & Market Benchmarking: Conduct desk research to understand the customer needs, key brands, and market trends to help ensure the assortment is competitive and relevant.
• SKU & Assortment Curation: Assist in curating the right products and brands across categories based on Astro’s needs, using criteria such as sales performance, brand positioning, and customer relevance.
• Data Cleaning, Structuring & Reporting: Organize, clean, and summarize data in Google Sheets, producing clear outputs (e.g., recommended SKU lists, competitor benchmarks, category insights) to support decision-making.

In order to launch the missions successfully, you need to have:

• Fresh graduate or final-year undergraduate student from any major
• Proficient in Microsoft Excel and/or Google Sheets, including filters, pivot tables, and basic formulas (e.g., Vlookup/Xlookup)
• Strong awareness of product trends and brands, particularly within the e-commerce ecosystem
• Structured, logical, and detail-oriented with strong data accuracy
• Good written and verbal communication skills
• Proactive mindset, eager to learn, takes initiative, and able to work independently