Data Analytics Intern
Job Summary
The Data Analytics Intern will be responsible for consolidating performance data from various e-commerce and advertising platforms into unified reporting formats. They will maintain accurate dashboards tracking sales, traffic, and marketing metrics to support team decision-making. Additionally, the role involves assisting with product listings and optimizing them for better conversion rates.
Responsibilities
- Consolidate multi-platform data
- Maintain performance dashboards
- Report key marketing metrics
- Optimize product listings
Required Skills
- Excel/Google Sheets (Pivot, VLOOKUP)
- Data analysis & reporting
- E-commerce & digital marketing knowledge
- Problem-solving & attention to detail
Job Details
Responsibilities:
- Consolidate data from TikTok Shop, Shopify, Shopee, Facebook Ads, Google Ads and other platforms into a consistent reporting format.
- Maintain accurate dashboards for sales, traffic, ads performance and product performance.
- Compile performance marketing data and summarise key metrics such as ROAS, CAC, CTR, CPA and repeat rate.
- Assist in generating weekly performance summaries for internal meetings.
- Upload and maintain product listings on Shopify and other platforms.
- Assist in optimising product listings for better conversion rate.
- Pull daily campaign results and compute into readable formats.
- Assist in ad hoc reporting or data cleaning tasks when needed.
- Maintain organised documentation for all reports and sheets.
Requirements:
- Currently pursuing or recently completed a degree/diploma in Business, Analytics, Marketing, Statistics or related field.
- Comfortable with Excel or Google Sheets (pivot tables, formulas such as VLOOKUP, SUMIF, COUNTIF).
- Basic understanding of ecommerce platforms and digital marketing metrics is a plus.
- Strong attention to detail and accuracy.
- Able to work fast, independently and follow structured reporting SOPs.
- Proactive, hardworking and passionate about data.
- Strong problem-solving ability and ownership mindset.