The Role
Prepare recurring MIS, management, KPI, variance, and performance reports; consolidate and validate data from multiple departments; analyze trends and discrepancies; maintain dashboards, trackers, databases, and reporting templates; automate repetitive reporting using advanced Excel and Power Query; coordinate data corrections and provide insights for business decisions.
Summary Generated by Built In
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.
- 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.
Skills Required
- Advanced Microsoft Excel, including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, IF/IFS, charts, and dashboards
- Strong data cleaning, analysis, and reporting skills
- Strong analytical and problem-solving ability
- Ability to work with large datasets and multiple data sources
- Attention to detail and ability to identify and investigate data discrepancies
- Ability to convert raw data into meaningful management insights
- Good communication, interpersonal, follow-up, and coordination skills
- Ability to manage multiple reports and deadlines simultaneously
- Ability to work independently with minimal supervision
- Strong organizational and time-management skills
- Three to four years of relevant experience in MIS, business reporting, data analysis, operations analytics, or a similar role
- Experience preparing management dashboards and recurring MIS reports
- Experience working with large datasets and multiple data sources
- Bachelor's degree in Commerce, Business Administration, Statistics, Mathematics, Computer Applications, Economics, Engineering, or a related field
- Power Query
- Power BI
- Basic SQL or database knowledge
- Experience in reporting automation
- MBA, PGDM, or relevant analytical certification
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
WebBee Global is a SaaS-based e-commerce integration and ERP solutions provider. Its software connects online sales channels and marketplaces with fulfillment networks such as Amazon MCF and 3PLs, automating order management, inventory synchronization, fulfillment, and shipping updates. The company also supports NetSuite ERP integrations with major commerce platforms, helping B2B and B2C brands build connected, scalable, and efficient multichannel e-commerce operations.
