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.
- Solid 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.
- Strong 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)
🏢 Webbee Esolutions Private
📍 Noida