Mis Executive

Balar Marketing; Mumbai; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Rewards Plus Loyalty Program in Mumbai is seeking a detail-oriented Data Analyst / MIS Executive to support data management, MIS reporting, dashboards, analysis, and process improvement, including SAP master data, pricing, vendor data, and BOM activities.

The role emphasizes managing loyalty program data, preparing daily to monthly MIS reports, Excel dashboards, and providing insights to stakeholders, with responsibilities for data validation, reconciliation, and reporting automation.

Qualifications

• Bachelor's degree in IT, Computer Science, Business Analytics, Commerce or related field.
• 13 years of experience in MIS, data analysis, or business reporting.
• Experience with SAP, CRM, loyalty programs, or sales analytics is an advantage.
• Power BI knowledge is an added advantage.
• Advanced Excel skills (VLOOKUP, XLOOKUP, Pivot Tables) and data validation.

Responsibilities

• Manage loyalty program, sales, and master data with accuracy and timely updates.
• Prepare daily, weekly, and monthly MIS reports, Excel dashboards, and management reports.
• Analyse registrations, scans, redemptions, engagement, sales, and business metrics.
• Prepare sales, promotional, average sales, and year-on-year reports.
• Maintain Excel templates for item/BOM creation, pricing, discounts, and vendor price lists in SAP.
• Conduct data validation, reconciliation, and purchase/sales rate checks.
• Identify discrepancies and coordinate with IT, internal teams, and vendors for resolution.
• Provide customized reports and insights to stakeholders.
• Improve reporting through Excel automation, standardized templates, and dashboards.

Skills

Advanced Excel

Power BI

Data analysis

Dashboards

Stakeholder coordination

Education

Bachelor's degree in IT, Computer Science, Business Analytics, Commerce

Tools

SAP

CRM

Loyalty programs

Job description

Job Description Data Analyst / MIS ExecutiveLocation:

Andheri, Mumbai

Job Summary

Detail-oriented Data Analyst / MIS Executive to support the Rewards Plus Loyalty Program through data management, MIS reporting, dashboards, analysis, and process improvement, including SAP master data, pricing, vendor data, and BOM activities.

Key Responsibilities

• Manage loyalty program, sales, and master data with accuracy and timely updates.
• Prepare daily, weekly, and monthly MIS reports, Excel dashboards, and management reports.
• Analyse registrations, scans, redemptions, engagement, sales, and business metrics.
• Prepare sales, promotional, average sales, and year-on-year reports.
• Maintain Excel templates for item/BOM creation, pricing, discounts, and vendor price lists in SAP.
• Conduct data validation, reconciliation, and purchase/sales rate checks.
• Identify discrepancies and coordinate with IT, internal teams, and vendors for resolution.
• Provide customized reports and insights to stakeholders.
• Improve reporting through Excel automation, standardized templates, and dashboards.

Key Skills

• Advanced Excel VLOOKUP, XLOOKUP, Pivot Tables, SUMIFS, COUNTIFS, IF formulas, dashboards, and data validation.
• Strong analytical, problem-solving, and data-management skills.
• High attention to detail and data accuracy.
• Good communication and stakeholder coordination.
• Ability to work with large datasets and meet deadlines
• .

Preferred Qualifications

• Bachelor's degree in IT, Computer Science, Business Analytics, Commerce, or related field.
• 13 years of experience in MIS, data analysis, or business reporting.
• Experience with SAP, CRM, loyalty programs, or sales analytics is an advantage.
• Power BI knowledge is an added advantage.

Key Performance Areas

• Accurate and timely MIS reporting and dashboards.
• Data and master-data accuracy.
• Accurate pricing and sales validation.
• Timely resolution of data discrepancies.
• Improved reporting automation and process efficiency.
• Quality of data-driven business insights.