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 ack

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