Job Description

1. Data Collection & Management

• Extract and consolidate sales, traffic, and customer data from Shopee, Lazada, Instagram, Facebook, Xiaohongshu (RED), and ad platforms.
• Build and maintain dashboards (Excel, Google Data Studio, Power BI) to track key metrics.
• Ensure data accuracy, integrity, and timely updates.

2. Performance Analysis & Insights

• Analyze conversion rate, average order value, repeat purchase rate, and campaign ROI/ROAS.
• Identify best-performing SKUs, seasonal trends, and growth opportunities.
• Conduct competitor benchmarking (pricing, sales, ad strategies).
• Generate actionable insights to improve ad targeting, content strategy, and product positioning.

3. Social Media & Marketing Data Tracking

• Monitor follower growth, engagement rate, and content effectiveness across social media platforms.
• Evaluate KOL/KOC collaborations and influencer campaign performance.
• Summarize consumer feedback to build customer personas and highlight buying motivations.

4. Reporting & Business Support

• Deliver weekly and monthly performance reports with clear visuals and recommendations.
• Support marketing, e-commerce, and product teams with data-driven decision making.
• Provide insights for pricing, promotion planning, and inventory strategy.

5. Tools & Skills

• Proficient in Excel/Google Sheets (pivot tables, advanced formulas, charts).
• Skilled in Google Data Studio, Power BI, or Tableau for visualization.
• Familiar with Shopee & Lazada Seller Center, Meta Ads Manager.
• Bonus: Basic SQL or Python for deeper analysis.

Key KPIs

• Accuracy and timeliness of reports (>95%).
• Improvement in campaign ROI/ROAS (target % set by management).
• Number of actionable insights that drive revenue growth.
• Success rate of trend/sku predictions.

Job Requirements

Education & Experience

• Bachelor’s degree in Business, Marketing, Statistics, Data Science, Economics or related field.
• 2–3 years of working experience in e-commerce analytics, digital marketing analysis, or performance reporting (fresh graduates with strong analytical skills will also be considered).
• Experience with Shopee / Lazada Seller Center and social media analytics tools is a strong advantage.

Technical Skills

• Strong proficiency in Excel / Google Sheets (pivot tables, VLOOKUP, data cleaning, charting).
• Skilled in Google Data Studio, Power BI, or Tableau for dashboard creation.
• Familiarity with Meta Ads Manager, TikTok Ads, and Google Analytics.
• Basic knowledge of SQL or Python is a plus.

Analytical & Business Skills

• Strong ability to translate data into business insights and actionable strategies.
• Good understanding of e-commerce KPIs (conversion, AOV, repeat purchase, ROAS, CTR, etc.).
• Familiar with consumer trends, online shopping behavior, and digital campaign performance tracking.
• Detail-oriented with the ability to manage large sets of data accurately.

Soft Skills

• Strong problem-solving mindset and business curiosity.
• Able to work independently and communicate insights clearly to non-technical teams.
• Good time management and ability to prioritize multiple tasks.
• Team player with a growth mindset.

Language

• Proficiency in English (spoken & written).
• Mandarin is an added advantage for analyzing Xiaohongshu (RED) data and dealing with Chinese-speaking audiences.

Skills