MIS Executive – Google Sheets & Dashboard
Location: Pitampura, Delhi
Salary: Up to ₹45,000 per month
Employment Type: Full-Time | Work From Office
Experience: 2–6 Years
Job Overview
We are looking for a skilled and detail-oriented MIS Executive with strong hands-on experience in Google Sheets, Advanced Excel, MIS reporting, dashboards, FMS and automation. The ideal candidate should be comfortable handling large volumes of data, preparing management reports and developing automated reporting systems.
Strong communication skills are essential, along with the ability to coordinate with different departments and present data clearly to management.
Key Responsibilities
- Design, maintain and manage FMS, IMS and PMS dashboards using Google Sheets and Advanced Excel.
- Handle and analyze large volumes of daily transactional data with high accuracy.
- Create interactive and real-time KPI dashboards for management and different departments.
- Develop MIS reports using Pivot Tables, advanced formulas, conditional formatting, charts and data validation.
- Build automated reporting systems to reduce manual data entry and reporting time.
- Develop and maintain business dashboards covering Order Sheets, Packing Slips, Invoices, LR Copies, Ledgers and other operational reports.
- Use Google Apps Script for workflow automation and process optimization.
- Track department-wise KPIs and provide regular MIS reports to management.
- Maintain data accuracy, consistency and timely updation of all reports.
- Coordinate with Sales, Purchase, Accounts, Operations and other departments for data collection and reporting.
- Identify repetitive manual processes and implement automation wherever possible.
- Use AI tools such as ChatGPT and Google Gemini for reporting automation and workflow improvement.
- Prepare ad-hoc reports and analysis as required by management.
Required Skills
- Advanced Excel – Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, IF formulas, SUMIFS/COUNTIFS, charts and dashboards.
- Advanced Google Sheets – formulas, dashboards, data management and automation.
- Strong experience in FMS / MIS / PMS reporting.
- Good knowledge of Dashboard Creation and Data Analysis.
- Knowledge of Google Apps Script / Automation will be highly preferred.
- Knowledge of Looker Studio will be an added advantage.
- Working knowledge of Tally Software.
- Strong analytical and problem-solving skills.
- Excellent verbal and written communication skills.
- Ability to coordinate effectively with multiple departments.
- Strong attention to detail and accuracy.
Preferred Candidate Profile
The ideal candidate should have practical experience working on Google Sheets-based MIS and business reporting, rather than only theoretical knowledge of Excel. Candidates who have developed automated dashboards, FMS systems and management reports will be preferred.
Interested candidates can apply with their updated CV.
Pay: ₹35,000.00 - ₹45,000.00 per month
Work Location: In person
