Job Description
POSTED ON BEHALF CLIENT:
Support the collection, validation and analysis of e-commerce data to provide clearer visibility into shop, product, advertising and campaign performance across Shopee, Lazada and TikTok Shop.
Job Responsibilities
· Collect, consolidate and organise e-commerce data from Shopee, Lazada, TikTok Shop, BigSeller and approved internal sources.
· Clean and validate data by identifying missing information, duplicate records, inconsistent formats and abnormal figures.
· Maintain structured datasets covering shops, products, orders, traffic, advertising, campaigns, cancellations, returns and refunds.
· Reconcile figures across marketplace reports and investigate inconsistencies with relevant team members.
· Analyse shop and product performance using sales, GMV, orders, AOV, traffic, conversion, cancellation and refund metrics.
· Identify growing or declining shops, strong or weak products and unusual performance trends.
· Support advertising and campaign analysis, including spend, attributed sales, ROAS, traffic, conversion and promotional results.
· Prepare weekly and monthly reports, scorecards or dashboards highlighting key findings and matters requiring management attention.
· Maintain action trackers and compare performance before and after approved improvement activities.
· Document data sources, metric definitions, calculation methods and reporting procedures.
· Present preliminary findings to the designated supervisor or management for review.
Candidate Requirements
· Currently pursuing a Bachelor’s Degree in Business Analytics, Data Analytics, Data Science, Information Systems, Business Information Systems, Applied Statistics or a closely related analytical field.
· Able to commit to a full 6-month internship.
· Final-year students are preferred.
· Proficient in Microsoft Excel or Google Sheets, including formulas, PivotTables and charts.
· Basic understanding of data cleaning, validation and performance analysis.
· Strong attention to detail and comfortable working with large datasets.
· Able to identify trends and communicate findings clearly.
· Able to maintain confidentiality when handling company, customer and financial information.
Added Advantage: Power Query, Power BI, SQL, Python or exposure to e-commerce marketplace data.
Please submit:
· Updated resume
· Latest academic transcript
· University internship / industrial-training letter
· Confirmed internship start and end dates
· Relevant academic project or portfolio, if available
Application Email: careers@dsplastic.my
Email Subject: Application – Data Analyst Intern (E-Commerce)
Shortlisted applicants may be required to complete a short practical assessment.