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. Robust knowledge of Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF/IFS, Charts & Dashboards.
Power Query – Preferred, Power BI – Ad

📌 MIS Executive (Noida)
🏢 Webbee Esolutions Private
📍 Noida