Key Responsibilities

1. MIS & Management Reporting

- Prepare daily, weekly, monthly and quarterly MIS reports.

- Develop operational, sales, financial, HR and
performance reports.

- Consolidate data from Sales, Marketing and other departments.

- Prepare dashboards, KPI reports and variance analysis.

- Ensure accurate and timely reporting.

2. Data Management & Analysis

- Collect, consolidate, validate and reconcile data
from multiple sources.

- Identify data discrepancies and coordinate corrections.

- Analyse data to identify trends, gaps and business insights.

- Maintain structured databases and reporting templates.

- Ensure data accuracy, integrity and confidentiality.

3. Excel & Dashboard Management

- Create advanced Excel reports using Pivot
Tables/Charts, XLOOKUP/VLOOKUP, INDEX-MATCH,
SUMIFS/COUNTIFS and IF/IFS.

- Develop charts, dashboards, conditional formatting
and data validation.

- Use
Power Query for data extraction and consolidation.

- Develop automated reporting templates to reduce
manual effort.

- Knowledge of Power BI is an advantage.

4. KPI & Performance Tracking

- Maintain KPI and target trackers.

- Prepare Actual vs. Target, MoM and YoY analysis.

- Identify performance gaps and highlight key deviations.

- Provide data-backed insights for corrective action.

5. Process Improvement & Automation

- Identify manual/repetitive reporting tasks for automation.

- Standardize reporting formats and improve reporting processes.

- Reduce turnaround time and reporting errors.

- Maintain reporting documentation and version control.

6. Coordination & Stakeholder Management

- Coordinate with Sales, Operations, Finance, HR and
Business Development teams.





- Follow up for pending or incorrect data.

- Understand business requirements and create
meaningful reports.

- Handle ad-hoc reporting and management requirements.

Requirements

Required Skills

- Advanced MS Excel – Mandatory. Strong knowledge of
Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH,
SUMIFS/COUNTIFS, IF/IFS, Charts & Dashboards.

- Power Query – Preferred, Power BI – Advantage

- Basic SQL/database knowledge is an advantage.

- Strong data cleaning, analysis and reporting skills.

Analytical Skills

- Strong analytical and problem-solving ability.

- Ability to work with large datasets.

- Good
attention to detail.

- Ability to identify discrepancies and investigate
data issues.

- Ability to convert raw data into meaningful
management insights.

Soft Skills

- Good
communication and interpersonal skills.

- Strong follow-up and coordination skills.

- Ability to manage multiple reports and deadlines simultaneously.

- High
level of accuracy and ownership.

- Ability to work independently with minimal supervision.

- Solid organizational and time-management skills.

Experience & Qualification

Experience:

- 3–4
years of relevant experience in MIS, Business Reporting, Data
Analysis, Operations Analytics or a similar role.

- Experience in preparing management dashboards and
recurring MIS reports.

- Experience working with large datasets and multiple
data sources.

- Experience in reporting automation will be an advantage.

Education:

- Bachelor’s degree: Commerce, Business
Administration, Statistics, Mathematics, Computer
Applications, Economics, Engineering or a related field.

- MBA/PGDM or relevant analytical certification is an advantage.

📌 MIS Executive (Noida)
🏢 Nameless
📍 Noida