Job Description

Position: Senior executive | Assistant Manager Sales and Business MIS

About the Role: We are seeking an experienced and detail-oriented professional to manage our sales and business MIS function. The person will be responsible for to manage, analyse, and present business and sales data through accurate MIS reports, dashboards, and analytical insights that support management decision-making, sales performance tracking, forecasting, and operational efficiency.

This role requires in-depth business performance reporting acumen as well as hands-on experience to ensure seamless reporting.

Key Responsibilities

A. SALES MIS REPORTING

1. Prepare daily, weekly, monthly, quarterly and yearly sales MIS reports

2. Generate region-wise, product-wise, customer-wise, and salesperson-wise sales reports

3. Track achievement against sales targets and budgets

4. Monitor sales trends, growth analysis, and variance reporting

5. Prepare dashboards for management review meetings

B. BUSINESS PERFORMANCE ANALYSIS

1. Analyse revenue, margins, pricing, profitability, and business KPIs

2. Identify business performance gaps and provide analytical insights

3. Support management in strategic decision-making through data analysis

4. Conduct comparative analysis of actual vs budget vs forecast

C. DATA MANAGEMENT AND ACCURACY

1. Maintain accuracy and integrity of sales and business data.

2. Validate data received from sales teams, ERP systems, Customers and Other entities

3. Ensure timely data consolidation from various business units and entities

4. Manage master data related to customers, products, pricing, rebates, commissions and sales hierarchy

D. DASHBOARD AND AUTOMATION

1. Develop and maintain MIS dashboards using:

• MS Excel
• Power BI
• ERP systems – SAP

2. Automate repetitive reports to improve efficiency

3. Create pivot reports, macros, and data visualization tools

E. FORECASTING AND PLANNING SUPPORT

1. Assist in sales forecasting and demand planning

2. Support annual operating plan and budgeting exercises

3. Track rolling forecasts and business projections

4. Coordinate with sales and finance teams for forecast accuracy

F. COORDINATION AND STAKEHOLDER MANAGEMENT

1. Coordinate with sales, finance, supply chain, commercial team and senior management

2. Ensure timely submission of reports and data inputs

3. Support management review presentations

G. KPI MONITORING

1. Sales growth %

2. Gross margin %

3. Collection efficiency

4. Sales per customer

5. Product profitability

6. Target achievement %

7. Channel performance

8. Order fulfilment ratio

H. COMPLIANCE AND CONTROL

1. Ensure confidentiality of business information

2. Maintain reporting SOPs and documentation

3. Ensure adherence to reporting timelines and internal controls

4. Support audit requirements related to sales and MIS data

Qualifications & Requirements

• B. Com | BBA | MBA Finance | MBA Operations
• Additional certification in Excel, Power BI, or Data Analytics preferred
• 2–6 years in MIS reporting, sales analytics, or business reporting
• Experience in manufacturing, FMCG, packaging, distribution, or industrial sectors preferred
• Good knowledge of excel (Pivot tables, V-lookup, X-lookup, Power query, Macros). Hands on experience in SAP (B1/Hana) preferred
• Good behavioral skills, analytical thinking, attention to details, problem solving ability, time management and good co-ordination skills
• Excellent command of English, both written and verbal, is essential for effective communication.
• Must be based in or willing to relocate to Navi Mumbai.

More Info

Education