We are looking for a skilled and business-oriented MIS & Google Workspace Automation Executive who can collect, consolidate and analyze data across departments and develop complete reporting and process-automation systems.
Key Responsibilities:
* Collect, validate and consolidate data from Sales, Collections, Accounts, Purchase, Warehouse and Dispatch departments.
* Prepare accurate daily, weekly and monthly MIS reports and management dashboards within defined timelines.
* Develop and automate end-to-end systems using Advanced Excel, Google Sheets, Google Forms, Google Apps Script and Looker Studio.
* Create systems for sales reporting, receivables and ageing, collection follow-up, inventory monitoring, purchase planning, container tracking, pending orders and warehouse operations.
* Automate email reminders, due-date alerts, approvals, escalations, data transfers and scheduled reports using Google Apps Script.
* Build Google Forms for attendance, task reporting, warehouse checklists, stock verification, sales visits, approvals and other departmental requirements.
* Perform variance analysis, forecasting and performance reviews to identify delayed collections, excess or shortage of stock, operational gaps and missed business opportunities.
* Coordinate with employees to ensure timely and accurate data submission.
* Maintain proper data controls, protected formulas, access permissions, backups and documentation.
* Convert management requirements into simple, user-friendly and measurable digital systems.
Required Skills:
* Advanced Excel and Google Sheets
* Google Forms and Google Apps Script
* Looker Studio dashboards
* Strong analytical and problem-solving skills
* Knowledge of inventory, sales, receivables and business reporting
* Ability to independently understand requirements and build complete working systems
Experience: 2-5 years in MIS, reporting, data analysis or business-process automation.
Interested candidates should share their CV along with examples of dashboards, Google Sheets or automated systems developed by them.
Pay: ₹20,000.00 - ₹25,000.00 per month
Work Location: In person
