Lead Analyst Functional Excellence

ACG World; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

ACG World seeks a Lead Analyst Functional Excellence in Pune to drive data-driven supply chain improvements. You will analyze BOM consumption, forecast accuracy, and supplier performance while enabling cross-functional teams with timely insights.

Responsibilities include digital transformation in SCM, dashboard development (Excel/Power BI/Tableau), and cost-optimization initiatives across procurement, planning, and production. This role reports to the Head of Global SCM.

Qualifications

• Strong Excel and data analysis skills; experience with Power BI/Tableau.
• Working knowledge of ERP systems (SAP, Microsoft Dynamics, Infor).
• Understanding of discrete manufacturing processes and BOM structures.

Responsibilities

• Material planning and analysis: BOM consumption vs forecasts for custom and standard machines.
• Identify long-lead components and recommend ordering strategies to prevent delays.
• Support procurement and engineering change management with timely data.
• Supplier performance analytics: track on-time delivery, lead times, and pricing trends.
• Production planning support: optimize machine build schedules and resource allocation.
• Project & delivery monitoring: real-time tracking of machine projects (make-to-order/make-to-stock).
• Lead digital transformation initiatives in SCM and dashboard reporting.
• KPIs tracking and gap analysis; conduct process audits in SCM.

Skills

Excel

Data analysis

Power BI

Tableau

Education

Bachelor's degree in Mechanical/Industrial Engineering, Supply Chain, Business Analytics or Business Administration

CSCP, CPIM, Lean Six Sigma certifications (advantage)

Tools

SAP

Microsoft Dynamics

Infor

Job description

Position Title :

Lead Analyst Functional Excellence

Organization Context

Position Title Lead Analyst Functional Excellence

Department

Supply Chain Management

Location

Pune

Reports To

Head Global Supply Chain Management

Reported By

NA

ACG is the world’s only integrated pharma manufacturing solutions company. We are headquartered in Mumbai , India. ACG has a presence in over 100 countries with its products and services that strive to provide world-class technology across multiple domains. We offer a complete range of solutions beginning with empty capsules; granulation and tablet coating; capsule filling; tabletting; packaging films; blister packing and carton packing to the end-of-line solutions and track and trace systems.

We have an opportunity in ACG Engineering of a Lead Analyst Functional Excellence

Primary responsibilities

• Material Planning & Analysis
• Analyze BOM (Bill of Materials) consumption vs. forecasts for custom and standard machines.
• Identify long-lead components and recommend ordering strategies to prevent production delays.
• Support procurement and engineering change management with timely data.
• Supplier Performance Analytics
• Track supplier on-time delivery, lead times, quality rejections, and pricing trends.
• Maintain supplier scorecards and assist in vendor development decisions.
• Production Planning Support
• Provide data-driven insights to optimize machine build schedules and resource allocation.
• Analyze capacity utilization across machining, fabrication, and assembly lines.
• Project & Delivery Monitoring
• Support cross-functional teams (project management, manufacturing, logistics) with real-time tracking of machine projects (make-to-order and make-to-stock).
• Flag bottlenecks early using data models (e.g., Gantt charts, critical path analysis).
• Improvement Projects & Digital Initiatives
• KPIs tracking and gap analysis, Process Audits in SCM
• Identify improvement action plans and drive implementation
• Cost optimization projects, BOM costing analysis and improvement plans
• Identify process gaps and plan digital initiatives.
• Lead digital transformation initiatives in Supply Chain
• Reporting & Dashboards
• Build and maintain dashboards on tools like Excel, Power BI, or Tableau for:
• Procurement lead times
• Inventory turnover
• Optimization & Improvement Projects status tracking
• Supplier performance
• Key Result Areas
• Supplier on-time delivery performance
• Procurement lead time improvement
• Project schedule adherence
• Cost-saving through analytics-led actions
• Improvement projects completion
• Digitalization projects completion
• Processes audit score improvement

Internal Interfaces

• Sales & Order management
• Project Management
• Production Planning, Operations
• Purchasing Procurement
• Sourcing
• Finance
• Engineering & Quality
• IT
• Suppliers
• Industry best practices
• ACG Persona

External Interfaces

• Sales & Order management
• Project Management
• Production Planning, Operations
• Purchasing Procurement
• Sourcing
• Finance
• Engineering & Quality
• IT
• Suppliers
• Industry best practices

Persona

Innovator 3 Supply Chain Management 3 Integrator 3 Functional Process Knowledge 3 Builder 3 Analytics 3

Level of Education

• Bachelor’s degree in Mechanical/Industrial Engineering, Supply Chain, Business Analytics or Business Administration.
• Certifications such as CSCP, CPIM, or Lean Six Sigma are an added advantage.

Experience

• Strong Excel and data analysis skills; experience with Power BI/Tableau is preferred.
• Working knowledge of ERP systems (e.g., SAP, Microsoft Dynamics, Infor, etc.).
• Understanding of discrete manufacturing processes and BOM structures.
• Familiarity with engineering change orders, project-based manufacturing, and sourcing strategies.
• Strong problem-solving and communication skills.
• 3–7 years of experience in Supply chain within a manufacturing environment
• Familiarity with WM or APO is a plus. IT tools for Analytics
• knowledge of Power BI, Tableau, or SAP Fiori Analytics preferred.
• Good understanding of manufacturing processes and ETO/MTO workflows.
• Preferably from capital equipment, pharma machinery, or custom engineering industries

Analytical and process-driven mindset with the ability to work with large datasets.

• Hands-on experience with SAP modules: MM (Materials Management), PP (Production Planning), and IM (Inventory Management);