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. Solid knowledge of
Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH,
SUMIFS/COUNTIFS, IF/IF

📌 MIS Executive (Noida)
🏢 WebBee esolutions
📍 Noida