Job Description
Required Skills & Qualifications:
Graduate/Postgraduate in Commerce, Science, Statistics, Engineering, or related disciplines.
2-4 years of experience
in reporting, MIS, or data analysis roles, preferably in supply chain, sales operations, or commercial functions.
Advanced Excel skills
including pivot tables, complex formulas, lookups, data validation, conditional formatting, and dashboarding.
Experience in
creating structured reports
with accuracy and timeliness.
Strong understanding of inventory management concepts is preferred.
Ability to handle large datasets efficiently and perform data consolidation from multiple sources.
Excellent attention to detail, problem-solving attitude, and logical thinking.
Good communication skills to coordinate inputs and explain reports to stakeholders.
Preferred Skills:
Exposure to
Power Query, Power Pivot, VBA Macros, or Power BI
for automation and visual reporting.
Experience in supply chain analytics, inventory optimization, or order allocation processes.
Key Responsibilities:
Prepare and maintain the
Order Allocation Summary
to support optimal allocation decisions.
Create and update
Inventory Aging reports
to track stock ageing and identify slow-moving items.
Develop
Free Inventory Files
for visibility of unallocated stocks for business teams.
Generate
Distributor Order Visibility Reports
to enhance order planning and fulfilment efficiency.
Prepare and share
inputs for Stock Summary reports
to relevant stakeholders.
Create
input files
required for running tools that optimize order allocation.
Consolidate and prepare
Stocks and Sales Performance Reports
at SKU, category, and distributor levels.
Develop
Forecast Accuracy Reports
, comparing actuals vs forecast to improve demand planning.
Prepare and maintain
Cross Sourcing Matrices
to support sourcing flexibility and allocation decisions.
Additional Comments.
Office Location - Yelahanka, Bangalore
