18 Sep
|
Aditrri Smart International Private
|
Bagnan
18 Sep
Aditrri Smart International Private
Bagnan
Role Overview
We are looking for an experienced MIS Executive with strong expertise in Advanced Excel, Google Sheets, MIS Reporting, Dashboard Creation, and Data Analysis. The candidate should be analytical, detail-oriented, and capable of managing large datasets and developing accurate, automated reports.
Key Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports and management dashboards.
- Consolidate data from Production, Sales, Inventory, Operations, Accounts, and HR.
- Create dashboards using Pivot Tables, Charts, Lookup Functions, and Advanced Formulas.
- Work extensively with XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF/IFS, Pivot Tables, and Conditional Formatting.
- Use Google Sheets functions such as QUERY, IMPORTRANGE, ARRAYFORMULA, FILTER, and UNIQUE.
- Identify and troubleshoot formula and data errors.
- Maintain data accuracy, validation, and reporting standards.
- Automate repetitive reports using Google Apps Script or other tools.
- Coordinate with departments for data collection, verification, and analysis.
Required Skills
- 3–5 years of relevant MIS experience.
- Solid hands-on knowledge of Advanced Excel & Google Sheets.
- Excellent analytical, mathematical, logical, and problem-solving skills.
- Experience in MIS reporting, dashboards, data consolidation, and large datasets.
- Good communication and coordination skills.
- Knowledge of Google Apps Script/automation will be an added advantage.
- Bachelor's degree in Mathematics, Statistics, Computer Science, or a related field preferred.
Salary/CTC: Competitive, based on experience
Pay: ₹18,000.00 - ₹25,000.00 per month
Work Location: In person
📌 MIS Executive (Bagnan)
🏢 Aditrri Smart International Private
📍 Bagnan