MIS Executive –

Key Responsibilities
& RequirementsKey Responsibilities
- Prepare daily, weekly, and monthly MIS reports.
- Manage and analyze sales, marketing, and lead data.
- Create automated dashboards and reports using Advanced Excel and Macros (VBA).
- Develop and maintain Excel-based automation tools to improve reporting efficiency.
- Generate management reports to support business decision-making.
- Maintain CRM data and ensure data accuracy.
- Coordinate with sales and marketing teams for timely reporting.
- Perform data validation, cleaning, and reconciliation.
- Track campaign performance, sales metrics, and operational KPIs.
- Optimize existing MIS processes through Excel automation and workflow improvements.
- Monitor and manage the organization's online reputation across social media platforms and Google Business Profile.
- Track, respond to, and report on customer reviews, ratings, and feedback while coordinating with internal teams for timely resolution.
- Prepare periodic Online Reputation Management (ORM) reports highlighting customer sentiment, response rates, and improvement opportunities. Requirements
- Bachelor's degree in Commerce, Business Administration, Computer Science,



or a related field.
- 1–3 years of experience in an MIS, Reporting, or Operations Support role.
- Solid knowledge of Advanced Excel (Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, Power Query, Macros/VBA).
- Experience in creating and maintaining Excel Macros (VBA) for report automation.
- Knowledge of Google Sheets and Microsoft Office.
- Experience with CRM software is an added advantage.
- Experience with Online Reputation Management (ORM), including monitoring, responding to, and reporting on Google Business Profile reviews and social media feedback.
- Strong analytical and problem-solving skills.
- Good communication skills with attention to detail. Preferred Skills
- Advanced Excel
- Excel Macros (VBA) & Report Automation
- Power Query
- Google Sheets
- CRM Management
- Data Analysis
- Reporting & Dashboard Creation
- MIS Process Automation
- Online Reputation Management (ORM)
- Google Business Profile Review Management
- Social Media Review & Comment Monitoring
- Customer Feedback Analysis Pay: ₹18,000.00
- ₹20,000.00 per month Work

Location:
In person

📌 MIS & Data Analyst Executive – Sales & Marketing | Fresher / 1+ Years Experience (Koyambedu)
🏢 Black Coffee Brands
📍 Koyambedu