Business Intelligence Analyst

Caribbean Foodbay; Kolkata District; On-site; INR 600,000 - 900,000; Full time

Job summary

Caribbean Foodbay is seeking a data analytics professional to manage MIS reporting and build interactive dashboards. You will clean and organise raw data, consolidate across outlets, and deliver management-ready insights across Sales, Operations, Finance, HR and Inventory.

You will develop automated reports, track outlet performance, and support cost analysis, budgeting and procurement analytics to drive business decisions.

Qualifications

• Bachelor level degree in commerce, management, statistics, CS or related field.
• Certification in Data Analytics or BI is a plus.
• Strong numerical accuracy and data storytelling abilities.

Responsibilities

• Develop MIS reports and dashboards from scratch on daily/weekly/monthly cadence.
• Consolidate data across outlets and departments for performance visibility.
• Analyze sales, finance, operations, HR and inventory data for insights.
• Create automated reporting to minimise manual work.
• Present insights to management with actionable recommendations.

Skills

Analytical thinking

Data cleaning

Attention to detail

Communication

Presentation

Independent dashboard building

Education

B.Com / BBA / BCA / BSc Statistics / Mathematics / CS

Data Analytics / BI Certification

Tools

Microsoft Excel

Google Sheets

Power BI

Power Query

DAX

SQL (basic)

Google Looker Studio

Job description

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.
• Strong 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.