SCM - Data Analyst

Livasa Hospitals; Mohali; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Livasa Hospitals seeks an experienced SCM Data Analyst to consolidate and analyze data from ERP/HMS systems, and to generate daily to monthly MIS reports. The role focuses on dashboards, data quality, and actionable insights for procurement, inventory, and vendor performance.

The ideal candidate will have strong Excel and Power BI skills, with knowledge of SQL and a solid understanding of procurement and inventory processes. Relevant experience in healthcare supply chains is preferred.

Qualifications

• Advanced Excel with Pivot Tables, Power Query, XLOOKUP/INDEX-MATCH, SUMIFS, data validation.
• Power BI dashboard development.
• SQL knowledge is an added advantage.
• Strong analytical and problem-solving abilities.
• Good understanding of procurement and inventory processes.
• Ability to work with large datasets.
• Attention to data accuracy and detail.
• Strong communication and presentation skills.
• 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.
• 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.
• Analyze PO, GRN, 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.
• Analyze inventory levels, stock movement and inventory ageing.
• Prepare reports on non-moving, slow-moving, fast-moving and critical 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.
• 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.
• 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.
• 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.
• 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

Skills

Advanced Excel

Power BI

SQL

Analytical skills

Procurement processes

Inventory management

Data accuracy

Communication skills

Data storytelling

Education

Graduate / Post Graduate in SCM / Analytics / related field

Tools

Power BI

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