HLOOKUP Jobs

Candidate should have good experience in generating intelligence report to improving the business, reports should be available quickly in different types of parameters to support the team to quickly adopt and improve

We are seeking a Senior MIS Executive with 4 to 6 years of experience to join our team in Chandigarh. This full-time role requires a dedicated male candidate to work from the office.**Key Responsibilities:**- **Data Management:** Collect, organize, and maintain large volumes of data to ensure accuracy and accessibility for decision-making processes.- **Report Preparation:** Develop and generate routine and ad-hoc reports that provide insights into business performance, helping management to make informed decisions.- **Analysis and Insights:** Analyze trends and patterns in the data to identify areas for improvement, and provide actionable insights to various departments.- **Collaboration:** Work closely with other teams, including finance and operations, to gather information and understand their reporting needs, ensuring alignment with organizational goals.- **Process Improvement:** Recommend enhancements to existing reporting processes to increase efficiency and effectiveness, making it easier for stakeholders to access relevant information.- **Training and Support:** Provide guidance and support to junior team members and other staff on reporting tools and techniques, fostering a culture of data-driven decision-making.**Required Skills and Expectations:**- Proficiency in MIS tools, Excel, and data visualization software is essential for creating detailed reports and presentations.- Strong analytical skills with the ability to interpret complex data sets and provide insights that contribute to strategic planning.- Good communication skills, both written and verbal, are necessary to convey information clearly and effectively to all levels of the organization.- Ability to work independently and manage time effectively to meet deadlines without compromising quality. - Understanding of business operations and metrics to help achieve organizational objectives.

1. Sales & Performance MIS Prepare daily, weekly, and monthly MIS reports for skincare sales, revenue, returns, and cancellations Track key e-commerce KPIs: GMV, Net Sales, AOV, Conversion Rate, ROAS, CAC Monitor performance by SKU, category (cleansers, serums, moisturizers, sunscreens), and channel 2. Marketplace & D2C Reporting Track performance across platforms such as Amazon, Flipkart, Myntra, Nykaa, and Shopify Monitor order flow, fulfillment status, RTO, refunds, and delivery TAT Reconcile sales data with marketplace and payment reports 3. Inventory, Batch & Expiry MIS (Skincare-Specific) Maintain SKU-wise inventory reports including batch numbers and expiry dates Track near-expiry stock and support liquidation / discount planning Monitor stock ageing, replenishment needs, and out-of-stock risks Coordinate with warehouse and supply chain teams for stock accuracy 4. Pricing, Promotions & Campaign Analysis Track discounts, offers, and campaign performance (sale days, influencer campaigns, launches) Analyze price changes, margin impact, and contribution by SKU Support marketing teams with campaign performance data5. Returns & Quality MIS Analyze return reasons (damaged, leakage, allergic reaction, incorrect item) Track customer complaints and feedback trends Share insights with QA and product teams to reduce return rates 6. Data Accuracy & Process Improvement Ensure accuracy and consistency across all MIS reports Automate reports using Excel, Google Sheets, or BI tools Maintain documentation and SOPs for reporting processes Required Skills & Qualifications Bachelors degree in Commerce, Business, IT, or related field 13 years of MIS / data reporting experience (beauty, skincare, FMCG preferred) Advanced Excel / Google Sheets (Pivot Tables, XLOOKUP, formulas, dashboards) Strong understanding of e-commerce operations and inventory management High attention to detail due to batch & expiry-sensitive products

Key Responsibilities:Prepare and maintain daily, weekly, and monthly MIS reportsAnalyze business data and generate performance dashboardsCoordinate with different departments for data collection and validationSupport management in decision-making through accurate data insightsEnsure timely submission and accuracy of all MIS reports

Hiring for 5 MIS Executive Jobs in Ranchi with minimum 2 Years Experience,Required Educational Qualification is : B.Com, Post Graduate Diploma, M.Com with Good knowledge in Data Analysis, Advanced Excel, MIS Reporting, Data Validation, Powerpoint, HLOOKUP, VLOOKUP, MIS etc.