Mis Executive

M B Ashtekar Jewellers Pvt. Ltd.; Pune District; On-site; INR 350,000 - 550,000; Full time

Job summary

MB Ashtekar Jewellers Pvt. Ltd. in Pune is seeking a detail-oriented MIS Executive to manage daily, weekly, and monthly MIS reporting, data maintenance, and insights.

The role requires proficiency in Advanced Excel and Google Sheets, strong analytical ability, and high attention to detail to handle multiple reports across departments. The ideal candidate will possess a graduate degree and 3 years of experience in MIS/Analytics, with a passion for accurate data and timely reporting.

Qualifications

• Graduate in B.Com, BBA, B.Sc., BCA, Mathematics, Statistics, or any relevant field.
• Candidates with a strong Mathematics / Statistics background will be preferred.

Responsibilities

• Prepare and maintain Daily, Weekly, and Monthly MIS Reports.
• Collect, verify, organize, and maintain data from different departments and branches.
• Create and maintain Excel and Google Sheets reports and dashboards.
• Use Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX-MATCH, IF formulas, SUMIF/SUMIFS, COUNTIF/COUNTIFS, and other advanced Excel functions.
• Prepare branch-wise, department-wise, and employee-wise reports as required.
• Analyze data and identify discrepancies, trends, and variations.
• Maintain accurate records and ensure data integrity.
• Generate reports related to Sales, Inventory, Attendance, HR, Payroll, and Operations as required.
• Consolidate data received from multiple branches and prepare management reports.
• Develop automated and easy-to-understand Excel reports wherever possible.
• Track pending reports and coordinate with concerned departments for timely data submission.
• Support management with data analysis and decision-making reports.
• Maintain proper documentation and version control of MIS files.
• Ensure all reports are accurate and submitted within the required timelines.

Skills

Advanced Excel

Google Sheets

Education

Graduate in B.Com, BBA, B.Sc., BCA, Mathematics, Statistics, or any relevant field

Job description

Job Description MIS Executive

Position: MIS Executive

Department: MIS / Operations

Location: Pune

Employment Type: Full-Time

Experience-3 Years

Qualication: Graduate in any discipline; candidates with a background in Mathematics, Statistics, Commerce, or a related eld will be preferred.

Job Summary

We are looking for a detail-oriented and analytical MIS Executive who is highly procient in Advanced Excel and Google Sheets. The candidate will be responsible for preparing daily, weekly, and monthly MIS reports, maintaining accurate data, analyzing business information, and providing management with timely reports and insights. The ideal candidate should have strong Excel skills, good mathematical and analytical ability, and excellent attention to detail.

Key Responsibilities

Prepare and maintain Daily, Weekly, and Monthly MIS Reports.

Collect, verify, organize, and maintain data from dierent departments and branches.

Create and maintain Excel and Google Sheets reports and dashboards.

• Use Pivot Tables, Pivot Charts, VLOOKUP/XLOOKUP, INDEX-MATCH, IF formulas, SUMIF/SUMIFS, COUNTIF/COUNTIFS, and other advanced Excel functions.
• Prepare branch-wise, department-wise, and employee-wise reports as required.
• Analyze data and identify discrepancies, trends, and variations.
• Maintain accurate records and ensure data integrity.
• Generate reports related to Sales, Inventory, Attendance, HR, Payroll, and Operations as required.
• Consolidate data received from multiple branches and prepare management reports.
• Develop automated and easy-to-understand Excel reports wherever possible.
• Track pending reports and coordinate with concerned departments for timely data submission.
• Support management with data analysis and decision-making reports.
• Maintain proper documentation and version control of MIS les.
• Ensure all reports are accurate and submitted within the required timelines.

Required Skills

Advanced Excel

• Excellent knowledge of MS Excel
• Advanced formulas and functions
• Pivot Tables & Pivot Charts
• VLOOKUP / XLOOKUP
• INDEX & MATCH

1

Google Sheets

• Good knowledge of Google Sheets
• Data sharing and collaboration
• Formulas and Pivot Tables
• Google Sheets reporting and data management

Educational Qualication

• Graduate in B.Com, BBA, B.Sc., BCA, Mathematics, Statistics, or any relevant eld.
• Candidates with a strong Mathematics / Statistics background will be preferred.

Candidate Prole

• Strong analytical and mathematical ability.
• Excellent attention to detail.
• Good numerical and logical reasoning skills.
• Ability to work with large volumes of data.
• Strong problem-solving skills.
• Good communication and coordination skills.
• Ability to meet deadlines.
• Should be comfortable working with multiple reports simultaneously.
• Should have a high level of accuracy in data entry and reporting.
• Ability to maintain condentiality of company and employee information.

Preferred Experience

Candidates having experience in MIS, Data Analysis, Reporting, Operations, HR MIS, Sales MIS, Inventory MIS, or Business Reporting will be preferred.

Experience: 13 years

Key Performance Indicators (KPIs)

• Accuracy of MIS reports
• Timely submission of reports
• Data integrity and error-free reportingQuality of data analysis
• Timely identication of discrepancies
• Automation and improvement of reporting processes

2

Responsiveness to management reporting requirements

Why Join Us?

This role provides an opportunity to work closely with management and multiple departments, gain exposure to business operations, and contribute directly to data-driven decision-making and reporting.

3