Business Analyst / Senior Business Analyst – mCaffeine & Hyphen (PEP)

PEP Personal Care Analytics (mCaffeine & Hyphen). Source: Narongrit Doungmanee / Getty Images

Company: PEP (Parent Company of mCaffeine & Hyphen)

Role Title: Business Analyst / Senior Business Analyst

Location: Mumbai, Maharashtra, India

Employment Type: Full-time

Experience Required: 2 to 5 Years

Education Target: Bachelor’s Degree in Quantitative Discipline (Tier 1 Institute)

Core Tool Stack: SQL, Advanced Excel, Python (Data Analysis/Automation), Power BI, Tableau, Looker, BigQuery, Snowflake

About PEP (mCaffeine & Hyphen)

PEP is a personal care enterprise housing two consumer brands: mCaffeine, India’s first caffeinated personal care brand, and Hyphen, a science-backed skincare brand co-founded with Kriti Sanon. Operating across direct-to-consumer (D2C) channels, major e-commerce marketplaces (Amazon, Flipkart, Nykaa), and quick-commerce platforms (Blinkit, Zepto, Instamart), PEP combines data science with consumer insights to scale modern personal care brands.

Role Overview

PEP is recruiting a Business Analyst / Senior Business Analyst at its corporate headquarters in Mumbai.

Sitting at the intersection of business strategy, growth, supply chain, finance, and product analytics, this role focuses on converting complex multi-channel e-commerce datasets into strategic growth decisions. You will partner with business leads to build scalable KPI tracking frameworks, run customer cohort retention deep-dives, optimize supply chain efficiency, and automate reporting pipelines across the mCaffeine and Hyphen product portfolios.

Key Responsibilities

• Business Strategy & Problem Solving: Partner with leadership to translate operational challenges into structured analytical frameworks, root-cause analyses, and data-backed interventions.

• E-Commerce & D2C Deep-Dives: Conduct end-to-end analyses on customer retention, CAC/LTV dynamics, marketing performance, SKU-level profitability, and quick-commerce fulfillment.

• Dashboarding & Automation: Design, build, and maintain automated KPI dashboards using Power BI, Tableau, or Looker to track sales, inventory turnover, and conversion rates.

• Cross-Functional Enablement: Collaborate with Product, Engineering, Growth, Operations, and Finance teams to specify functional metrics and implement scalable analytics pipelines.

• Data Governance & Data Quality: Establish reporting standards, dataset schemas, and validation routines across data warehouses (BigQuery, Snowflake, AWS).

Candidate Qualifications & Requirement Summary

Core Qualifications

• Experience Level: 2 to 5 years of experience in Business Analytics, Business Intelligence, Product Analytics, or Business Analysis.

• Preferred Industry: D2C, E-commerce, Retail, FMCG, Consumer Tech, or high-growth startup ecosystems.

• Education: Bachelor’s degree in Engineering, Mathematics, Statistics, Economics, Business, or a quantitative discipline from a Tier 1 Institute.

Technical Tooling & Competencies

• Querying & Data Manipulation: Deep proficiency in SQL and Advanced Excel (pivots, array formulas, data modeling).

• Programming & Automation: Hands-on experience with Python for data manipulation (Pandas, NumPy) and workflow automation is highly preferred.

• BI Visualization: Demonstrated capability building production dashboards in Tableau, Power BI, or Looker.

• Data Warehousing Exposure: Familiarity with modern cloud data warehouses like Google BigQuery, Snowflake, or AWS Redshift.

What PEP Offers

• High Ownership Culture: Direct influence on strategic growth decisions across two high-visibility consumer brands.

• E-Commerce Scale: Direct access to massive multi-channel datasets spanning D2C, quick-commerce platforms, and traditional retail.

• Fast-Paced Startup Environment: Collaborative, flat organization built on data transparency and rapid execution.

Role Summary