Job Description

What you'll do:

-------------------



1. Develop comprehensive reports and analysis of SCM spend data, commodity data and part wise cost details for each ledger

2. Extrapolate data from multiple SCM systems for data analysis and reporting (Costverse, GRN data, Encore, Oracle, Share point, Commodity, Finance, Inputs from team, Enterprise Data. SPIR and other inputs)

3. Calculation and tracking of part cost, compiling the Material cost on monthly basis for actuals and forecast. Comparison with plan, actuals and forecast

4. Tracking of Price increase requests (SPIR) based on inputs from category managers and incorporating in Material cost based on timing and assumptions

5. Calculation of Commodity increases part wise, commodity wise, supplier wise, customer wise

6. Assist in identification of methods to streamline reporting-analysis and presentations

7. Fulfilling requests made by SCM managers, Leadership, Commodity managers, SDEs for historical pricing, spending and other pertinent data needs.

8. Provide analytical / planning support to ongoing business processes, such as market trend analysis, financial analysis and action follow up to achieve MG India business objectives.

9. Co-ordinate activities related to Profit Plan and Strategic Plan in the region and work with Product Planning / Marketing / Finance / Operations Teams.

10. Coordinate & ensure identifying, tracking and closing of all the OPEN items on the MG Truck EPM.

11. Compile and release the Regional SCM Operation Review, MIS (India and Rest of APAC)

12. Work with suppliers for commodity adjustments and settlements based on commercials finalized

13. Compile data, generate and release supplier PPV reports on monthly basis.

14. Track and release status of supplier wise DPO and Supplier numbers on monthly basis.

15. Maintain the supplier master list and tracking of supplier details through Category team on ongoing basis.

16. Support supplier ethics communications and support on supplier critical documents like NDA etc.

17. Supporting Proto requirements through indent tracking & PO release

18. Supporting Cost out project tracking and updating in system (Costverse, GPS, etc..)

19. To ensure On time reporting of SCM Metrics, On time delivery of Monthly SCM reports.

20. Any degree in accounting, finance, or engineering with at least five (5) years of experience in data analysis/processing, purchasing, management reporting, and customer service or equivalent job experience.

Qualifications:

-------------------



BE or B.Tech. (Mechanical brand preferred)

Skills:

-----------



1. Need excellent analytical skills, expert in MS Excel/Macro, Power point , Power BI and process automation

2. Functional knowledge of supply chain and purchasing requirements is preferred

3. Familiarity with quality assurance and reporting accuracy.

4. Familiarity with process improvement methodologies and project management skills and applications.

5. Good communication and presentation skills when interacting with both internal / external team members and during leadership interactions