Role Overview The candidate will be responsible for managing and analysing data across all business functions, including Sales, Operations, Accounts, Finance, HR, Inventory, Marketing and Business Development.

The person should be capable of taking raw and unstructured data, cleaning and organising it, building automated reports and interactive dashboards, and presenting meaningful business insights to management.

Key Responsibilities

1. MIS Reporting & Dashboard Development

- Develop daily, weekly and monthly MIS reports from scratch.
- Build interactive dashboards using Microsoft Excel, Google Sheets and Power BI.
- Create automated reporting systems to minimise manual work.
- Consolidate data from multiple outlets and departments.
- Develop centralised business performance dashboards for management.

2. Sales & Outlet Performance Analytics

- Analyse outlet-wise sales, revenue, average order value and sales growth.
- Track daily, weekly and monthly outlet performance.
- Compare outlet performance and identify high-performing and underperforming stores.
- Analyse product-wise sales, category performance and customer trends.
- Develop sales forecasting and performance tracking reports.

3. Finance & Cost Analysis

- Analyse food costs, operating expenses and outlet profitability.
- Prepare expense tracking and budget-versus-actual reports.
- Monitor outlet-wise revenue, expenses and contribution margins.
- Identify unusual variations and potential cost-saving opportunities.

4. Operations & Inventory Analytics

- Develop reports for inventory, procurement, stock movement and wastage.
- Analyse product consumption and food-cost variations.
- Track operational KPIs and outlet performance.
- Identify operational gaps through data analysis.

5. HR & Employee Analytics

- Develop attendance, payroll, employee strength and attrition dashboards.
- Analyse employee productivity and manpower costs.
- Prepare outlet-wise staffing and employee performance reports.

6.



Business Intelligence & Management Reporting

- Convert raw data into meaningful business insights.
- Identify trends, patterns, discrepancies and business opportunities.
- Prepare management presentations and performance summaries.
- Provide data-backed recommendations to management.
- Handle ad-hoc reporting and analytical requirements across departments.

Required Technical Skills

Mandatory:

- Advanced Microsoft Excel.
- Advanced Google Sheets.
- Pivot Tables, Pivot Charts, XLOOKUP, VLOOKUP, INDEX-MATCH.
- SUMIFS, COUNTIFS, IF, nested formulas and other advanced functions.
- Data cleaning, data validation and data consolidation.
- Dashboard creation from scratch.
- Solid analytical and problem-solving abilities.

Strongly Preferred:

- Microsoft Power BI.
- Power Query and data modelling.
- DAX and calculated measures.
- Google Looker Studio.
- Basic SQL and database management.
- Reporting automation and workflow optimisation.
- Experience working with Slack and collaborative reporting systems.

Educational Qualification
- Bachelor's degree in B.Com, BBA, BCA, B.Sc Statistics, Mathematics, Computer Science or any relevant discipline.
- Additional certification in Data Analytics, Business Intelligence, Power BI or Advanced Excel will be an advantage.

Experience Requirements

- 24 years of experience in MIS, Business Intelligence, Data Analytics or Management Reporting.
- Experience handling multiple datasets and preparing management dashboards.
- Experience working with multiple departments or business units.
- Experience in retail, QSR, FMCG, hospitality or multi-outlet businesses will be preferred.

What We Expect From the Candidate

- Ability to independently build a dashboard without depending on pre-existing templates.
- Ability to understand business requirements and translate them into reports.
- Strong numerical accuracy and attention to detail.
- Ability to handle large datasets.
- Good communication and coordination skills.
- Ability to present findings to senior management.
- Ownership, accountability and timely delivery of reports.

📌 Business Intelligence Analyst (Kolkata)
🏢 Caribbean Foodbay
📍 Kolkata