Power BI & Data Insights Executive – Linen Trail

Linen Trail is India’s Quiet Luxury Linen Label — a slow fashion brand crafting 100% Pure Linen apparel for men. We are a digital-first D2C brand with a decade-long legacy of craftsmanship, innovation, and data-led decision-making.

Data & Insights function

Role Overview

Data Analyst

Key Responsibilities

Product-Level Insights

• Build dashboards to track

  sales by product

  ,

  color

  ,

  fabric

  , and

  size

  , identifying bestsellers and slow movers.
• Map

  fabric consumption vs. inventory

  to aid predictive manufacturing.
• Identify

  top 20% products contributing 80% of revenue

  and recommend “Just Before Time” manufacturing volumes.

Order-Level Insights

• Analyze

  daily/weekly/monthly order trends

  , average order value, and contribution by channels.
• Track campaign performance vs. revenue and profitability (Meta, Google Ads, Email, WhatsApp).
• Identify patterns in

  cart abandonment, discounts, and return rates

  .

Customer-Level Insights

• Create

  customer segmentation

  based on frequency, recency, and spend (RFM).
• Track

  repeat rate, lifetime value (LTV)

  , and

  customer acquisition cost (CAC)

  .
• Build cohorts to analyze retention and customer journey (first purchase → repeat → loyalist).
• Integrate data from

  Shopify, Contlo, and CRM tools

  for unified customer intelligence.

Requirements

• 2–3 years of experience in

  Power BI

  (DAX, Power Query, data modelling).
• Strong skills in

  SQL, Excel

  , and data transformation.
• Experience connecting Power BI with

  Shopify, Meta Ads, Google Ads, and Google Analytics

  APIs or exported data.
• Understanding of

  e-commerce KPIs

  (AOV, ROAS, retention, CAC, LTV, RFM, etc.).
• Ability to independently design dashboards, automate data refreshes, and communicate insights to non-technical teams.