Business Analyst

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

Job summary

Marico Limited in Mumbai is seeking a Business Analytics professional to drive performance insights across e-commerce, D2C, and modern trade. You will build and maintain dashboards, analyze customer metrics, and quantify the impact of promotions and pricing on margins.

The ideal candidate has a B.Tech/B.E., 1–3 years in business or data analytics, strong SQL and advanced Excel, and proficiency in Power BI, Tableau, or Looker.

Qualifications

• 1-3 years of experience in Business Analytics/Data Analytics.
• Strong SQL and Advanced Excel skills.
• Proficiency in Power BI, Tableau, or Looker.

Responsibilities

• Track and analyze sales/offtake performance across channels (E-commerce, D2C, Modern Trade).
• Build and maintain channel-level performance dashboards.
• Analyze CAC, CLTV, retention, and cohort performance; identify growth opportunities.

Skills

SQL

Advanced Excel

Power BI

Tableau

Looker

Education

B.Tech/B.E.

Tools

Power BI

Tableau

Looker

SQL

Job description

1. Business Performance & Offtake Analytics

• Track and analyze sales/offtake performance across channels (E-commerce, Quick Commerce, D2C, Modern Trade, etc.).
• Identify trends, growth drivers, and performance gaps through data-driven analysis.
• Generate actionable insights to support category and business growth initiatives.

2. Channel Performance Management

• Build and maintain channel-level performance dashboards.
• Evaluate channel contribution, growth, profitability, and efficiency metrics.
• Recommend interventions to improve channel ROI and performance.

3. Customer Analytics & Acquisition Effectiveness

• Monitor and analyze key customer metrics including:
• Customer Acquisition Cost (CAC)
• Customer Lifetime Value (CLTV/LTV)
• Repeat Purchase Rate
• Retention and Cohort Performance
• Identify opportunities to improve customer acquisition efficiency and retention.

4. Gross Contribution & Profitability Analysis

• Track Gross Contribution (GC) and profitability across products, channels, and customer segments.
• Assess the financial impact of promotions, discounts, and pricing decisions.
• Partner with business teams to optimize margin performance.
• Develop business simulations and what-if models to evaluate:
• Discount structures
• Promotional investments
• Customer acquisition strategies
• Support leadership in making data-backed commercial decisions.
• Build automated dashboards using Power BI, Tableau, Looker, or equivalent tools.
• Translate complex datasets into clear business insights and executive-ready recommendations.
• Enable faster decision-making through accurate and timely reporting.

7. AI-Enabled Analytics

• Leverage AI tools for data gathering, analysis, forecasting, and insight generation.
• Improve productivity by automating repetitive analytical tasks.
• Identify emerging opportunities through AI-assisted trend analysis.

Ideal Candidate Profile

• B.Tech/B.E.
• 1-3 years of experience in Business Analytics/Data Analytics.
• Strong SQL and Advanced Excel skills.
• Proficiency in Power BI, Tableau, or Looker.
• Experience in high-growth consumer internet/startup environments in the beauty, wellness, personal care space
• Strong commercial acumen with the ability to connect data insights to business outcomes.
• Comfortable building financial models, simulations, and decision-support frameworks.