Job Description

Key Responsibilities:

Prepare and manage MIS reports (daily/weekly/monthly) using

Advanced Excel and Google Sheets

Build dynamic dashboards with

Pivot Tables, Power Query, complex formulas, and Google Sheet functions

Consolidate large datasets from multiple departments and ensure data accuracy Analyze KPIs, trends, variances, and operational performance; highlight gaps and risks Automate recurring reports using

Excel Macros, VBA, Power Query, and Google Sheets automation

Create management-level dashboards using

Excel, Power BI, and Google Data Studio

Support budgeting, forecasting, and variance analysis with data-driven insights Maintain master data integrity across ERP systems and reporting tools Coordinate with Accounts, HR, Purchase, and Operations for timely data collection Support audits, compliance, and ad hoc management reporting

Skills & Education:

Bachelor's degree in Commerce / IT / Statistics / Engineering

Expert-level MS Excel

(Pivot Tables, Power Query, Macros, VBA, advanced formulas)

Strong command over Google Sheets

(Array formulas, QUERY, Apps Script basics preferred) Experience with ERP systems (Tally, SAP, Zoho, or similar) Power BI / Tableau proficiency is a strong advantage Basic SQL knowledge preferred Excellent analytical, communication, and time management skills High attention to detail and reporting accuracy
Job Type: Full-time

Pay: ₹20,000.00 - ₹25,000.00 per month

Work Location: In person