Maintain and validate large datasets (client leads, sales, follow-ups).
Remove duplicates, standardize city names (e.g., Bombay ? Mumbai), and ensure contact details are correctly formatted.
Track and update missing or inconsistent follow-up data.
Data Analysis & Reporting
Prepare daily, weekly, and monthly MIS reports for management.
Use advanced formulas (SUMIF, COUNTIF, IF, DATEDIF, VLOOKUP, etc.) for lead and sales tracking.
Monitor KPIs such as total leads, pending follow-ups, and conversion rates.
Build dashboards with Pivot Tables, charts, and interactive filters for management review.
Insights & Decision Support
Highlight overdue follow-ups, priority leads, and conversion performance across cities.
Provide 3-5 actionable insights each reporting cycle to guide sales strategies.
Support the sales team in preparing exhibition/lead performance reports.
Skills
Strong command of
Advanced Excel / Google Sheets
.
Expertise in
Pivot Tables, dashboards, conditional formatting, and formula-based analysis
.
Analytical mindset; ability to extract meaningful insights from raw data.
A background in
Mathematics / Statistics / Data Analytics
is a plus.
Strong communication and presentation skills.
Job Types: Full-time, Fresher, Internship
Pay: ₹2,500.00 - ₹5,000.00 per month
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.