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.
- Robust 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.

📌 SCM - Data Analyst (Sahibzada Ajit Singh Nagar)
🏢 Livasa Hospitals
📍 Sahibzada Ajit Singh Nagar