Job Title: Data Analyst E-commerce & D2C
Location: Bangalore
Experience: 47 years
Reporting to: Head of E-commerce / Growth
Role Summary
Our client is a fast-growing wellness / nutraceutical brand operating across major Indian marketplaces (Amazon, Flipkart, Nykaa, 1mg, Myntra) and D2C digital channels.
They are looking for a hands-on Data Analyst to own end-to-end analytics from data extraction and automation to dashboards and business insights that directly impact revenue, advertising efficiency, inventory, and profitability.
This is 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
- 47 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
