CB- Category Strategy Data Analyst

Job Description

We are looking for a highly analytical and detail-oriented Category Data & Performance Analyst to support data-driven decision-making within the Business Development team.

This role focuses on building scalable reporting, performing deep-dive performance analysis, and generating actionable insights to support category growth initiatives. The ideal candidate has strong SQL, Excel, and analytical problem-solving skills, and is comfortable working with large datasets to identify business opportunities and performance gaps.

This is an individual contributor role with strong exposure to commercial strategy, category management, and cross-functional stakeholders.

Key Responsibilities

• Data Analysis & Performance Monitoring

Analyze category performance metrics including GMV, orders, traffic, conversion, margin, and campaign performance

Identify SKU-level, seller-level, and category-level performance trends and opportunities

Conduct deep-dive analysis to diagnose performance fluctuations and uncover growth opportunities

Support weekly/monthly business performance reviews and reporting

• Data Infrastructure & Reporting

Build and maintain automated dashboards and reporting pipelines using SQL and Excel

Develop scalable datasets and queries to support category and commercial analysis

Ensure data accuracy, consistency, and usability for stakeholders across teams

Improve existing reporting processes through automation and optimization

• Business Insights & Strategic Support

Translate complex datasets into clear business insights and actionable recommendations

Support category managers in identifying assortment gaps, seller performance issues, and growth opportunities

Analyze campaign performance and promotion ROI to support commercial planning

Prepare analytical reports and presentations for internal stakeholders and management reviews

• Cross-functional Collaboration

Work closely with Category Managers, Business Development teams, and BI teams

Translate business questions into structured analytical problems and SQL-based solutions

Support ad-hoc analytical requests and special projects related to category growth and performance optimization

Requirements

• Bachelor's degree in Business Analytics, Statistics, Data Science, Economics, Engineering, or related fields
• 1–3 years of experience in analytics, ecommerce, consulting, or related fields
• Strong SQL skills and ability to query large datasets
• Advanced Excel skills (pivot tables, advanced formulas, data manipulation)
• Experience working with large datasets and performing structured analysis
• Strong analytical thinking and problem-solving mindset
• Ability to translate data insights into clear business recommendations
• Strong attention to detail and ability to manage multiple tasks simultaneously
• Ability to work independently and collaborate with cross-functional teams
• Preferred Qualifications
• Experience in ecommerce, marketplace platforms, or digital businesses
• Exposure to BI tools (e.g., Tableau, Power BI, Looker)
• Experience analyzing campaign performance, promotions, or seller performance
• Basic programming knowledge (Python, R, or similar) is a plus

This role offers strong exposure to commercial strategy and category management within Shopee. High-performing candidates will have opportunities to take on greater ownership of performance-driven initiatives and category growth projects.