Business Analyst

mCaffeine; Mumbai; On-site; INR 600,000 - 1,200,000; Full time

Job summary

mCaffeine & Hyphen is seeking a data-driven Business Analyst to turn numbers into strategic decisions across growth, supply chain, finance, product, and customer experience.

You will partner with leaders to define problems, build dashboards, and deliver insights that influence priorities and improve business outcomes. The role blends business, data, and technology in a fast-paced startup environment with opportunities to automate processes.

Qualifications

• 2-5 years of experience in Business Analytics, BI, or Product Analytics in D2C/E‑commerce/Startup environments.
• Strong SQL and Excel; Python preferred for analysis and automation.
• Experience building dashboards and reports with BI tools (Tableau/Power BI/Looker).

Responsibilities

• Partner with leadership to identify opportunities and drive data‑backed decisions.
• Translate requirements into analytical frameworks, specs, and solutions.
• Analyze large datasets to uncover trends and inform strategy.
• Design, build, and maintain dashboards and KPI tracking.
• Lead end‑to‑end analytics projects from gathering to impact assessment.

Skills

SQL

Advanced Excel

Python

Education

Bachelor's degree in Engineering, Mathematics, Statistics, Economics, Business, or related quantitative field from a Tier 1 Institute

Tools

Tableau

Power BI

Looker

Job description

PEP is a dynamic personal care company that proudly houses two innovative brands – mCaffeine & Hyphen. With a passion for creating high-performance, conscious, and consumer-loved products, we are redefining the way personal care is experienced. While mCaffeine is India’s first caffeinated personal care brand, loved for its energizing and playful approach, Hyphen is built on the philosophy of simplifying skincare through science-backed formulations. Together, our brands reflect PEP’s mission to deliver quality, creativity, and care to millions of consumers. We believe in Confidence over all skin & body biases.

Come, join the pack!

About the Role

At mCaffeine & Hyphen, we're looking for a Business Analyst / Senior Business Analyst who can transform data into strategic business decisions. This role sits at the intersection of business, data, technology, and operations, driving key initiatives across growth, supply chain, finance, product, and customer experience functions.

As a trusted partner to business leaders, you will identify opportunities, solve complex business problems, build scalable reporting frameworks, and influence decision-making through actionable insights. If you thrive in fast-paced environments, enjoy working with ambiguity, and are passionate about using data to create business impact, we'd love to meet you.

What You'll Do

• Partner with leadership and cross-functional teams to identify business opportunities, define problem statements, and drive data-backed decision-making.
• Translate business requirements into structured analytical frameworks, functional specifications, and actionable solutions.
• Analyze large and complex datasets to uncover trends, diagnose business challenges, and recommend strategic interventions.
• Design, build, and maintain dashboards, automated reports, and KPI tracking mechanisms to provide visibility into business performance.
• Drive end-to-end analytics projects, from requirement gathering and stakeholder alignment to execution and impact measurement.
• Collaborate closely with Product, Engineering, Growth, Operations, and Finance teams to implement scalable business solutions.
• Identify process inefficiencies and champion automation initiatives to improve operational effectiveness and decision-making speed.
• Conduct deep-dive analyses on customer behavior, marketing performance, retention, supply chain, and business profitability metrics.
• Establish data governance, reporting standards, and best practices to improve data quality and reliability across the organization.
• Present insights and recommendations to senior stakeholders in a clear, concise, and business-friendly manner.

What We're Looking For

• 2- 5 years of experience in Business Analytics, Business Intelligence, Product Analytics, or Business Analysis roles, preferably in D2C, E-commerce, FMCG, Consumer Tech, or Startup environments.
• Strong proficiency in SQL and advanced Excel; hands-on experience with Python for data analysis and automation is preferred.
• Experience building dashboards and reports using BI tools such as Tableau, Power BI, Looker, or similar platforms.
• Strong problem-solving and structured thinking abilities with a proven track record of driving business impact through data.
• Ability to work with large datasets, perform root-cause analysis, and translate findings into actionable business recommendations.
• Experience gathering business requirements and collaborating with technical teams to drive implementation.
• Excellent stakeholder management and communication skills, with the ability to influence decisions across technical and non-technical audiences.
• High ownership, bias for action, and the ability to thrive in a fast-paced, entrepreneurial environment.
• Bachelor's degree in Engineering, Mathematics, Statistics, Economics, Business, or a related quantitative field from a Tier 1 Institute.

Preferred Experience

• Experience working with D2C, E-commerce, Retail, Consumer Brands, or high-growth startup ecosystems.
• Exposure to customer analytics, marketing analytics, supply chain analytics, or product analytics.
• Familiarity with data warehousing concepts and cloud platforms such as BigQuery, Snowflake, or AWS.