Sweet Karam Coffee - Senior Data Analyst - eCommerce (3-8 yrs)

About Sweet Karam Coffee:

- At Sweet Karam Coffee, we are passionate about bringing traditional South Indian flavors to global audience through innovation and quality. Sweet Karam Coffee offers preservative-free, handcrafted delicacies, preserving the rich culinary heritage of South India redefining tradition snacking with innovation and authenticity.

- You'll be part of a dynamic, fast-paced work environment where innovation, creativity, and teamwork are at the heart of everything we do.Role Overview:We're seeking a Senior E-commerce Data Analyst to drive profitable growth through deep da insights. This role focuses on analyzing D2C metrics at a cohort level, improving conversion rates, optimizing product sell-through, and conducting LTV and basket analyses. You will collaborate cross-functionally, work on profit-focused projects, and guide strategic decisio that impact Sweet Karam Coffee's P&L.

Key Responsibilities:- Perform cohort analyses to track customer behavior, retention, and profitabilit

- Analyze product performance and sell-through rates to optimize inventory and margins.

- Calculate and interpret customer lifetime value (LTV) for budgeting and acquisition.

- Conduct basket analyses to identify cross-selling and upselling opportunities.

- Create and maintain dashboards for real-time and periodic performance reporting.

- Identify areas to improve conversion funnels and reduce drop-offs.

- Collaborate with cross-functional teams (Marketing, Operations, Finance) on data-driven projects.

- Suggest initiatives that enhance profitability (P&L) based on analytical insight

- Present clear, actionable recommendations to leadership and stakeholders.

Qualifications & Experience:- Bachelor's degree in Business, Economics, Statistics, Mathematics, Computer Science, or related field

- 2-4 years of experience in e-commerce analytics or a related analytical role.

- Strong proficiency in Google Analytics/GA4, SQL, Excel, and data visualization tools (e.g Tableau, Power BI).

- Proven track record in cohort analysis, LTV calculation, and optimizing conversion funnels.

- Excellent communication skills, with an ability to convey complex data insights succinctly.

Top Skills Required:

1. Cohort Analysis & LTV

2. E-commerce Metrics Mastery (conversion rates, sell-through, basket analysis)

3. Data Tools (Google Analytics/GA4, SQL, Excel, BI tools)

4. Statistical & Quantitative Analysis

5. Communication & Stakeholder Management

6. Problem-solving & Critical Thinking

7. Cross-functional Collaboration

Your work will involve:

1. Weekly/Monthly E-commerce Performance Dashboards

2. Cohort Retention & P&L Impact Reports

3. Product Sell-Through & Margin Analysis

4. Customer Lifetime Value (LTV) & Profitability Forecas

5. Basket Analysis & Upsell/Cross-Sell Insights

6. Conversion Funnel Diagnostics

7. Pricing & Promotion Impact Studies

8. Marketing Campaign Performance & ROI Analysis

9. Customer Segmentation & Profit Contributi

10. A/B Test Summaries & Recommendations

11. Churn & Retention Models

12. Inventory Forecasts & Demand Planning

13. Cost Optimization Analyses

14. New Product Launch Performance & P&L Projection