Procurement & Agency Data Analyst, SPX Singapore

Shopee; Singapore; On-site; SGD 55,000 - 85,000; Full time

Job summary

Shopee in Singapore is seeking a billing data analyst to extract, reconcile, and report agency data using SQL on a monthly cadence. You will redesign billing logic as business processes evolve and build dashboards to support P&L and Operations KPI tracking.

You will collaborate with cross-functional teams to acquire, clean, and visualize data, generate ad hoc reports, and streamline billing SOP communications with internal and external stakeholders, ensuring accuracy and timely insights.

Qualifications

• Bachelor’s degree in Business, Business Analytics, Supply Chain Management, or related field.
• Proficient in Microsoft Excel and SQL; Python is a plus.
• Ability to analyse data and derive key insights that guide business decisions.
• Strong verbal and written communication skills; cross-functional collaboration.

Responsibilities

• Extract, reconcile and report the billing data of agencies using SQL monthly.
• Design and modify billing logic according to changes in business processes.
• Ad Hoc data support and dashboard building for P&L analysis and Operations KPI.
• Assist full-cycle projects on data acquisition, data cleaning, data analysis and data visualisation.
• Streamline billing SOP and communicate the SOP between internal and external stakeholders.
• Generate ad hoc reports to support operation and procurement teams.
• Monitor and optimise reporting flow from back-end to front-end.
• Work with several large and complex data warehouses.

Skills

Excel

SQL

Python

Data analysis

Communication

Teamwork

Detail-oriented

Education

Bachelor's degree

Job description

About The Team

The Operation teams at SPX Express covers the operational end-to-end process, from when the buyer searches for a product listed on the Shopee platform, to the moment the buyer receives the products. The team analyses and monitors operational KPIs across the region and conducts root cause analysis when operation performance fluctuates. Scope includes Payment, Incentive and Penalty calculation, Logistics performance monitor, Operation planning.

Job Description

• Extract, reconcile and report the billing data of agencies utilising SQL monthly
• Design and change billing logic according to business process changes, new initiative or other changes
• Ad Hoc data support and dashboard building for P&L analysis and Operations KPI
• Assist full-cycle projects on data acquisition, data cleaning, data analysis and data visualisation
• Streamline billing SOP and communicate the SOP between internal and external stakeholders
• Generate ad hoc reports to support operation and procurement teams
• Monitor and optimise reporting flow from back-end to front-end
• Work with several large and complex data warehouses

Requirements

• At least a Bachelor’s degree in Business, Business Analytics, Supply Chain Management, or a related field.
• Proficient in Microsoft Excel and SQL; Python skill is a plus
• Ability to analyse data and derive key insights (e.g., business implications) that guide key business decisions
• Ability to pay attention to details and manage tasks effectively
• Ability to bring onboard new perspectives and ways to carry out tasks and solve problems
• Strong verbal and written communication skills
• Positive team-player with an energetic attitude
• Work well with cross-functional teams and thrive in a dynamic work environment