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., recent 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.

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 energetic charts, combo charts, dual-axis charts, and other visualizations;
Familiarity with macros/recording macros and Power Query is a plus;

PowerPoint skills: Ability to organize data into well-structured presentation decks with explicit data storytelling;
Familiarity with at least one

database query language (SQL) or BI tool (Power BI/Tableau/FineReport) is preferred.

📌 Specialist Gurugram
🏢 oppo
📍 Gurugram