About Us
Welcome to Swiss Beauty, the fastest-growing beauty and cosmetics brand in India. Established in 2013, Swiss Beauty aims to be the ultimate companion and BFF of every makeup lover, transforming beauty routines into extraordinary experiences. With a focus on Indian beauty needs, we merge global cosmetic standards with our expertise to create highly innovative, long-lasting, and comfortable products. Our mission is to elevate beauty to Swiss standards and offer game-changing products that set new benchmarks in the industry. We believe that makeup knows no boundaries and is for everyone. Join us on this remarkable journey as we redefine beauty norms and celebrate individuality. About The Opportunity This role is critical to enabling data-driven decision-making in Modern Trade by ensuring visibility on sales performance, profitability, inventory health, and promotional effectiveness. The Modern Trade MIS professional supports leadership with accurate, timely, and actionable insights across sales, margins, promotions, inventory, and claims to drive profitable growth. Role & Responsibilities
• Prepare daily, weekly, and monthly MIS for Modern Trade accounts.
• Track primary billing, secondary sales, and off-take by chain, store, SKU, and region.
• Monitor achievement vs targets, LY, and growth trends.
• Support current product launch performance analysis.
• Track chain-wise margins including front-end and back-end margins.
• Analyze scheme impact on net realizations and profitability.
• Highlight margin deviations and potential leakage.
• Track promotion plans vs actual performance.
• Measure promo effectiveness and ROI.
• Monitor scheme compliance across Modern Trade partners.




• Monitor depot stock, stock-in-trade (SIT), and pipeline inventory.
• Track inventory ageing, slow-moving SKUs, and expiry risks.
• Report on fill rate, OSA, and stock availability issues.
• Track sales returns, damages, and expiry claims.
• Validate debit notes and coordinate claim closure with finance.
• Maintain claims ageing and closure MIS.
• Ensure accuracy and consistency of data received from MT partners.
• Maintain SOPs for MIS reporting and data validation.
• Ensure timely circulation of reports to stakeholders.
• Prepare dashboards and presentations for senior management.
• Provide actionable insights, risks, and opportunities.
• Support forecasting, budgeting, and annual business planning. Skills & Qualifications
• Strong analytical skills with attention to detail.
• Advanced Excel / Google Sheets (Pivot Tables, VLOOKUP/XLOOKUP, Power Query preferred).
• Understanding of Modern Trade business economics.
• Ability to work cross-functionally with Sales, Finance, SCM, and Marketing.
• Strong communication and stakeholder management skills.
• Graduate / Postgraduate in Commerce, Management, or related field.
• 2–6 years of experience in Modern Trade MIS / Sales Analytics (FMCG / Beauty preferred). Benefits & Culture Highlights
• This role directly impacts strategic decision-making and business profitability through data insights.
• Cross-functional exposure with Sales, Finance, SCM, and Marketing teams.
• Opportunity to influence Modern Trade performance metrics and KPIs.

Skills:
power query,modern trade,pivot tables,excel,advance excel,xlookup,vlookup,google sheets

📌 Modern Trade MIS Executive (Gurugram)
🏢 Swiss Beauty
📍 Gurugram