Business Intelligence Intern (Spring 2027)

Shopee; Singapore; On-site; SGD 13,000 - 20,000; Full time

Job summary

Shopee in Singapore is offering a Business Intelligence and Data Analytics internship. You will work on SQL data extraction, ad hoc reporting, and automation to support campaigns and insights.

Collaboration with category, business development and marketing teams is encouraged to derive micro-strategies for key initiatives. The role requires pursuing a Bachelor's degree, strong analytical thinking, and interest in e-commerce, with attention to detail and comfort with Excel, Python and SQL.

Qualifications

• Must be enrolled in a Bachelor's Degree.
• Structured and analytical thinker.
• Interest in e-commerce and data-driven decisions.
• Strong planning, organizational skills and attention to detail.
• Familiarity with SQL, Python, and Excel is expected.

Responsibilities

• Utilise SQL to efficiently extract correct data for end-users.
• Draw up and generate ad hoc reports to support various functions and categories.
• Automate reporting code, in a tidy manner.
• Highlight trending or best-priced products in campaigns and collections.
• Perform competitor analyses to ensure competitive advantage is maintained.
• Collaborate with category team to develop insights and derive micro-strategies for key campaigns.
• Collaborate with the wider Business Development and Marketing team for other key initiatives.

Skills

Analytical thinking

Structured mindset

Planning & organizing

E-commerce interest

Attention to detail

Education

Bachelor's Degree

Tools

SQL

Python

Excel

Pivot

VLOOKUP

Job description

Department Business Intelligence and Data AnalyticsLevelInternshipLocationSingaporeThe Business Intelligence and Data Analytics team plays a critical role in conducting close-loop data-driven business iterations. As business intelligence specialists and data analysts, our scope of work is not limited to just performance monitoring and reporting, but also in proactively finding actionable insights to help drive high-impact business changes. Our end-to-end data solution reduces the gap between the business teams and technical teams, and achieves real ‘intelligence’ in the iteration cycle. Browse our Business Intelligence and Data Analytics team openings to see how you can make an impact with us.Job Description:Utilise SQL to efficiently extract correct data for end-usersDraw up and generate ad hoc reports to support various functions and categoriesAutomate reporting code, in a tidy mannerHighlight trending or best-priced products in campaigns and collectionsPerform competitor analyses to ensure competitive advantage is maintainedCollaborate with category team to develop insights and derive micro-strategies for key campaignsCollaborate with the wider Business Development and Marketing team for other key initiativesRequirements:Currently pursuing/enrolled in a Bachelor's DegreeStructured and analytical thinkingPassionate for e-commerceEffective planning and organizational skillsUnderstanding of Excel (Pivot, VLOOKUP), Python and SQLHigh attention to detailFull-time interns strongly preferred (3-6 months)