MIS Analyst

Job Description

Position: MIS Analyst Experience: 2 to 5 years of experience in MIS reporting, sales analysis, or business intelligence in a retail or FMCG sector. Location: Corporate Office-Davanagere, in Karnataka. Reports To: Director Note: This position is purely work from the office. 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 a weekly/monthly/quarterly/half-yearly/Annual for all the stores in multiple locations. Purchase, sales, and expenses reports using CRM software and POS on a weekly/monthly/quarterly/half-yearly/Annual for all the stores in multiple locations. Preparing and Consolidated Daily reports pertaining to sales and cash flow/card/digital payment entries of all the stores in multiple locations. Preparing PPT for management Business Performance Report (Sales) & stock availability reports with the help of CRM & POS for all the stores in multiple locations on a weekly basis. 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. Analyze store sales variances (price, quantity, and product mix) on the basis of their best month's performance. Analyze non-moving stocks & replenish according to their best demanded zone. Analyze the Sell-Thru rate & Stock turnover in stores. Education and Experience: Any Bachelor’s 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 analyze data and present findings effectively through pivot tables and charts. Design, maintain, and automate dashboards. About the 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.com/ Job Types: Full-time, Permanent Pay: ₹300,000.00 - ₹400,000.00 per year Benefits: Provident Fund Schedule: Day shift Supplemental Pay: Yearly bonus Ability to commute/relocate: Davangere, Karnataka: Reliably commute or planning to relocate before starting work (Required) Application Question(s): Do you have expertise in Advanced Excel skills such as COUNTIF, SUMIF, HLOOKUP, VLOOKUP, PIVOT TABLE, conditional formatting, etc.? Experience: MIS: 2 years (Required) Work Location: In person Expected Start Date: 01/08/2025