We are seeking a highly analytical and detail-oriented Data Analyst with experience in D2C, e-commerce, or marketplace businesses. The ideal candidate will have strong expertise in marketing analytics, business intelligence, SQL, GA4, and dashboarding tools. This role will be responsible for building a unified data ecosystem, tracking business performance, identifying growth opportunities, and enabling data-driven decisions across multiple business functions.
Key Responsibilities
1. Data Integration & Infrastructure
- Integrate and manage data from Shopify, Amazon Seller Central, Flipkart, Myntra, Nykaa Fashion, Zepto, and other sales channels.
- Connect marketing data from GA4, Meta Ads, Google Ads, CRM platforms, influencer tools, email/SMS platforms, and inventory systems.
- Build and maintain a unified marketing data layer providing complete visibility into customer acquisition, engagement, conversion, and retention.
- Improve data automation and streamline reporting processes.
2. Marketing Performance Analytics
- Track and analyze performance across Performance Marketing, Influencer Marketing, CRM, Organic/Social Media, and Marketplace Advertising.
- Monitor and report key business metrics including:
- Customer Acquisition Cost (CAC)
- Return on Ad Spend (ROAS)
- Conversion Rate
- Customer Lifetime Value (LTV)
- Contribution Margin
- Repeat Purchase Rate
- Marketing ROI
- Payback Period
- Prepare daily, weekly, and monthly business performance reports for stakeholders.
3. Funnel, Cohort & Retention Analysis
- Perform website and marketplace funnel analysis to identify conversion bottlenecks.
- Conduct cohort analysis based on acquisition channel, campaign, product category, platform, and purchase period.
- Analyze customer retention, repeat purchases, buying frequency, and lifecycle performance.
- Recommend strategies to improve customer engagement and retention.
4. Customer Segmentation & CRM Analytics
- Build actionable customer segments such as:
- High-LTV Customers
- Repeat Buyers
- Cart Abandoners
- Dormant Customers
- First-Time Buyers
- Campaign Cohorts
- Support CRM and marketing teams with audience insights for targeted campaigns and personalization.
- Help optimize marketing spend through data-driven audience selection.
5. Marketplace Analytics
- Analyze marketplace performance including:
- Product Listing Performance
- Advertising Efficiency (ROAS & TACoS)
- Pricing & Discount Impact
- Inventory Availability
- Stock-Out Analysis
- Fill Rate
- Organic vs Paid Sales Performance
- Monitor competitor activity and identify market opportunities.
- Collaborate with marketplace and supply chain teams to improve sales performance.
6. Experimentation & Optimization
- Support A/B testing across:
- Landing Pages
- Product Detail Pages (PDPs)
- Checkout Flow
- Creative Assets
- Promotions
- Pricing Strategies
- Define success metrics and analyze experiment outcomes.
- Drive continuous optimization through data-backed recommendations.
7. Dashboards & Business Reporting
- Build and maintain automated dashboards using BigQuery, Looker, Tableau, or Power BI.
- Translate complex datasets into clear, actionable insights.
- Support leadership with forecasting, budgeting, and strategic planning.
- Present business performance to cross-functional stakeholders.
8. Data Quality & Governance
- Ensure data accuracy, consistency, and reliability.
- Develop validation checks and automate data quality monitoring.
- Identify gaps in tracking, attribution, and reporting.
- Maintain proper documentation for reporting processes.
Required Skills & Qualifications
Experience
- 2+ years of experience as a Data Analyst in D2C, E-commerce, Retail, or Marketplace businesses.
- Strong hands-on experience with Google Analytics 4 (GA4), including event tracking, funnel analysis, and attribution.
- Advanced SQL skills.
- Excellent knowledge of Microsoft Excel / Google Sheets.
- Working knowledge of Python for automation, ETL, or data analysis is preferred.
- Experience with BigQuery, Looker, Tableau, or Power BI.
Business & Marketing Knowledge
- Strong understanding of:
- Customer Acquisition Cost (CAC)
- ROAS
- Customer Lifetime Value (LTV)
- Funnel Analysis
- Cohort Analysis
- Retention Metrics
- Contribution Margins
- Marketing Attribution
- Familiarity with Shopify, Meta Ads, Google Ads, CRM platforms, and Marketplace Advertising.
- Excellent analytical, communication, and stakeholder management skills.