Job Summary
We are looking for a highly organized and analytical MIS Executive / CRM & Database Coordinator who has excellent command over Advanced Microsoft Excel, CRM Database Management, and coordination activities. The ideal candidate should be capable of maintaining large databases, generating MIS reports, coordinating with internal teams, supporting event management activities, conducting online research, and ensuring accurate data management.
Key Responsibilities
Advanced Excel & MIS
- Prepare and maintain daily, weekly, and monthly MIS reports.
- Create advanced Excel reports using:
- Pivot Tables
- VLOOKUP/XLOOKUP
- INDEX-MATCH
- IF, SUMIF, COUNTIF
- Conditional Formatting
- Data Validation
- Charts & Dashboards
- Manage large datasets with high accuracy.
- Perform data analysis and prepare management reports.
CRM & Database Management
- Maintain and update CRM records.
- Ensure data accuracy and eliminate duplicate records.
- Generate reports from CRM.
- Manage customer and business databases.
- Coordinate CRM updates with different departments.
Event Coordination
- Coordinate meetings, seminars, webinars, and business events.
- Maintain event schedules and participant databases.
- Coordinate with vendors, clients, and internal teams.
- Track event-related documentation and follow-ups.
Research & Data Collection
- Conduct market research and competitor analysis.
- Collect business information from various online platforms.
- Prepare research reports and presentations.
- Support management with business intelligence and data analysis.
Coordination & Communication
- Coordinate with internal departments for timely execution of tasks.
- Follow up on pending activities.
- Prepare MOM (Minutes of Meeting).
- Maintain proper documentation and records.
Required Skills
Technical Skills
- Advanced Microsoft Excel (Mandatory)
- CRM Software Management
- Database Management
- Google Sheets
- Microsoft Office Suite
- PowerPoint
- Data Analysis & Reporting
- MIS Reporting
Soft Skills
- Excellent verbal and written communication
- Strong coordination skills
- Excellent interpersonal skills
- Good presentation skills
- Strong analytical thinking
- Problem-solving ability
- Time management
- Attention to detail
- Ability to manage multiple tasks simultaneously
Educational Qualification
- Bachelor's Degree in Commerce, Business Administration, Computer Applications, or any relevant field.
- Certification in Advanced Excel will be an added advantage.
Preferred Experience
Candidates having experience in any of the following industries will be preferred:
- Consulting
- Chartered Accountancy Firms
- Manufacturing
- Retail
- Service Industry
- IT Services
- Event Management
- Corporate Office
Pay: ₹12,000.00 - ₹15,000.00 per month
Work Location: In person
