SCM - Data Analyst

Key Responsibilities

SCM Data Analysis & MIS

• Collect, validate, consolidate and analyze SCM data from ERP/HMS and other systems.
• Prepare daily, weekly and monthly SCM MIS reports.
• Develop management dashboards and analytical reports for senior management.
• Identify trends, variances, exceptions and abnormal transactions.
• Provide data-driven insights and recommendations to SCM management.

Cost & Margin Analysis

• Analyze procurement cost, selling price, MRP and margin data.
• Identify opportunities for procurement cost reduction.
• Prepare product/item-wise margin analysis.
• Analyze price changes and their impact on profitability.
• Support management with cost-saving and margin-improvement analysis.

Procurement Analytics

• Analyze Purchase Orders (PO), GRNs, invoices and purchase rates.
• Monitor PO rate vs. GRN rate vs. invoice rate and identify discrepancies.
• Analyze vendor-wise and item-wise purchase trends.
• Track price variations and support procurement teams in identifying cost-saving opportunities.
• Analyze quotation history and changes in approved purchase prices.
• Monitor procurement volumes, purchase frequency and vendor dependency.

Inventory Analytics

• Analyze inventory levels, stock movement and inventory ageing.
• Prepare reports on non-moving, slow-moving, fast-moving and critical/vital items.
• Monitor stock coverage and identify excess or shortage risks.
• Analyze inventory turnover and working capital impact.
• Support inventory optimization initiatives.
• Identify near-expiry and expired stock trends.

Vendor Performance Analytics

• Prepare vendor-wise performance reports.
• Analyze purchase value, pricing, supply frequency and delivery performance.
• Track vendor rate variations and compliance with approved PO rates.
• Identify vendors/items requiring corrective action.
• Support vendor evaluation and performance review.

Data Quality & Controls

• Validate SCM data before publishing management reports.
• Identify data discrepancies between PO, GRN, invoice and system records.
• Coordinate with Procurement, Stores, Finance, IT and Business teams for data correction.
• Develop and monitor data validation checks and exception reports.
• Ensure accuracy and consistency of master and transaction data.

Dashboard & Automation

• Develop automated dashboards using Power BI / Excel.
• Automate repetitive MIS and reporting activities.
• Create interactive dashboards for procurement, inventory and vendor performance.
• Improve reporting efficiency through automation and standardization.
• Maintain data models and reporting logic.

Key Reports / Dashboards

• Cost Saving / Procurement Saving Report
• MRP / Margin Analysis
• Procurement Spend Dashboard
• PO vs. GRN vs. Invoice Rate Analysis
• Vendor Performance Dashboard
• Purchase Price Variance Report
• Inventory Ageing Report
• Non-Moving & Slow-Moving Stock Report
• Near-Expiry & Expiry Analysis
• Inventory Turnover Dashboard
• Stock Coverage / Days of Inventory Report
• Purchase Trend Analysis
• Item-wise & Vendor-wise Purchase Analysis
• Exception & Data Quality Reports
• Management SCM MIS

Required Skills

• Strong knowledge of Advanced Excel including Pivot Tables, Power Query, XLOOKUP/INDEX-MATCH, SUMIFS, IF functions and data validation.
• Good knowledge of Power BI and dashboard development.
• Knowledge of SQL will be an added advantage.
• Strong analytical and problem-solving skills.
• Good understanding of procurement and inventory processes.
• Ability to work with large datasets.
• Strong attention to detail and data accuracy.
• Good communication and presentation skills.
• Ability to convert data into actionable business insights.

Educational Qualification

Graduate / Post Graduate in Supply Chain Management, Business Analytics, Commerce, Finance, Statistics, Economics, Engineering, Computer Applications or related field. Certification in Data Analytics / Power BI / Supply Chain Analytics will be an advantage.

Experience

Preferred Experience: 12 - 15 + years in SCM Analytics, MIS, Business Analytics, Procurement Analytics, Inventory Analytics or a related role. Experience in hospital supply chain, pharmaceuticals, healthcare, retail or distribution will be preferred.