1. Data Management and Reporting • Data Accuracy & Integrity: Ensure accuracy and consistency of data in reports, dashboards, and analyses. • Timely Report Generation: Deliver regular MIS reports, dashboards, and summaries to support procurement and category management teams. • KPI Tracking: Assist in tracking key performance indicators (KPIs) and deliver automated reports using Power BI, Excel, and other tools. 2. Automation and Process Improvement • Report Automation: Collaborate with the Power BI team and other stakeholders to automate routine reports, reducing manual effort and errors. • VBA & Macros: Develop and implement VBA scripts and Excel Macros to streamline data processing and reporting. 3. Data Analysis and Visualization • Advanced Data Analysis: Apply Excel, SQL, and MS Access to conduct in-depth analysis and extract actionable insights. • Data Visualization: Build effective dashboards and visualizations in Power BI and Excel to clearly communicate insights. 4. Strategic Decision-Making Support • Analytical Support: Provide data-driven insights to strengthen procurement strategies, supplier management, and category optimization. • Cross-Functional Collaboration: Work with procurement, supply chain, and sales teams to provide relevant reports and insights for planning. 5. Presentation and Communication • Presentation Development: Prepare and deliver professional presentations summarizing trends and findings for senior management. • Stakeholder Communication: Ensure clear and consistent communication with stakeholders regarding reporting needs and data accuracy. 6. Data Coordination and Back-office Support • Team Coordination: Act as a bridge between category management and back office/Power BI teams to ensure seamless data flow. • Productivity Metrics: Support tracking of category productivity metrics to highlight efficiency improvements. Key Competencies 1. Advanced Excel Skills • Mastery of complex formulas, pivot tables, data analysis tools, and functions. • Expertise in VBA & Macros for automating reports and improving efficiency. 2. SQL Knowledge • Ability to query databases, extract data, and integrate into MIS reports. 3. Power BI and Data Visualization • Proficient in building interactive dashboards and visual reports. 4. MS Access Skills • Experience in managing and analyzing datasets with queries, forms, and reports. 5. Presentation & Communication • Skilled in creating executive-level presentations. • Strong written and verbal communication for cross-functional reporting. 6. Analytical Thinking • Ability to identify patterns, trends, and anomalies in datasets. 7. Attention to Detail • Ensures reports are accurate, reliable, and error-free. 8. Teamwork & Collaboration • Works effectively with cross-functional teams to align reporting objectives. 9. Adaptability & Continuous Learning • Eagerness to learn and adapt to new tools, reporting methods, and technologies. Requirements 1. Education • Graduate degree with Diploma/Certification in Advanced Excel & SQL. 2. Technical Knowledge • Proficiency in MIS reporting systems, dashboards, and visualization. • Strong in MS Excel (advanced functions, pivot tables, macros). • Experience in databases (SQL, Access, etc.). • Working knowledge of Power BI. • Familiarity with ERP systems (SAPetc.). • Understanding of statistics, data cleaning, and validation. 3. Experience • Min 1–2 years’ experience in MIS reporting, data analysis, or business reporting. • Experience in FMCG, Retail, Banking, or Supply Chain is an added advantage.