Experience: 2–5 Years (Preferred)
Job Summary
We are looking for a detail-oriented and analytical MIS Executive to manage, maintain, and analyze business data using Google Sheets, Advanced Excel, and AI tools such as ChatGPT. The ideal candidate should be capable of creating reports, dashboards, automations, and data-driven insights to support business decision-making.
Key Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports.
- Manage large datasets using Google Sheets and Advanced Microsoft Excel.
- Create and maintain dashboards, trackers, and performance reports.
- Perform data cleaning, validation, and analysis to ensure data accuracy.
- Use advanced Excel functions such as:
- VLOOKUP/XLOOKUP
- INDEX-MATCH
- Pivot Tables
- Power Query
- Conditional Formatting
- Advanced Formulas
- Develop and automate reports using Google Sheets formulas and scripts (preferred).
- Utilize ChatGPT and AI tools to improve productivity, reporting, documentation, and process automation.
- Coordinate with various departments to collect, compile, and analyze business data.
- Generate actionable insights and recommendations from data analysis.
- Ensure timely submission of reports to management.
Required Skills
- Strong knowledge of Google Sheets.
- Excellent command of Advanced Microsoft Excel.
- Proficiency in data analysis and reporting.
- Knowledge of ChatGPT and AI-based productivity tools.
- Good analytical and problem-solving skills.
- Strong attention to detail and accuracy.
- Excellent communication and organizational skills.
Preferred Qualifications
- Bachelor's degree in Commerce, Business Administration, Computer Applications, Statistics, or a related field.
- Candidates who have completed or attended **Rahul Jain's Advanced Excel/MIS training programs will be preferred.
- Knowledge of Google Apps Script, Power BI, or Data Studio will be an added advantage.
Pay: ₹20,000.00 - ₹25,000.00 per month
Work Location: In person
