Agent
Jobs
Applied
Tracker
Profile
    1. Jobs for you
    2. Job

    Job · 15359681

    Purplle.com logo

    Business Analyst

    Purplle.com · Mumbai · onsite · Posted 50d ago

    Not disclosed1–3 yrsfulltimeSourced fromFoundit

    About a minute. You'll make an account on the way through.

    About this role

    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.

    About Company

    Founded in 2011, Purplle has emerged as one of India's premier omnichannel beauty destinations, redefining the way millions shop for beauty. With 1,000+ brands, 60,000+ products, and over 7 million monthly active users, Purplle has built a powerhouse platform that seamlessly blends online and offline experiences.

    Expanding its footprint in 2022, Purplle introduced 6,000+ offline touchpoints and launched 100+ stores, strengthening its presence beyond digital. Beyond hosting third-party brands, Purplle has successfully scaled its own D2C powerhouses—FACES CANADA, Good Vibes, Carmesi, Purplle, and NY Bae—offering trend-driven, high-quality beauty essentials.

    What sets Purplle apart is its technology driven hyper-personalized shopping experience. By curating detailed user personas, enabling virtual makeup trials, and delivering tailored product recommendations based on personality, search intent, and purchase behavior, Purplle ensures a unique, customer-first approach.

    In 2022, Purplle achieved unicorn status, becoming India's 102nd unicorn, backed by an esteemed group of investors including ADIA, Kedaara, Premji Invest, Sequoia Capital India, JSW Ventures, Goldman Sachs, Verlinvest, Blume Ventures, and Paramark Ventures.

    With a 3,000+ strong team and an unstoppable vision, Purplle is set to lead the charge in India's booming beauty landscape, revolutionizing the way the nation experiences beauty.

    Sourced from foundit

    Skills

    bigqueryMetabaseGoogle SheetsPythonPower BiSQLAI ToolsPandasLookerexcel

    About Purplle.com

    Purplle.com logo

    Purplle.com

    Beauty & Personal Care

    370

    employees

    2011

    15 years old

    Mumbai, Maharashtra

    US

    ₹8.1L PA avg

    Avg at Purplle.com

    About

    Online marketplace for beauty products and cosmetics

    Industries

    Beauty & Personal CareInternetRetail

    Employee ratings

    10 reviews

    3.6/ 5

    Culture

    2.9

    Career growth

    2.7

    Work-life

    3.3

    Employees rate it well for

    Overall Company36Company Culture35

    Find them on

    WebsiteLinkedInAmbitionBox reviews

    Business Analyst · waiting for your command