Business Analyst
Purplle.com · Mumbai Metropolitan Region
- Experience1–3 yrs
- SalaryDisclosed
- Work modeonsite
- Posted1 Oct 2026
About Purplle.com
Purplle.com is hiring in Mumbai Metropolitan Region in ecommerce retail. This role looks for around 1+ years of experience.
Skills
- SQL
- BigQuery
- AI-Assisted Analytics
- Microsoft Excel
- Google Sheets
- Supply Chain Analytics
- Data Visualization
- Metabase
- Looker Studio
- Data Quality Management
- Business Analytics
The role
A data analyst at an e-commerce retail company turns supply chain data into decisions, using Supply Chain Analytics, BigQuery, and AI-Assisted Analytics to uncover drivers and quantify operational impact. The role also applies SQL and Microsoft Excel to validate data and support business storytelling.
Full job description
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 new
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 and shelved.
Data Quality & Governance
Validate data integrity across source systems (SAP, Easyecom, WMS) before it reaches a dashboard or
a deck.
Flag and help resolve upstream data quality issues that distort network-level reporting.
What Success Looks Like
Insight that changes a decision — not a chart nobody reopens. Turnaround time on ad-hoc analysis measurably shrinks as your AI-assisted workflows mature. Dashboards stakeholders check on their own, without being chased. A reputation as the person who finds the story in the data everyone else scrolled past.
What We're Looking For
Must Have
Bachelor's degree in Engineering, Statistics, Economics, or another quantitative field. 1–3 years of experience in business or data analytics — supply chain, e-commerce, or quick-commerce
background preferred.
Strong, hands-on SQL — comfortable writing complex joins, window functions, and large-scale queries
on BigQuery or equivalent, not just SELECT statements.
Genuine curiosity and hands-on comfort experimenting with AI tools to push analytics past standard
reporting — this is a mindset requirement, not a checkbox.
Strong Excel/Google Sheets skills for quick modeling and validation. Ability to convert ambiguous business questions into structured analysis without heavy hand-holding. Sharp communication — can present numbers as a business story, not a data dump.
Good to Have
Working exposure to Python (pandas) for analysis and automation. Familiarity with visualization tools such as Looker Studio, Metabase, or Power BI. Prior exposure to supply chain or logistics data — STO, IWT, inventory, CPT, DPMO.