02 Oct
|
Pooja
|
Ahmedabad
The Role
This is a role for someone who turns raw data into clear, reliable reports management can act on. You'll pull data together from across the business, build and maintain the reports and dashboards the directors depend on, and make sure the numbers are always accurate. Strong, confident command of Google Sheets & Excel is the heart of this job - if you enjoy making messy data tell a clear story, you'll do well here.
What you'll do
- Produce ad-hoc analysis whenever the directors or managers need it
- Build and maintain reports and dashboards in Google Sheets (pivot tables, lookups, formulas, charts) for sales, inventory, receivables and other functions.
- Analyse and segment business data by - region, product, value band and more - to surface helpful insights for management.
- Consolidate data from multiple sources, and bring scattered department spreadsheets into a single, standardised system with clear structure and access control.
- Keep data clean and reliable - find and fix duplicates and errors, and set up validation rules and dropdown lists so information is entered consistently.
- Maintain and improve our internal reporting systems on Google Workspace (Sheets, Docs, Drive).
- Set up automated, recurring reports that pull from Tally & multiple sheets and reach management on schedule with minimal manual effort.
- Learn and use Google AppSheet to help build and maintain internal apps and dashboards as we grow.
- Build and deploy internal systems and automations using Google Apps Script, AppSheet, JavaScript and Google Sheets.
- Spot inefficient or manual processes and improve or automate them, and help colleagues adopt Google Sheets and Workspace ways of working.
- Ensure data accuracy and the timely delivery of daily, weekly and monthly reports.
- Support our B2B → B2C expansion by creating new reports and systems as requirements evolve.
What we're looking for
- 3-4 years as an MIS executive or in a data/reporting role
- Strong working knowledge of Google Workspace - especially Google Sheets (pivot tables, lookups, formulas, charts), Docs and Drive - as our reporting and internal systems run on Workspace - This is Non-Negotiable
- Advanced spreadsheet skills across Google Sheets and Excel - comfortable structuring and analysing large, messy datasets.
- Willingness and aptitude to learn Google AppSheet to build and maintain our internal apps and dashboards.
- Strong command of Excel and/or Google Sheets
- Comfortable pulling and working with data from Tally or similar systems
- Accurate, detail-oriented, and well-organised with data
- Working English for records; Gujarati/Hindi for coordinating internally
Preferred (not essential)
- Hands-on experience with Google AppSheets for building inventory, reporting or workflow apps.
- A background in mathematics or another numerate field
- Experience reporting for a trading or distribution business
📌 MIS Executive (Ahmedabad)
🏢 Pooja
📍 Ahmedabad