MIS cum Sales Coordinator
Role Overview
Owns sales data and reporting across channels, regions, and species.
Coordinates with sales and operations on orders and dispatches and converts transaction datasets into decision-ready reports.
Key Skills for This Role
Full Job Posting
About the company
Indepesca Overseas imports and distributes premium seafood under the Big Sam's brand.
It serves HoReCa, modern trade, general trade, retail, and D2C e-commerce customers across Indian cities, supported by a processing facility and cold-chain network.
Role summary
Owns sales data and reporting across channels, regions, and species.
Coordinates with sales and operations on orders and dispatches and converts transaction datasets into decision-ready reports.
MIS and reporting
- Prepare daily, weekly, and monthly primary and secondary sales MIS by region, channel, sales manager, customer, and species.
- Maintain and reconcile a Sales Master database with over 100,000 transaction rows.
- Build Excel dashboards and management review decks; prepare target-versus-achievement reports, incentive inputs, and scorecards.
- Monitor receivables and outstanding reports and share ageing and collection follow-up lists.
Sales coordination and data governance
- Coordinate orders, dispatch planning, and delivery confirmation across sales, warehouse/cold storage, logistics, and accounts.
- Track OMS orders and resolve order, pricing, and invoicing discrepancies.
- Maintain customer masters, price lists, schemes, and rate contracts; support key accounts, distributors, follow-ups, claims, and secondary-sales data.
- Standardize data formats, reconcile SAP, OMS, and Excel figures, and identify reporting automation opportunities.
Must-have skills
- Advanced Excel, including pivot tables, lookup functions, formulas, data validation, conditional formatting, charts, and dashboards.
- Clear written and verbal English and Hindi communication.
- Accuracy, cross-checking, deadline management, ownership, and stakeholder coordination.
Added advantages
- Power BI or similar BI tools; Power Query or Excel VBA macros.
- Working knowledge of SAP and Google Sheets.
- Experience in FMCG, food, frozen/seafood, or cold-chain distribution.
Qualification and experience
- Graduate in Commerce, Business Administration, Statistics, or a related field; MBA/PG preferred.
- At least five years of experience in Sales MIS, Sales Coordination, or Sales Operations.
Working conditions
- Office-based role in Bandra, Mumbai; workdays and hours follow company policy.
- Occasional extended hours may be required during month-end closing and management reviews.
Pay
- ₹35,000–₹45,000 per month.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career