• Full Time
  • Mumbai

Website Mcaffine

Business Analyst – mCaffeine

Opportunity Overview

Attribute Details
Organization mCaffeine (PEP Technologies – D2C Personal Care & Beauty Brand)
Position Title Business Analyst
Primary Location Mumbai, Maharashtra, India
Department / Practice Business Intelligence & Growth Analytics
Employment Type Full-Time, Permanent
Target Sector Direct-to-Consumer (D2C), FMCG, E-Commerce & Retail
Core Technical Stack Advanced SQL, Advanced Excel / Google Sheets, Power BI / Tableau, E-Commerce Analytics platforms

D2C E-Commerce & Growth Analytics Workflow

The Business Analyst at mCaffeine operates across cross-functional commercial teams to optimize digital acquisition channels, inventory replenishment cycles, and customer lifetime value:

┌───────────────────────────────────────────┐
│ 1. Multi-Channel Data Aggregation         │ ➔ Ingest data across Shopify, Amazon, Flipkart, Nykaa, & quick-commerce platforms
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. Unit Economics & Retention Modeling    │ ➔ Evaluate CAC, LTV, repeat purchase rates, cohort performance, & promotional ROAS
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Inventory & Supply Chain Alignment     │ ➔ Track SKU velocity, stockout risks, & fulfillment metrics across regional warehouses
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. BI Dashboarding & Executive Alignment  │ ➔ Deploy automated dashboards to optimize marketing spend & product margin strategies
└───────────────────────────────────────────┘

Key Responsibilities

  • Multi-Channel Performance Tracking: Analyze daily sales, conversion funnels, and marketing performance across native web store (Shopify) and marketplace channels (Amazon, Nykaa, Flipkart, Blinkit).

  • Unit Economics & Cohort Analysis: Track customer acquisition costs (CAC), payback periods, retention rates, and cohort-based LTV to guide growth spend.

  • Inventory & Demand Forecasting: Partner with supply chain teams to model SKU demand trends, safety stock levels, and regional warehouse replenishment routines.

  • Interactive Dashboard Design: Build and maintain automated reports in Power BI, Tableau, or Google Looker Studio tracking core brand KPIs.

  • Cross-Functional Growth Strategy: Translate raw sales and marketing metrics into operational recommendations for product launches, pricing structures, and discount strategies.

Qualification Matrix & Technical Skill Stack

Core Requirements

Category Specifications
Educational Background Bachelor’s degree in Engineering, Business Analytics, Statistics, Economics, or related fields.
Domain Experience Experience or strong domain exposure to D2C e-commerce, FMCG, beauty/personal care, or retail marketplace analytics.
Database & Analytics Strong proficiency in SQL for multi-table data extraction, joining, and aggregation.
Spreadsheet Engineering Advanced Excel / Google Sheets skills (pivot tables, complex nested formulas, data modeling).
Data Visualization Hands-on experience constructing interactive dashboards using Power BI, Tableau, or Looker Studio.

Key Focus Areas for Interview Preparation

  1. D2C & E-Commerce Metrics: Practice calculating key metrics like ROAS, Blended CAC, AOV (Average Order Value), Customer Retention Rate, and Repeat Purchase Frequencies.

  2. SQL Scenario Coding: Be prepared to write queries for cohort analysis, active user retention tracking, and regional SKU sales comparisons.

  3. Inventory & Supply Chain Analytics: Review concepts surrounding Days of Inventory (DOI), Stockout Rate, Order Fulfillment Lead Time, and Return-to-Origin (RTO) Percentage.

To apply for this job please visit remotejobhiring.com.