Sales and Operations Analyst

We are seeking a motivated and detail-oriented Planning Analyst to join our Sales & Operations Planning team. As an online platform for pets offering products and services, we manage inventory across multiple warehouses and dark stores while supporting forecasting, replenishment, and profitability initiatives. This internship offers an excellent opportunity to gain hands-on experience in data analysis, operational planning, and process improvement.

Key Responsibilities :

Demand Planning : Support short-term and long-term demand forecasting using historical trends, events, and category inputs

Inventory Management : Assist in managing stock levels across warehouses and dark stores, avoiding stock-outs and overstocking

Replenishment Planning : Track reorder triggers and ensure timely replenishment aligned with Days of Inventory (DOI) targets

Data Analysis : Analyze large datasets to identify gaps, generate insights, and drive planning decisions

KPI Reporting : Create and maintain dashboards for key metrics such as fill rate, forecast accuracy (MAPE), stock cover, etc.

Scenario Planning : Assist in evaluating 'what-if' scenarios to support sales events, seasonality, or promotional planning

Process Improvement : Identify and recommend opportunities to streamline planning operations and enhance forecast accuracy

Cross-Functional Collaboration : Work with supply chain, category, finance, and tech teams to align demand-supply priorities

Automation & Tools : Support automation of planning processes through Excel, Google Sheets, and tools like SQL / Python if applicable

Ad Hoc Projects : Contribute to special initiatives, including network planning, capacity analysis, and strategic reviews

Qualifications :

0–2 years of experience in an e-commerce or consumer-focused platform, preferably in planning, operations, or analytics.

Understanding of business analysis on  workflows, operations,  KPIs, and hands-on experience with data analysis and reporting

Strong analytical and problem-solving skills with attention to detail

Proficiency in Microsoft Office Suite, especially Excel and PowerPoint

Familiarity with data tools like SQL, Python, or Google Sheets is a plus

What We Offer :

Mentorship and guidance from experienced professionals.

A dynamic and collaborative work environment.

Skills Required

google sheets , Data Analysis, Excel, Sql, Python