Employment
Full Time
Experience
3+ Years
Location
Ahmedabad
Open Positions
1
Job Code
AIPL/CORP/SCM/MIS/2617
Essential 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
