MIS Analyst

Job Description

Position: MIS Analyst Experience: 2 to 5 years of experience in MIS reporting, Sales analysis in a Retail or FMCG sector. Location: Corporate office-Davanagere in Karnataka. Reports To: Director Work Mode: This position is purely work from office. Note: Apply only if you are willing to relocate to Davanagere. Job Overview: This role requires an experienced professional with 2-5 years of experience in data analysis and reporting. The ideal candidate will use Advanced Excel and data visualization tools to generate meaningful dashboards and provide business insights that enhance operational efficiency and customer experience. Develop and manage MIS reports and dashboards, providing accurate and timely data to management and other stakeholders. Role & responsibilities: Data Management and Generate Reporting: Store wise target and achievement using CRM software on Weekly/Month/Quarterly/Half yearly/Annual for all the stores in multiple location. Purchase, Sales and Expenses report using CRM software and POS on Weekly/Month/Quarterly/Half yearly/Annual for all the stores in multiple location. Preparing and Consolidated Daily reports in pertaining to Sales and Cash Flow /Card/ Digital Payment entries of all the stores in multiple location. Preparing PPT for management Business Performance Report (Sales) & Stock Availability Report with the help of CRM & POS for all the stores in multiple location on Weekly. Analysis and Insights: Review and Analysis of various discounts and marketing schemes as prevailing and proposed for various regions with the schemes of local competitors. Perform detailed analysis on sales trends, product performance, and inventory turnover. Identify underperforming stores or products and provide recommendations for improvement. Analyse customer buying patterns and contribute to pricing and promotion strategies. Inventory & Supply Chain Support: Monitor stock levels across all stores to support replenishment planning. Work closely with supply chain and warehouse teams to minimize stock-outs and overstock situations. Analyse Store Sales variances (Price, Qty and Prod. Mix) on the basis of their best month performance. Analyse non-moving stocks & replenish according to their best demanded zone. Analyse the Sell-Thru rate & Stock turnover on stores. Education and Experience: Any Bachelors degree 2 to 5 years of experience in MIS reporting, sales analysis, or business intelligence in a retail or FMCG sector. Skills: Advanced Excel skills such as COUNTIF, SUMIF, HLOOKUP, VLOOKUP, PIVOT TABLE, Conditional Formatting etc. To analyse data and present findings effectively through Pivot tables and Charts. Design, maintain, and automated Dashboards. About company: Chetan Agro and Foods packaging company is based out of North Karnataka, India. It has been established to provide services to the society by manufacturing superior-quality, adulteration-free & preservative-free blended masalas, instant ready mixes, traditionally processed flours, and spice powders. We have started a new business venture Chetan Foods which is a sister company of Chetan Agro and Foods Packaging. Our objective is to open multi-store grocery retail setups using the FOCO & COCO model across Karnataka and in other states. Website: https://chetanfoods.co