Lead - Business Analytics (Supply Chain)

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.

Our requirements

• 3 to 6 years of experience. Business Experience from Global Manufacturing Company Preferred.
• Be/B. Tech in Mechanical / Electrical / Electronic or Master level or Supply Chain Management.
• 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.
• Strong knowledge experience from Power BI or similar Frontend Data Reporting Tool is expected.

• Advanced SQL (complex queries, performance optimization).
• Strong experience with:

1. CTEs, window functions, correlated subqueries.
2. Query optimization and performance tuning.
3. Data validation and reconciliation logic.

• Strong hands-on experience with Power BI.
• Solid understanding of data modelling, ETL processes, and data warehousing concepts.
• Experience with ERP systems (Microsoft D365, etc.).

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.