Purpose of the Position:
• To be the Global Anchor on Supply Chain Reports.
• Co-ordination of Report requests and developments in co-operation with Backend and Frontend developers.
• Develop Operational and Ad Hoc reports for Business use in Supply Chain.
• Performing Business Analytics and Root Cause Analysis on Performance Metrics.
• Supporting Business Process Communities with Data Reports and Analytics.
• Supporting Master Data Governance Reporting.
Roles & Responsibilities:
• Act as the subject-matter expert for SQL-based analytics across supply chain data.
• Develop operational reports through SQL and maintain in Supply Chain Report Catalogue.
• Write, optimize, and maintain complex SQL queries involving large datasets and manage advanced SQL logic using CTEs, window functions, subqueries, and performance tuning techniques.
• To manage Report requests from Operations.
• Ensure data accuracy, reconciliation, and data validation of Performance Reports.
• Evaluate and Communicate Results from Performance Reports.
• Develop Operational Reports for specific Business Need.
• Evaluate and Request Master data updates based on Governance Reports.
• Support inventory optimization initiatives and continuous improvements within inventory management.
Competencies:
• Strong Analytical Skills, End to End Supply Chain knowledge, Deep knowledge on ERP system and Master data setup.
• Preferable experience from Manufacturing, Logistics Operations in KK or similar Company.
• Strong understanding of Bill of Materials (BOM) structures & SQL-based BOM explosion logic.
• Good Communication skills are preferable.
• Robust knowledge & experience from Power BI or similar Frontend Data Reporting Tool is expected.