Data Analyst – E-commerce & D2C

Job Title:

Location:

Experience:

Reporting to:

Role Summary

client

hands-on Data Analyst

end-to-end analytics

not a reporting-only role

Key Responsibilities

Data & Pipelines

• Extract data from marketplaces, D2C platforms, ad channels, CRM, and inventory systems
• Build and maintain automated ETL pipelines using Python and SQL
• Manage centralized data warehouse (BigQuery or similar)
• Ensure data accuracy, refresh schedules, and reliability
  

Analytics & Metrics

• Own key KPIs: ROAS, ACOS, TACOS, contribution margin, CLTV, CAC, retention, inventory health, revenue forecasts
• Standardize metric definitions across teams
• Build models for forecasting, profitability, and performance analysis
  

Dashboards & Reporting

• Build dashboards in Power BI / Looker Studio for:
• Marketplace performance
• Ads & PPC performance
• D2C funnel & retention
• Inventory and leadership views
• Automate daily, weekly, and monthly reporting
  

Insights & Decision Support

• Analyze pricing, keyword performance, ads efficiency, category trends, and customer behavior
• Deliver actionable insights to E-commerce, Growth, Finance, and Leadership teams
• Present insights clearly to non-technical stakeholders
  

Required Skills & Experience

Must-Have

• 4–7 years of experience in e-commerce / D2C analytics
• Strong SQL (joins, CTEs, window functions)
• Strong Python (Pandas, API integrations, automation)
• Experience with Power BI or Looker Studio
• Hands-on experience with GA4, Shopify Analytics
• Experience with Amazon Ads, Meta Ads, Google Ads
• Experience building automated pipelines and dashboards
  

Good to Have

• Experience with BigQuery or cloud data warehouses
• Marketplace exposure (Amazon, Flipkart, Nykaa, 1mg)
• FMCG / D2C / nutraceutical background
  

What The Client Is Looking For

• Strong ownership and accountability
• Structured, detail-oriented thinking
• Ability to work cross-functionally in a fast-paced environment
• Bias towards automation and clean, reliable data
  

Education

• Bachelor’s degree in Engineering, Computer Science, Mathematics, Statistics, or equivalent