Mis Associate

Orient Bell; Delhi Cantonment; On-site; INR 450,000 - 600,000; Full time

Job summary

Orient Bell in New Delhi seeks an MIS Associate to support the sales team with accurate, timely data. You will build daily, weekly, and monthly reports and dashboards across zones, regions, and channels, and assist with order and incentive data.

The role requires 1–3 years in MIS or data analysis, with a Diploma or graduate qualification, and hands‑on Excel/SAP experience. On-site at Head Office, Delhi.

Qualifications

• Build and maintain daily, weekly and monthly sales reports and dashboards.
• Analyze primary/secondary sales, targets vs achievement and collections.
• Support field sales with order, scheme and incentive data.
• Maintain accurate dealer and customer master data.

Responsibilities

• Prepare daily, weekly and monthly sales reports for multiple zones and channels.
• Develop dashboards by zone, region, territory and channel for management reviews.
• Track performance against targets and share variance analysis with leadership.
• Create MIS decks and data packs for monthly meetings.
• Pull ERP/SAP data for orders, dispatch, inventory and exceptions.
• Monitor schemes and dealer incentives and assist with payout calculations.
• Coordinate with HR/Finance for sales incentive calculations.

Skills

Data analysis

MIS reporting

Sales reporting

Advanced Excel

SQL basics

Power BI/Tableau

ERP understanding (SAP)

PowerPoint

Education

Diploma or graduate

Tools

SAP

Power BI

Tableau

Excel VBA

Power Query

SQL

Job description

Job Title - MIS Associate(Sales Support)

Location - Head Office, New Delhi (Nangal Raya)

Employment Type - Full-Time/Off-roll

Experience - 1-3 years in MIS, sales reporting or data analysis

Qualification - Diploma, any graduate

Role Purpose

The MIS Associate gives the sales team accurate, on-time data to track targets and make decisions. The role builds and maintains daily, weekly and monthly sales reports and dashboards across zones, regions and channels. It also supports the field sales team with order, scheme and incentive data.

Key Responsibilities

• Prepare daily, weekly and monthly sales reports: primary and secondary sales, target vs achievement, growth and collections.
• Build and maintain dashboards by zone, region, territory, product category and channel (dealers, retailers, projects, distributors).
• Track sales team performance against targets and share variance reports with sales leadership.
• Prepare MIS decks and data packs for monthly business reviews and management meetings.
• Pull order, dispatch, outstanding and inventory data from ERP/SAP and share it with field sales teams.
• Track schemes, discounts and dealer incentive programs; calculate payouts and validate claims.
• Support sales incentive calculations for the field team in coordination with HR and Finance.
• Maintain dealer and customer master data and keep it updated.

Skills and Competencies

• Advanced MS Excel: Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, conditional formatting, charts.
• Working knowledge of SAP or another ERP for sales and dispatch data.
• MS PowerPoint for management presentations.
• Good to have: Power BI or Tableau, Excel macros/VBA, Power Query, basic SQL.