Sales Operations Specialist (Third Party Payroll)

Role & responsibilities

Data Collection & Organization

• Collect, verify, input, and archive daily sales data from mobile phone Key Account (KA) channels, including but not limited to: daily/weekly/monthly sales volume, inventory levels, procurement volume, device activations, and grey-market flow data, broken down by region, account, and model.
• Liaise with internal sales teams, regional supervisors, finance, and external KA client data contacts to ensure data is **timely, accurate, and complete
• Establish and maintain standardized data collection templates and naming conventions to minimize human errors.

Report Generation & Output

• Produce routine departmental reports: daily reports, weekly reports, monthly reports, and quarterly review dashboards (covering achievement rates, YoY/MoM comparisons, target gap analysis, etc.).
• Generate ad-hoc thematic analysis reports based on business needs (e.g., new product launch first-sales tracking, promotional campaign performance briefs, key account sell-out analysis).
• Present data findings in visualized charts and structured PPT decks for management consumption.

Data Quality & Anomaly Monitoring

• Establish basic data quality check mechanisms to identify outliers (e.g., sudden spikes/plunges in sales, logical inconsistencies in inventory/sales ratios) and issue timely alerts for business verification.
• Maintain consistency in data definitions and metrics; document version changes and communicate updates clearly.

Basic Analysis & Business Support

• Provide preliminary trend observations based on historical data (e.g., Model X has been declining for 3 consecutive weeks inventory risk may warrant attention) to support KA managers in strategy formulation.

Preferred candidate profile

• Technical Skills (Mandatory) - Advanced Excel proficiency (non-negotiable)
• Proficient in VLOOKUP, SUMIFS, COUNTIFS, nested IF, and other core functions;
• Skilled in PivotTables for multi-dimensional cross-tabulation; - Capable of creating dynamic charts, combo charts, dual-axis charts, and other visualizations;
• Familiarity with macros/recording macros and Power Query is a plus;
• Familiarity with at least one
• Database query language (SQL)** or **BI tool (Power BI/Tableau/Final Report)** is preferred.