SCM Business Analytics

Livasa Hospitals; Mohali; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Livasa Hospitals is seeking a SCM Analytics professional to collect, validate, and analyze data from ERP/HMS, and to build and automate dashboards that support procurement, inventory, and vendor performance insights. The role emphasizes data-driven decision making across cost, margin, and supply chain processes.

The candidate should have 2–5 years of experience in SCM analytics or related roles, with strong Excel, Power BI, and SQL skills, and a keen eye for data accuracy and actionable

Qualifications

• Graduate/PG in SCM or Analytics, with data analytics exposure.
• Strong knowledge of procurement and inventory processes.
• Ability to convert data into actionable business insights.

Responsibilities

• 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.
• Analyze procurement cost, selling price, MRP and margin data.
• Monitor PO rate vs. GRN rate vs. invoice rate and identify discrepancies.
• Prepare vendor performance reports and inventory ageing analyses.
• Develop automated dashboards and standardize reporting to improve efficiency.

Skills

Analytical thinking

Data analysis

Procurement & inventory understanding

Attention to detail

Communication & presentation

Large datasets

Education

Graduate/PG in SCM

Tools

Power BI

Excel

SQL

Job description

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: 2 - 5 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.