Inventory Audit and MIS analyst

Job Description

Job Description Data Analysis Collect, clean, and analyze inventory and store data to identify trends, variances, and operational inefficiencies. Develop data models, reports, and dashboards to provide actionable insights into stock levels, order patterns, and consumption rates. Collaborate with inventory, procurement, and supply chain teams to improve forecasting and stock replenishment strategies. Utilize data visualization tools (Excel, Power BI, Power point) to present complex data in user-friendly formats. Coordinate with IT team to develop automated tool for various reports Auditing Conduct audits on inventory records, store transactions, and stock management processes to ensure compliance with company policies. Conduct physical Inventory Audit of Pharmacy stores and various stores locations under the Rama Group and accurately count inventory levels. Match inventory records across ERP/Tally/Pharmacy Management Software and reconcile where discrepancies occur Perform physical stock verification and reconcile discrepancies with system records. Assess internal controls, risk management practices, and process effectiveness related to store and inventory operations. Prepare detailed audit findings with actionable recommendations to mitigate risks and improve inventory accuracy. Ensure timely follow-up on audit action plans and report progress to management. To check on random basis vendors bill, GRN & PO etc. Identify slow-moving, Non-moving or obsolete inventory and take necessary action to resolve it. Regularly review expiry-dated items (like medicines and consumables) and alerts for near-expiry products to minimize wastage. Carry on regular audits to ensure ongoing accuracy in Pharmacy Inventory and fulfilment & control of inventory management as required by Management. MIS Preparation and Reporting Develop and maintain comprehensive MIS reports to track key performance indicators (KPIs) for inventory and store management. Prepare daily, weekly, and monthly performance reports and inventory status updates. Provide insights and recommendations to senior management based on MIS data analysis to support strategic decisions. Design custom reports and templates tailored to business needs for better monitoring of inventory movement and storage efficiency. Ensure timely dissemination of reports and data insights to relevant stakeholders. Qualification Bachelors degree in any field. Proven experience in data analysis, auditing , and MIS reporting , preferably in inventory or supply chain management . Proficiency in data analysis tools and ERP systems (e.g., Excel, SAP, Power BI). Basic knowledge of inventory management and control processes. Excellent analytical, problem-solving, and communication skills.