ABOUT THE ROLE
Purplle's supply chain runs on data — network movements, CPT, DPMO, inventory, and cost, generated daily
across Fulfillment Centers, Distribution Centers, and Dark Stores. This role exists to turn that data into
decisions. You will work with SQL as your primary instrument and AI as your default multiplier — not to make
existing dashboards marginally faster, but to find the non-obvious pattern, the hidden driver, the insight that
changes what leadership does next.
We are looking for someone who treats AI-assisted analytics as a genuine craft — experimenting with recent
ways to query, model, and explain data faster and better — while staying rigorous about what the numbers
actually mean.

KEY RESPONSIBILITIES
Core Analytics & Reporting
• Write and optimize complex SQL — joins, window functions, CTEs — against BigQuery to extract and
validate data across Easyecom, SAP, and internal warehouse systems.
• Build and maintain dashboards (Metabase, Looker Studio) tracking DPMO, CPT breach, inventory loss,
cost, and productivity across the FC/DC/DS network.




• Translate raw operational data into insight that is immediately usable by non-technical stakeholders.
AI-First Analytics Innovation
• Use AI/LLM tools to accelerate exploratory analysis, generate hypotheses, and surface patterns a
standard query would miss.
• Experiment with AI-assisted approaches — natural-language-to-SQL, automated anomaly detection, AI-
generated insight summaries — to cut analysis turnaround time.
• Build reusable AI-assisted analytics workflows and templates that raise the baseline speed and quality of
the wider analytics team.
Business Impact & Decision Support
• Partner with ops, logistics, and inventory stakeholders to frame the right analytical question before
building anything.
• Quantify the impact of process changes, cost initiatives, and automation projects with rigorous
before/after analysis.
• Present findings in a way that drives a decision — not a chart that gets acknowledged

📌 Business Analyst (Mumbai)
🏢 Purplle.com
📍 Mumbai