We are looking for a Business Intelligence & MIS Analyst who can convert business data into clear dashboards, graphs, insights and actionable recommendations for management.
The role is not limited to preparing reports. The candidate should be able to study business data, identify trends and problems, and clearly explain:
What is happening → Why it is happening → What action management should take.
Key Responsibilities
1. Business Performance Analysis
- Analyse daily, weekly and monthly business performance.
- Track sales, orders, revenue, returns, cancellations and other key KPIs.
- Compare performance across Amazon, Flipkart, Meesho, JioMart, B2B and other channels.
- Identify growth and decline trends.
2. Product & SKU Analysis
- Identify top-selling and low-selling products.
- Analyse SKU-wise sales trends.
- Identify fast-moving and slow-moving products.
- Identify products where sales are falling.
- Compare product performance across marketplaces.
- Highlight products requiring pricing, listing, advertising, stock or other action.
3. Profitability Analysis
- Analyse product-level revenue, cost and margin where data is available.
- Identify high-revenue but low-margin products.
- Identify products/categories contributing most to profit.
- Highlight unusual margin changes.
4. Inventory Analysis
- Analyse stock movement.
- Identify fast-moving and slow-moving inventory.
- Identify ageing and excess inventory.
- Highlight potential stock-out situations.
- Provide recommendations for replenishment and inventory action.
5. Marketplace Analysis
- Compare Amazon, Flipkart, Meesho, JioMart and other channels.
- Identify which marketplace/products are performing better or worse.
- Analyse returns, cancellations and order trends.
- Highlight unusual changes requiring investigation.
6. Sales Team Analysis
- Track salesperson-wise leads, orders, conversion and revenue.
- Compare team/member performance.
- Identify performance gaps and improvement opportunities.
- Create management reports for the sales team.
7. Management Dashboards
Build and maintain easy-to-understand dashboards using:
- Power BI
- Advanced Excel
- Google Sheets / Looker Studio where required
Dashboards should clearly show:
- What is performing well
- What is declining
- What requires attention
- Recommended action
8. Automated Reporting
- Reduce manual report preparation.
- Connect and consolidate data from Excel, Google Sheets, marketplace reports and other business systems.
- Standardise recurring MIS reports.
- Maintain accurate and reliable data.
9. Management Insights
The candidate must not simply submit numbers.
Every important report should highlight:
- Key finding
- Problem / opportunity
- Possible reason
- Recommended action
- Priority
Example of Expected Output
Instead of:
"Product ABC sales = 1,240 units."
The analyst should be able to report:
"ABC 5 KG is currently the highest-selling SKU. Sales increased 22% over the previous period. Stock cover is low. Recommended action: replenish stock immediately and review whether additional inventory should be allocated."
Required Skills
- Advanced Microsoft Excel
- Pivot Tables
- XLOOKUP / VLOOKUP
- INDEX-MATCH
- SUMIFS / COUNTIFS
- Power Query
- Excel dashboards
- Power BI
- Basic DAX
- Data cleaning and validation
- KPI analysis
- Business reporting
- Data visualization
- Strong analytical thinking
Good to Have
- Basic SQL
- Looker Studio
- Google Sheets automation
- E-commerce analytics experience
- Amazon / Flipkart / Meesho analytics experience
- ERP / inventory software experience
- Experience with CRM data
- Experience using AI tools such as ChatGPT/Gemini for analysis and reporting
Candidate Profile
We are looking for someone who:
- Enjoys working with numbers and business data.
- Can identify unusual trends and problems.
- Can explain data in simple business language.
- Can create professional dashboards.
- Can independently investigate why a number changed.
- Is comfortable communicating findings directly to management.
- Thinks beyond "report banana hai" and focuses on "business mein kya action lena hai."
Qualification
Bachelor's degree in any relevant field such as:
- B.Com
- BBA
- BCA
- B.Sc
- Statistics
- Mathematics
- Economics
- Business Analytics
- Data Analytics
- Engineering
Relevant practical experience and skills will be given more importance than the exact degree.
Experience
2–5 years preferred.
Candidates with 1–2 years of strong hands-on Power BI + Advanced Excel + business reporting experience may also be considered.
Work Location
Fazilka, Punjab
Working Mode
Work From Office
Reporting To
Management
Important
This is a business-facing analytics role.
The successful candidate will be expected to convert data into:
Dashboard → Insight → Recommendation → Action
Pay: ₹15,000.00 - ₹40,000.00 per month
Work Location: Remote
