Data Analyst Applied AI Intern, Buyer & Marketing - Business Intelligence

SHOPEE SINGAPORE PRIVATE LIMITED; Singapore; On-site; SGD 13,000 - 20,000; Part time

Job summary

Shopee Singapore Private Limited is offering an internship in the Business Intelligence and Data Analytics team. You will work with product managers and analysts to translate objectives into analytical tasks, build automated workflows, and validate outputs using SQL and Python.

The role focuses on AI-powered automation and reusable analytics patterns across markets. You will collaborate with regional stakeholders, design test cases, monitor metrics, and contribute to Text-to-SQL and anomaly

Qualifications

• Pursuing a Bachelor's or Master's in a quantitative field (e.g., data science, CS, statistics).
• Strong SQL skills: joins, aggregations, CTEs, window functions; data warehousing concepts.
• Python for automation, scripting, or data processing.
• Familiarity with A/B testing, experimentation methodologies, and statistical significance.
• Interest in e-commerce analytics and domain-specific workflows.
• Interest in LLMs, AI agents, or workflow automation.
• Ability to translate business problems into analytical questions and solutions.
• Comfortable collaborating with cross-functional teams.

Responsibilities

• Partner with product managers and stakeholders to understand objectives and analytical needs.
• Identify recurring tasks that can be automated via AI-powered solutions.
• Translate business rules into reusable agent skills, runbooks, and automated workflows.
• Support metric monitoring and anomaly detection within analytics workflows.
• Build and improve LLM-powered workflows (Text-to-SQL, multi-region analytics).
• Collaborate with regional stakeholders to align market-specific logic and reporting.

Skills

SQL

Python

A/B testing

Statistics

Data analysis

Stakeholder comms

Education

Quantitative degree (Bachelor/Master)

Tools

Claude Code

Text-to-SQL tools

AI development tools

Job description

The 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.

About the Team:

This role is embedded within the Data Analyst team under the Buyer & Marketing Product Line, working alongside analysts who own business metrics and stakeholder relationships. The team leverages data and AI technologies to improve analytical productivity and support business decision-making at scale, building reusable analytics solutions, automating recurring workflows, and enabling faster, more consistent insights across multiple markets. The role sits at the intersection of data analytics, business decision support, and Applied AI — centering on helping analysts and business teams scale analytical workflows through AI-powered automation, reusable data agents, Text-to-SQL systems, and internal productivity tools. Interns will have access to modern AI development tools, including Claude with dedicated usage credits.

Job Description:

• Partner with product managers and business stakeholders to understand business objectives, metric definitions, analytical requirements, and decision-making processes
• Identify recurring analytical tasks and business workflows that can be standardised or automated through AI-powered solutions
• Translate business knowledge — metric definitions, table relationships, calculation logic, and filtering rules — into reusable agent skills, structured runbooks, and automated workflows
• Support metric monitoring and anomaly detection workflows, connecting business risk signals with agent validation logic
• Build and improve LLM-powered analytics workflows for use cases such as Text-to-SQL, A/B testing analysis, and multi-region analytics
• Collaborate with regional stakeholders to understand market-specific business logic, reporting requirements, and metric definitions
• Use SQL, Python, Claude Code, and related AI development tools to build internal productivity tools, skill generators, SQL validators, and evaluation utilities
• Design test cases and validation frameworks to evaluate agent accuracy, consistency, and failure-handling behaviour.
• Investigate failure modes such as schema-linking errors, missing filters, incorrect denominators, empty results, and malformed structured outputs, and improve validation mechanisms accordingly
• Analyse workflow execution logs and traces to improve observability, maintainability, and system reliability
• Document best practices, workflows, and user guides to support adoption across teams and regions

Requirements:

• Currently pursuing a Bachelor's or Master's degree in Business Analytics, Data Science, Computer Science, Information Systems, Statistics, Mathematics, Engineering, or a related quantitative field
• Strong SQL skills, including joins, aggregations, CTEs, window functions, and general data warehouse concepts
• Working knowledge of Python for automation, scripting, or data processing
• Basic understanding of A/B testing, experimentation methodologies, and statistical significance
• Interest in understanding how e-commerce metrics connect to business decisions and willingness to learn domain-specific analytical workflows
• Strong interest in LLM applications, AI agents, workflow automation, or developer productivity tools
• Ability to understand business problems, translate them into analytical questions, and design practical solutions
• Comfortable working with cross-functional stakeholders, including analysts, product managers, engineers, and business teams
• Strong analytical thinking, problem-solving, communication, and documentation skills
• Comfortable using AI coding tools such as Claude Code while reviewing, validating, and maintaining generated outputs