Company: Medimaze Solutions Pvt. Ltd.
Job Title: MIS Executive
Location: Pune, Maharashtra
Employment Type: Full-Time
Department: Operations / Management Information System
Experience: 2–4 Years
Job Summary
We are seeking a highly organized and detail-oriented MIS Executive to join our team at our Pune office. The ideal candidate will be responsible for preparing, managing, and analysing business data, generating reports and dashboards, and providing actionable insights to support management in strategic decision-making. The candidate should have excellent analytical abilities and advanced Microsoft Excel skills.
Key Responsibilities
- Prepare Daily, Weekly, and Monthly MIS reports.
- Collect, verify, and maintain accurate business data from various departments.
- Generate reports, dashboards, and presentations for management review.
- Analyse business performance and identify trends, gaps, and improvement opportunities.
- Ensure data accuracy, consistency, and timely submission of reports.
- Prepare sales, operations, inventory, and business performance reports.
- Coordinate with cross-functional teams for data collection and reporting.
- Automate routine reports using advanced Excel functions wherever possible.
- Maintain databases and ensure confidentiality of company information.
- Support management with ad hoc reporting and data analysis requirements.
Required Skills
- Strong knowledge of Microsoft Excel (Advanced Excel).
- Hands-on experience with:
- Pivot Tables
- VLOOKUP/XLOOKUP
- INDEX-MATCH
- IF, SUMIF, COUNTIF Functions
- Conditional Formatting
- Charts & Graphs
- Data Validation
- Good working knowledge of Google Sheets.
- Basic understanding of Power BI is an added advantage.
- Strong analytical and problem-solving abilities.
- Excellent attention to detail and accuracy.
- Good communication and interpersonal skills.
- Ability to work independently and manage multiple tasks efficiently.
Qualifications
- Bachelor’s Degree in Commerce, Business Administration, Computer Applications, Statistics, Mathematics, or a related field.
- 2–4 years of relevant experience in MIS Reporting, Data Analysis, or a similar role.
Preferred Skills
- Experience in Healthcare, Pharmaceutical, or Service Industry.
- Knowledge of CRM or ERP software.
- Basic knowledge of SQL or databases will be an added advantage.
- Familiarity with Power Query and Power BI is preferred.