Senior Market Intelligence Analyst, ShopeeFood

What you'll do

We are seeking a senior market intelligence analyst with strong analytical skills and business mindset. The preferred candidate will be the strategic "radar" for our merchant strategy. They will transform complex internal and external data into actionable insights that dictate our competitive edge in terms of merchant assortment, merchant investment, price competitiveness and market share.

1. Competitive Intelligence & Market benchmarking

• External Benchmarking: Monitor and interpret complex data to track competitor assortment, coverage percentage and growth trend by location and segment in order to identify critical assortment gaps.
• Commercial metric tracking: Conduct cross-platform comparisons of merchant investment, take-rate structures, and promotion participation across different segments and cities.
• Market Share Research: Liaise with BD teams to conduct field research and data modeling to estimate market share, flagging alarming trends and identifying untapped room for growth.
• Project management: conduct and oversee end-to-end cross-functional researches deep-dive into merchant sentiment, feature adoption & investment willingness.

2. Merchant strategy support

• Merchant Strategy Development: Analyze merchant "hygiene" and performance factors—such as opening hours, ratings, and category —to guide high-level strategic decisions.
• Growth Lever Identification: Execute deep-dive analyses and build heatmap to highlight areas for merchant acquisition and expansion.
• Operational Mechanics: Maintain a deep understanding of merchant ops policies and funding mechanics, via both primary and secondary research

3. Dashboard & Reporting

• Advanced Data Visualization: Develop and maintain dashboards, reports, and data visualizations to monitor key performance and business metrics (Excel/SQL-based) that provide "at-a-glance" clarity on key business metrics.
• Proactive Anomaly Detection: take ownership in data usability and Investigate outliers within cleaned datasets to ensure reporting accuracy.
• AI-Driven Productivity: Champion the use of in-house and external AI solutions to automate routine tasks, summarize market trends, and improve productivity and analytical capabilities.

Requirements

• 3+ years of experience in a Business Intelligence, Business/Data Analytics role, preferably in ecommerce or a high-growth startup.
• Advanced Excel & SQL proficiency — including window functions, CTEs, performance tuning, and query optimization on distributed systems (Presto/Trino, BigQuery, Redshift, or Snowflake).
• Demonstrate commercial acumen with strong numerical sense and attention to detail
• Able to work cross functionally and manage multiple projects and stakeholders simultaneously.
• Preferred: Domain knowledge in ecommerce, food delivery, or marketplace platforms — particularly around merchant/seller strategy