Sales MIS analyst

Job Summary: (URGENT HIRING) We are seeking a detail-oriented and analytical Sales MIS Executive to manage, maintain, and analyze sales data effectively. The ideal candidate will be proficient in Advanced Excel and Google Sheets, capable of generating insightful reports and dashboards to support the sales team in achieving targets and improving overall business performance. Key Responsibilities: Maintain and update real-time sales data using Google Sheets and Excel. Prepare daily, weekly, and monthly MIS reports covering sales performance, target vs achievement, and productivity metrics. Analyze sales trends and develop dashboards for quick business insights and decision-making. Coordinate with sales teams to ensure timely and accurate updates of sales data and lead statuses. Automate repetitive reports using Excel formulas, pivot tables, macros, and Google Sheets scripts as needed. Generate detailed performance reports by region, product, and customer segments. Track and monitor key performance indicators (KPIs) such as lead conversion rates, sales pipeline status, billing, collections, and order fulfillment. Analyze and report on profit margins to identify opportunities for improvement and ensure business profitability. Assist in forecasting sales, budgeting, and conducting variance analysis. Ensure data accuracy, consistency, and integrity across all reports. Provide ad-hoc analytical support and reports for management as required. Key Skills Required: Advanced Excel: Expertise in VLOOKUP/XLOOKUP, INDEX-MATCH, Pivot Tables, Charts, Power Query, and Macros. Google Sheets: Proficiency in QUERY, IMPORTRANGE, Data Validation, and basic knowledge of App Script preferred. Strong analytical and numerical aptitude. Keen attention to detail with a commitment to data accuracy. Ability to handle multiple tasks and work effectively under deadlines. Excellent communication and coordination skills to work with sales and management teams. Experience with CRM or ERP systems is a plus but not mandatory. Educational Qualification: Graduate in Commerce, Business Administration, or a related field. Certification in Advanced Excel or Data Analysis is preferred. Walk-in Interview Details: Time 10:00 AM - 6:00 PM 229, Udyog kendra I, Ecotech III, Greater Noida, Khera Choganpur, Uttar Pradesh 201306 Job Types: Full-time, Permanent, Fresher Pay: ₹25,000.00 - ₹40,000.00 per month Benefits: Health insurance Provident Fund Schedule: Day shift Work Location: In person