Job Title: MIS Executive

Company: MISS HIGHNESS – Premium 925 Silver Jewellery

Department: MIS / Business Operations

Experience: 2–4 Years

Employment Type: Full-time, Permanent

Key Responsibilities

1. MIS Reporting & Data Management

- Prepare and maintain daily, weekly and monthly MIS reports.
- Consolidate data from multiple sources and ensure accuracy and consistency.
- Maintain structured databases, master sheets and reporting formats.
- Track business performance, identify discrepancies and highlight important trends.
- Ensure timely submission of reports to management and relevant departments.

2. Advanced Excel & Data Analysis

- Demonstrate strong working knowledge of Advanced Excel, including:
- VLOOKUP, HLOOKUP, XLOOKUP and INDEX-MATCH.
- Pivot Tables and Pivot Charts.
- SUMIFS, COUNTIFS, IF, nested IF and logical formulas.
- Conditional Formatting, Data Validation and advanced filtering.
- Text, date and data-cleaning functions.
- Handle large datasets and perform data merging, reconciliation and analysis.
- Use Excel efficiently to reduce manual work and improve reporting accuracy.

3. Dashboard Creation & Performance Tracking

- Develop dynamic Excel dashboards for management reporting.
- Create visual reports using charts, graphs, slicers and Pivot Tables.
- Track KPIs, performance trends, targets versus actuals and month-on-month growth.
- Present complex data in a clear, structured and easy-to-understand format.
- Update dashboards regularly and ensure data accuracy.

4. E-commerce & Sales Reporting

- Prepare channel-wise sales reports for marketplaces, Shopify, quick commerce and offline channels.
- Track daily sales, order volumes, cancellations, returns,



revenue and SKU-wise performance.
- Prepare product-wise, category-wise and channel-wise performance reports.
- Analyse sales trends, identify gaps and highlight underperforming products or channels.
- Coordinate with sales and operations teams to verify data and resolve discrepancies.

5. Inventory & Operations Reporting

- Prepare stock availability, inventory ageing, stock movement and replenishment reports.
- Track order processing, dispatch performance, returns, RTO and fulfilment metrics.
- Identify inventory mismatches and coordinate with operations teams for resolution.
- Maintain accurate records of stock transfers, adjustments and operational exceptions.

6. Report Automation & Process Improvement

- Automate repetitive reports using Excel formulas, templates and Power Query where applicable.
- Standardise reporting formats and improve data collection processes.
- Identify opportunities to reduce manual work and reporting errors.
- Maintain proper documentation, version control and data confidentiality.

7. Coordination & Management Support

- Coordinate with finance, sales, e-commerce, warehouse and marketing teams for data collection.
- Prepare ad hoc reports and business analysis as required by management.
- Highlight unusual variances,



data inconsistencies and key performance trends.
- Ensure all reports are accurate, verified and delivered within defined timelines.

Candidate Requirements

- Graduate in Commerce, Business Administration, Mathematics, Statistics or a related field.
- 1–4 years of experience in MIS reporting, data analysis or business reporting.
- Excellent knowledge of Advanced Excel and complex formulas.
- Strong hands-on experience with VLOOKUP, XLOOKUP, INDEX-MATCH, Pivot Tables and dashboards.
- Experience handling large datasets, data cleaning, reconciliation and report automation.
- Knowledge of Power Query and Power BI will be an added advantage.
- Experience in e-commerce, retail, D2C, inventory or sales reporting is preferred.
- Strong analytical skills, attention to detail and problem-solving ability.
- Positive communication skills and the ability to present data clearly.
- Ability to manage multiple reporting requirements and meet strict deadlines.

Key Performance Indicators (KPIs)

- Accuracy and timeliness of MIS reports.
- Quality and reliability of dashboards.
- Reduction in manual reporting time through automation.
- Accuracy of sales, inventory and operational data.
- Timely identification and resolution of data discrepancies.
- Completion of daily, weekly and monthly reports within deadlines.
- Effectiveness of data analysis and actionable insights provided to management.

Pay: ₹15,000.00 - ₹21,000.00 per month

Benefits:

- Cell phone reimbursement
- Flexible schedule
- Internet reimbursement
- Leave encashment
- Paid sick time
- Paid time off

Work Location: In person

📌 MIS Executive (Kaushambi)
🏢 Ejaa- Silver Jewellery
📍 Kaushambi