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 dynamic 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 clear data storytelling;

- Familiarity with at least one

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

📌 Specialist (Haryana)
🏢 oppo
📍 Haryana