Job description:
We are looking for a DME / MIS & Business Automation professional who can manage, analyze and automate business data and develop effective reporting systems for management.
The candidate will be responsible for creating and maintaining MIS reports, automated Excel/Google Sheets trackers, management dashboards and performance reports across various business functions such as Sales, Purchase, Operations, Finance, Expenses, Customer Management and Supply Chain.
The ideal candidate should be highly proficient in Advanced Excel, Google Sheets and Google Looker Studio, with a strong understanding of business processes and the ability to convert manual reporting into automated and actionable systems.\
Key Responsibilities
- Develop and maintain daily, weekly and monthly MIS reports for management.
- Create and manage automated Excel and Google Sheets trackers.
- Develop interactive dashboards using Google Looker Studio / Power BI.
- Analyze business data and provide meaningful insights to management.
- Prepare department-wise, customer-wise, product-wise and location-wise reports.
- Develop critical-number and exception-based reporting with appropriate alerts and color coding.
- Track sales, orders, collections, expenses, inventory, operations, customer activities and other key business parameters.
- Automate repetitive reporting and data-management processes.
- Ensure accuracy, consistency and timely availability of management reports.
- Consolidate data from multiple sources and create centralized reporting systems.
- Identify gaps in existing reporting processes and suggest automation/improvement opportunities.
- Work closely with Sales, Accounts, Purchase, Operations, Finance and Management teams to understand reporting requirements.
- Develop performance dashboards and comparative reports for management review.
- Maintain data integrity and establish proper reporting controls.
- Support management in Monday/weekly/monthly review meetings through relevant MIS and dashboards.
- Develop systems for automated Email / WhatsApp communication and alerts, wherever required.
- Support implementation of CRM, ERP, AI and other business automation initiatives.
Required SkillsTechnical Skills
- Advanced Microsoft Excel
- Advanced Excel formulas and functions
- Pivot Tables, Pivot Charts and Dashboards
- Power Query
- Advanced Google Sheets
- Google Looker Studio
- Data analysis and visualization
- MIS & Business Reporting
- Automation and workflow development
- Data cleaning and consolidation
- Google Forms / App Script – added advantage
- Power BI – added advantage
- VBA / Macros – added advantage
- CRM / ERP reporting – added advantage
- API / WhatsApp / Email automation – added advantage
Benefits:
- Cell phone reimbursement
- Paid sick time
- Paid time off
- Provident Fund
Work Location: In person
Pay: ₹35,000.00 - ₹40,000.00 per month
Benefits:
- Cell phone reimbursement
- Food provided
- Paid sick time
- Provident Fund
Work Location: In person
