Data Analyst

Job Title:

Location:

Experience:

Reporting to:

Role Summary

client

hands-on Data Analyst

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