Sr. Associate Operations Analyst

Job Description

Designation - Sr. Associate Operations Analyst Location - Mumbai, Lower Parel About Us: The Souled Store is a homegrown youth casual-wear brand started in 2013. We are one of India’s largest online merchandising platforms with licenses like Disney, Warner Bros; WWE, IPL, Viacom18 to name a few. Apart from selling products with themed designs such as superheroes, movies, TV shows, and cartoons, the brand also is at the forefront of the latest youth style and fashion trends. In addition to core men and women wear apparel categories, we have also expanded to new categories and introduced new product lines like activewear, supima products, innerwear, personal care products like perfumes etc. We have also launched footwear and kidswear recently. Although we are primarily an online brand, we’ve expanded in the offline retail space as well and have stores pan India. The Souled Store was born out of the idea of loving what you do, from the soul. We believe that people do their best work when they love what they do. There are too many Monday mornings and you can’t go dreading every single one of them. Over the years, we have built a strong team of like-minded people that work smart, own their work, and think like leaders. If you identify with what we do and are interested in being a part of an aggressively growing brand, we would love to have you on Board! Job Summary: We are seeking a highly analytical and hands-on Operations Analyst with deep expertise in Advanced Excel to drive warehouse planning, logistics tracking, and inventory optimization. The ideal candidate will automate planning workflows, build real-time dashboards, and support 3PL and last-mile operations through data insights and performance metrics Key Responsibilities: 1. Warehouse & 3PL Planning Forecast daily and weekly dispatch volumes and derive capacity plans for 3PL partners. Monitor warehouse KPIs: order processing TAT, inventory turnover, reverse logistics timelines. 2. Logistics & Last-Mile Tracking Analyze courier performance: delivery SLA, RTO %, zone-wise delays, and claim management. Build courier allocation models to optimize cost and reduce delays based on zones and weight slabs. 3. Advanced Excel Automation Build fully automated Excel tools using: Pivot Tables and slicers for interactive reports Nested formulas, array functions, and INDEX-MATCH logic for SKU planning 4. Dashboarding Create live Power BI dashboards for: Warehouse throughput (inbound/outbound trends, TAT, aging) Inventory health (stock cover, sell-through, replenishment) Logistics tracking (dispatch vs delivery, courier TAT, cost/order) 5. Inventory Split across Multiple WH Design automated excel on inventory split across multiple WH pan India. Required Qualifications: Bachelor’s degree in Engineering, Business, Logistics, or Supply Chain. 2–4 years of experience in supply chain operations, 3PL or logistics analytics. Advanced Excel expertise: PivotTables, complex formulas, VBA/macros. Experience with WMS/OMS systems (Unicommerce, Vinculum, SAP, etc.). Excellent problem-solving and coordination skills. Preferred Skills (Nice to have): SQL, Python, Power BI. Experience in e-commerce, fashion retail, or multi-WH networks.