HamburgerMenu
iimjobs
Job Views:  
473
Applications:  147
Recruiter Actions:  3

Job Code

1587833

Operations Analyst

Techmatters Technologies and Consulting Private Li.2 - 5 yrs.Mumbai
Posted 4 months ago
Posted 4 months ago

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:


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


Didn’t find the job appropriate? Report this Job

Job Views:  
473
Applications:  147
Recruiter Actions:  3

Job Code

1587833

UPSKILL YOURSELF

My Learning Centre

Explore CoursesArrow