MIS Executive

Job Title: MIS Executive

Location: Kirti Nagar, Delhi

Job Type: Full Time

About Mystery Rooms

Mystery Rooms is India’s fastest‑growing escape game company, with branches in 15 cities and 26 locations. We create immersive experiences and are driven by innovation, fun, and excellent customer service.

Job Overview

The MIS Executive will ensure accurate, timely, and insightful reporting of business performance by collecting, analysing, maintaining and presenting data. The person in this role will use strong mathematical background and excellent skills in Excel / Google Sheets to generate actionable insights and help leadership make data‑driven decisions.

Key Responsibilities

Gather data from multiple sources (internal systems, departments, external vendors) and ensure consistency, accuracy, and integrity of data.

Prepare daily, weekly, monthly, quarterly MIS reports to track key metrics across departments such as sales, operations, finance, etc.

Develop, update, and maintain dashboards and visual reports (in Excel / Google Sheets / BI tools as applicable).

Use pivot tables, lookup formulas, conditional formatting, sumifs/countifs etc. to summarise and transform raw data.

Perform variance analysis: compare actual vs forecast/budget, identify trends, anomalies, risks, and opportunities.

Respond to ad‑hoc requirements: prepare special reports, assist different departments with their data needs.

Automate repetitive reporting tasks wherever possible (macros/scripts/templates) to improve efficiency.

Maintain documentation of MIS processes, report definitions and data flows.

Ensure that deadlines for report submission are met and report formats are consistent and easy to understand.

Qualifications & Experience

Bachelor’s Degree in Mathematics, Statistics, Commerce, Economics, Business Administration or a related quantitative field.

3‑5 years of experience specifically in MIS / Data Analysis / Reporting roles.

Strong mathematical foundation; ability to work with numbers, ratios, trend lines, forecasting etc.

Skills & Competencies

Technical / Hard Skills:

Thorough knowledge of Excel and Google Sheets: advanced formulas, functions, formatting etc.

Proficiency in Pivot Tables: building and modifying, using with charts & dashboards.

Strong skills in lookup functions (VLOOKUP / HLOOKUP / INDEX‑MATCH etc.), conditional formatting, sumifs/countifs etc.

Ability to automate tasks (macros, scripts, template designs) is a plus.

Familiarity with data validation, cleaning, and consolidation techniques.

Good understanding of BI / Dashboard tools will be a plus (e.g. Google Data Studio, Power BI etc.).

Analytical / Soft Skills:

Strong analytical mindset, attention to detail, ability to identify patterns, inconsistencies.

Ability to translate raw data into clear, actionable insights; good presentation skills.

Time management: able to handle multiple reports, prioritize, and meet tight deadlines.

Good communication skills: able to present findings to non‑technical stakeholders.

Proactive, able to suggest improvements to MIS/reporting processes.

Desired Personal Attributes

High level of accuracy and diligence.

Methodical approach; strong organizational skills.

Integrity and ability to handle confidential/important data.

Problem solving attitude; curiosity to understand underlying causes behind data trends.

Additional / Nice‑to‑Have (Optional)

Experience with scripting or formula automation (macros, Google Apps Script).

Exposure to database querying (SQL or similar).

Some experience with BI visualization tools (Power BI, Tableau, etc.).

Prior experience in your industry (e.g. manufacturing / retail / IT / services) if relevant.