Back Office MIS Executive

Role Summary
We are looking for an MIS Executive to collect, organize and analyse business data and deliver accurate, timely reports to management. The role requires strong command of Excel and Google Workspace and a sharp eye for data errors.

Key Responsibilities

• Prepare daily, weekly and monthly MIS reports for production, inventory, dispatch, purchase and sales.

• Collect data from different departments and keep it accurate and up to date.

• Analyse data to identify trends, variances and issues, and share clear summaries with management.

• Find and remove duplicate entries, errors and inconsistencies in data.

• Build and maintain dashboards, trackers and automated reports using Excel and Google Sheets.

• Manage shared files, forms and access permissions in Google Workspace (Sheets, Drive, Forms, Docs).

• Maintain data backups and document report formats and procedures.

• Follow up with departments on missing or late data.

Required Skills

• Advanced Excel: VLOOKUP/XLOOKUP, INDEX-MATCH, IF, SUMIFS/COUNTIFS, pivot tables, conditional formatting, data validation, Remove Duplicates, charts, basic macros.

• Google Sheets: QUERY, FILTER, UNIQUE, ARRAYFORMULA, IMPORTRANGE, pivot tables, and sharing and protecting sheets.

• Google Workspace: Drive, Forms, Docs, Calendar, and managing shared access.

• Strong data analysis and reporting skills, with attention to detail.

• Good communication skills in English and Hindi/Punjabi.

• Ability to meet deadlines and handle confidential data.

• It is a Full Time Back Office / Data Entry job for candidates with 1 - 5 years of experience.