Shift Timing - 8am to 5pm
Key Responsibilities
Reporting & Dashboards
● Design, build, and maintain MIS reports and dashboards in Google Sheets for sales, inventory, and operational data.
● Identify key metrics (totals, growth, top performers) and present them through clear, pivot-table- and chart-driven dashboards.
● Set up dynamic, self-updating reports using formulas such as SUMIFS, INDEX/MATCH, QUERY, and ARRAYFORMULA.
Systems Consolidation & Automation
● Consolidate data spread across multiple Excel/Sheets files maintained by different departments into a single, well-structured Google Sheets system.
● Build automation using Google Apps Script, IMPORTRANGE, and add-ons to eliminate manual, repetitive reporting work (e.g., auto-generated and auto-emailed weekly reports).
● Set up data validation, dropdown lists, named ranges, and access controls to keep shared systems clean and error-resistant.
● Plan and execute smooth transitions when migrating teams from Excel-based or manual processes to Google Sheets systems, including backup and rollback planning.
Troubleshooting & Support
● Diagnose and fix broken formulas and data errors (#REF!, #VALUE!, #N/A) using a structured, step-by-step approach.
● Act as the go-to person for spreadsheet and reporting issues across departments, documenting fixes for future reference.
Process Improvement
● Proactively identify inefficient manual processes and redesign them into streamlined, systemized workflows.
● Continuously look for opportunities to reduce manual data entry and reporting turnaround time.
Training & Change Management
● Train team members — including those resistant to change — on new systems and Google Sheets best practices, with patience and a teaching mindset.
● Provide ongoing, hands-on support during and after system rollouts.
Pay: ₹25,000.00 - ₹35,000.00 per month
Work Location: In person
