Jobs

Job highlights

1-4 years experience in MIS with advanced Excel skills including Pivot Tables, VLOOKUP/XLOOKUP, and data validation; knowledge of Power BI preferred

Prepare and automate MIS reports, analyze multi-store data, track sales and inventory KPIs, coordinate with departments, and provide insights for management

Job description
Job Title: MIS Analyst

Location : Juhu, Vile Parle & then Bandra

Experience: 1 – 4 Years (MIS Executive)

About the Role

We are looking for an MIS Analyst to manage, analyse, and maintain business data and prepare regular MIS reports for management. The role will involve coordinating with different departments and stores, ensuring data accuracy, preparing dashboards, and providing meaningful insights to support business decisions.

Key Responsibilities

Prepare daily, weekly, and monthly MIS reports for management.
Collect, consolidate, validate, and analyze data received from multiple stores/departments.
Prepare store-wise, location-wise, category-wise, and sales performance reports.
Track sales, targets, inventory, stock movement, and other operational KPIs.
Develop and maintain Excel-based MIS dashboards and reports.
Identify data discrepancies and coordinate with relevant teams for correction.
Generate reports on sales, inventory, purchases, expenses, manpower, and store performance as required.
Maintain accurate and updated databases and MIS trackers.
Automate recurring reports wherever possible to improve efficiency.
Provide data analysis and insights to management for decision-making.
Coordinate with Stores, Accounts, Purchase, Operations, HR, and other departments for data collection and reporting.
Ensure timely submission of all scheduled MIS reports.
Maintain proper documentation and reporting formats.

Required Skills

Strong knowledge of MS Excel / Advanced Excel.
Good knowledge of Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, IF formulas, Charts, Conditional Formatting, and Data Validation.
Knowledge of Power BI will be an added advantage.
Strong data analysis and reporting skills.
Good understanding of MIS and business reporting.
Ability to handle large volumes of data with accuracy.
Good communication and coordination skills.
Strong attention to detail and problem-solving ability.

Preferred Candidate

Graduate in B.Com / BBA / B.Sc / BCA / MBA / or any relevant field.
14 years of experience in MIS, Data Analysis, Retail, FMCG, E-commerce, or similar industries.
Candidates with experience handling multi-store / retail business data will be preferred.

Key Performance Areas (KPIs)

Accuracy and timely submission of MIS reports.
Quality and efficiency of data analysis.
Timely identification and resolution of data discrepancies.
Automation and improvement of recurring reports.
Effective support to management through data-driven insights.

Role: MIS Executive
Industry Type: Beverage (Brewery / Distillery)
Department: Customer Success, Service & Operations
Employment Type: Full Time, Permanent
Role Category: Operations Support
Education
UG: B.C.A. in Any Specialization, Any Graduate