MIS Executive

JOB DESCRIPTION: MIS Executive

Bankai Agrifoods Pvt. Ltd.

Function: Sales

Location: Ahmedabad: 1

Website: www.bankaigroup.com; www.amoyaagrifood.com

Company Overview:

Bankai Group is a dynamic global conglomerate renowned for its expansive portfolio covering sectors such as agribusiness, composite products, FMCG, telecom services, fintech, blockchain, IT solutions, entertainment, consulting, and venture capitalism

Bankai Group entered the Indian food industry with a mission to offer high-quality products at affordable prices, aligned with its animal welfare initiative, Amoya Happy Cow Farm. The profits generated from milk sales at this farm are reinvested into animal care on a non-profit basis.

Bankai Agrifoods, under the Amoya brand, operates as a for-profit organization with a state-of-the-art manufacturing facility capable of processing 200,000 liters of milk daily. Situated on a 30-acre property near Baroda, Gujarat, this facility recently completed its first year of producing high-quality dairy products, including ghee, buttermilk, paneer, curd, and yogurt. The flagship product, Amoya Pure Ghee, is crafted to the highest standards of purity and taste, making it a trusted choice

The company aims to create an ecosystem by partnering with farmers and cow farms to produce quality products for the B2B segment while establishing the Amoya brand in the B2C market. Key products include Amoya Pure Ghee and butter, alongside by-products like paneer, flavored milk, curd, and buttermilk.

________________________________________

Job Overview:

We are looking for the MIS Executive To ensure accurate, timely, and insightful reporting across all sales channels and trade operations, supporting decision-making, forecasting, compliance, and performance monitoring in the dairy business.

KRAs, Brief Descriptions, and Responsibilities

1: Sales Reporting & Analysis

Brief: Generate and analyze sales reports by product, geography, team, and customer segment to support daily decision-making and performance tracking.

Roles & Responsibilities:

Extract and compile daily, weekly, and monthly sales data from the sales app or CRM tools.

Generate reports by SKU, zone, ASM, SO, SS, distributor, retailer, etc.

Analyze achievement vs. target across segments.

Identify sales trends, gaps, and provide actionable summaries.

Support senior management in sales review dashboards.

2: Modern Trade, HoReCa, B2B, ECom Sales MIS

Brief: Maintain accurate and periodic sales reports for alternate channels like Modern Trade, HoReCa, B2B, and E-commerce.

Roles & Responsibilities:

Track primary and secondary sales by format/channel.

Consolidate outlet-wise performance data for modern trade chains.

Maintain HoReCa, B2B key customer performance summary.

Coordinate with the respective teams for data accuracy.

Present weekly summaries for each vertical to management.

3: Outstanding & Receivables Reporting

Brief: Provide daily updates on distributor and customer outstanding to aid credit management and sales collections.

Roles & Responsibilities:

Generate and share daily outstanding and receivables reports.

Match sales ledger with finance records to ensure accuracy.

Highlight overdue accounts and alert the sales team.

Coordinate with accounts/finance for reconciliation queries.

Maintain region- and partner-wise AR aging summary.

4: Sales Promotion, POS & Social Media Reports

Brief: Track deployment and effectiveness of sales promotions, POS materials, and digital campaigns.

Roles & Responsibilities:

Maintain POS material inventory and usage report.

Track scheme-wise sales impact and consumption.

Prepare zone-wise promotion activity summaries.

Coordinate with marketing for digital/social post data.

Maintain campaign-wise lead or sales conversion reports.

5: Stock Reporting (SS, Distributors, Retailers)

Brief: Maintain weekly inventory levels at trade partner locations to aid demand planning and replenishment.

Roles & Responsibilities:

Collect and compile stock data from SS, Distributors, and key retailers.

Validate inventory levels against secondary sales.

Identify slow-moving or overstocked SKUs.

Prepare channel-wise inventory heatmaps.

Share reports with supply chain and sales managers.

6: Credit Note & Scheme Management

Brief: Ensure accurate credit note reporting and timely circulation of trade schemes.

Roles & Responsibilities:

Track issued credit notes and maintain summary reports.

Validate scheme-wise distributor eligibility and claims.

Prepare monthly credit note usage dashboards.

Circulate scheme circulars to all stakeholders.

Archive scheme approvals, claim records, and usage audit data.

7: Demand Forecasting Support

Brief: Provide accurate and forward-looking sales data to support plant-level production and dispatch planning.

Roles & Responsibilities:

Collect market forecast from sales team by 5th of each month.

Prepare consolidated demand sheet SKU-wise and zone-wise.

Share the sheet with the plant 10 days before month end.

Analyze past sales and trends to guide demand planning.

Coordinate with plant if revisions are required.

8: Order & Rate List Management

Brief: Ensure accuracy in sales order entries, product rates, and timely circulation of rate changes.

Roles & Responsibilities:

Enter orders into ERP with 100% SKU accuracy.

Maintain latest rate cards and update in system and circulation.

Communicate pricing changes to sales, accounts, and plant.

Assist in margin structure preparation.

Verify invoice values against order and rate list.

9: TA/DA & Expense Reports

Brief: Maintain accurate travel/expense records of sales team and flag discrepancies.

Roles & Responsibilities:

Collect TA/DA claims of sales team.

Prepare summary and validate entries as per policies.

Highlight anomalies to HR/accounts.

Maintain monthly expense trend summaries.

Ensure timely reporting for reimbursement processing.

10: Trade Partner Documentation (KYC/Legal)

Brief: Maintain legal and KYC documentation for all SS and Distributors as per compliance norms.

Roles & Responsibilities:

Maintain KYC records (GST, PAN, bank, Aadhar) for all partners.

Archive legal documents like agreements, NDAs, MoUs.

Coordinate with legal team for documentation accuracy.

Ensure 100% partner compliance checklist availability.

Share documentation periodically with audit/finance.

Additional Key Responsibilities:

Beyond regular KRAs, the MIS Executive is also expected to:

1. Support Sales Reviews: Prepare PPTs, dashboards, and insights for weekly/monthly sales reviews with CSMO.

2. Assist with Audit & Compliance: Provide data for internal or external audits on sales, schemes, POS, or trade partner records.

3. Sales Tool/Data Hygiene: Monitor the accuracy and completeness of entries in DMS/SFA/CRM platforms.

4. Documentation & Version Control: Ensure proper versioning and backups of all MIS reports and master files.

5. Training & Support: Guide new sales team members on reporting formats and tools usage.

________________________________________

Qualifications & Experience:

Education:

• Bachelor's Degree in Business Administration, Commerce, or equivalent.

Experience:

• 3-5 years of experience in MIS/Reporting, Dashboards in dairy or food products (FMCG experience preferred).

• Must Have: Excellent level in MS Excel & Advanced Reporting, Word, Power Point.

• Good to Have: Dashboards in Power BI

________________________________________

Additional Information:

Work Environment:

• 6-day workweek (Monday to Saturday).

Shift:

• General (9:00 AM – 6:00 PM); may vary based on business needs.

Other Requirements:

• Must own a two-wheeler with valid license and insurance.

Job Type: Full-time

Pay: ₹20,000.00 - ₹50,000.00 per month

Benefits:

• Health insurance
• Life insurance
• Paid sick time
• Provident Fund

Schedule:

• Day shift

Experience:

• FMCG or Dairy industry: 1 year (Required)
• advanced excel: 2 years (Required)

Location:

• Ahmedabad, Gujarat (Preferred)

Work Location: In person