MIS Executive (Procurement)

Qualification: Educational Qualification: Graduate in B.Com, BBA, B.Sc., B.E., or a related discipline. MBA is preferred. Experience: 3–5 years of experience in MIS, reporting, and data analysis, preferably in a procurement environment. Strong proficiency in Advanced Excel, including Pivot Tables, VLOOKUP/XLOOKUP, Power Query, and Macros. Experience preparing daily, weekly, and monthly MIS reports and management dashboards. Working knowledge of Power BI or Tableau is an added advantage. Familiarity with ERP systems such as SAP, Tally, Oracle, or similar applications. Hands-on knowledge of GST and TDS requirements applicable to purchase transactions and vendor invoices. Understanding of procurement data, including PRs, POs, GRNs, vendor invoices, spend, savings, and pending approvals. Ability to reconcile procurement data with Finance, Accounts, and ERP records. Strong analytical skills, attention to detail, communication, and stakeholder coordination. Ability to manage multiple reporting requirements and deliver accurate information within defined timelines. Essential Area of Expertise: Procurement MIS preparation, reporting, and data management, including daily, weekly, and monthly reports. Tracking Purchase Requisitions (PRs), Purchase Orders (POs), pending approvals, procurement spend, savings, and ageing. Developing and maintaining management dashboards using Advanced Excel and Power BI. Maintaining vendor master data, rate contracts, vendor performance, and delivery tracking. Monitoring the procurement cycle from PR to PO to Goods Receipt Note (GRN) to invoice. Validating vendor GST details and tracking GSTR-2A/2B reconciliation with purchase data. Verifying TDS applicability and rates on vendor invoices and coordinating with Finance for deductions, deposits, and returns. Reconciling procurement data with Finance, Accounts, and ERP records to ensure data accuracy and integrity. Analysing procurement spend by category and vendor to identify savings and cost-reduction opportunities. Coordinating with Procurement, Finance, Accounts, and Stores for reporting and compliance requirements. Automating recurring reports and identifying opportunities for MIS and process improvements. Desired Area of Expertise: Hands-on experience in procurement reporting and understanding of the end-to-end procurement process. Advanced Excel skills, including Pivot Tables, VLOOKUP/XLOOKUP, Power Query, and Macros. Working knowledge of Power BI or Tableau for dashboard creation and data visualization. Familiarity with ERP systems such as SAP, Tally, Oracle, or similar platforms. Practical knowledge of GST and TDS requirements applicable to purchase invoices. Experience in vendor onboarding, vendor master maintenance, and reconciliation. Ability to analyse procurement expenditure, vendor performance, purchase trends, and cost-saving opportunities. Basic knowledge of SQL and VBA for data extraction and report automation. Strong analytical, problem-solving, communication, and coordination skills. High attention to detail, data accuracy, and ability to meet reporting deadlines. Role and Responsibility Prepare daily, weekly, and monthly procurement MIS reports covering PR/PO status, pending approvals, procurement spend, savings, and ageing. Develop, maintain, and update dashboards using Excel and Power BI to support management reviews and procurement decisions. Maintain accurate vendor master data, rate contracts, vendor performance records, and delivery tracking information. Track the complete procurement cycle from PR to PO to GRN to invoice and follow up on delays, pending approvals, and process bottlenecks. Validate vendor GST details and monitor GSTR-2A/2B reconciliation against purchase data, highlighting potential Input Tax Credit (ITC) mismatches. Verify TDS applicability and rates on vendor invoices and coordinate with Finance for timely deductions, deposits, and return-related requirements. Audit and reconcile procurement data with Finance, Accounts, and ERP records to ensure data accuracy and consistency. Analyse procurement expenditure by category and vendor, identify spending patterns, and highlight cost-saving opportunities. Coordinate with Procurement, Finance, Accounts, and Stores teams to collect data and address reporting and compliance requirements. Automate recurring MIS reports and improve reporting efficiency through Excel tools, Power Query, Macros, or other suitable solutions. Identify data inconsistencies, investigate discrepancies, and coordinate corrective actions with the concerned stakeholders. Support management decision-making by providing timely, accurate, and meaningful procurement reports and analysis. Apply as a MIS Executive (Procurement) Upload resume * Choose File No file chosen Delete uploaded file SUBMIT Next Post Senior Procurement Executive Ready to gain the Amnex advantage? let’S talk About Us Blogs Careers Sitemap Privacy Policy Terms and Conditions Copyright 2026 AMNEX INFOTECHNOLOGIES PRIVATE LIMITED. Share Share Share Pin