Mis Executive

Job Description Data Analyst / MIS ExecutiveLocation: Andheri, Mumbai
Job SummaryDetail-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.