Business Analyst

Purplle.com; Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Purplle's supply chain runs on data — turning daily data into decisions using SQL as the primary instrument and AI as a multiplier. You will look for non-obvious patterns that change leadership's next move, not just faster dashboards.

Collaborating with operations, logistics and inventory teams, you will build and validate analyses, create AI-assisted workflows, and translate findings into actionable recommendations that executives can immediately act on.

Qualifications

• Bachelor's degree in Engineering, Statistics, Economics, or other quantitative field.
• 1–3 years in business or data analytics, preferably supply chain or e‑commerce.
• Strong SQL with complex joins and window functions on BigQuery.
• Curiosity and hands-on use of AI tools to push analytics beyond standard reporting.
• Excel/Google Sheets for quick modeling and validation.
• Translate business questions into structured analysis with minimal hand-holding.
• Sharp communication to tell business stories with numbers.

Responsibilities

• Write and optimize complex SQL against BigQuery to extract data.
• Build and maintain dashboards tracking DPMO, CPT breach, inventory loss, cost, productivity.
• Translate raw data into insights usable by non-technical stakeholders.
• Use AI/LLM tools to accelerate exploratory analysis and surface patterns.
• Experiment with AI-assisted approaches to cut analysis turnaround time.
• Build reusable AI analytics workflows and templates.
• Partner with ops, logistics, and inventory to frame analytical questions.
• Quantify impact of process changes and cost initiatives with before/after analysis.
• Present findings in a way that drives a decision — not just a chart.
• Validate data integrity across source systems before dashboards.
• Flag and help resolve upstream data quality issues.

Skills

SQL

AI tooling

Excel/Sheets

Data storytelling

Education

Bachelor's degree in Engineering, Statistics, Economics, or other quantitative field

Tools

BigQuery

Looker Studio

Metabase

Power BI

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 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.