MIS Analyst

Job Title: MIS Analyst Company: Immunosciences Job Category: Data Science Roles & Responsibilities: Immunosciences is looking for a highly analytical and technically skilled MIS \& Data Analyst to manage, analyse and interpret large volumes of business data, particularly across D2C (Direct\-to\-Consumer) and e\-commerce operations. The candidate will be responsible for developing automated reports, creating interactive dashboards, analysing sales and marketing performance, tracking business KPIs and providing actionable insights to support business decisions. Key Responsibilities1\. MIS Reporting \& Data Management * Prepare daily, weekly and monthly MIS reports for management. * Manage, consolidate and analyse large datasets from multiple business sources. * Maintain sales, revenue, order, inventory, customer and marketing performance reports. * Develop automated reporting systems to reduce manual efforts. * Ensure data accuracy, consistency and timely reporting. * Build and maintain centralised databases and reporting structures. * Analyse D2C sales performance across the company's website and online sales channels. * Track orders, revenue, AOV (Average Order Value), conversion rates, cancellations, returns and refunds. * Analyse customer acquisition, repeat purchases, retention and customer lifetime value (CLTV). * Monitor SKU\-wise, product\-wise and category\-wise sales performance. * Track website traffic, conversion funnels and customer buying behaviour. * Analyse COD vs prepaid orders, RTO (Return to Origin) and delivery performance. * Monitor channel\-wise revenue and profitability. * Identify trends, gaps and opportunities to improve business performance. 4\. Dashboard Development \& Data Visualisation * Create interactive dashboards using Tableau and/or Power BI. * Develop real\-time or regularly refreshed business performance dashboards. * Build management dashboards covering sales, marketing, inventory and operations. * Connect multiple data sources for consolidated reporting. * Present complex data in an easy\-to\-understand visual format. * Use Python for data cleaning, data processing, analysis and automation. * Write SQL queries to extract, filter and analyse data from databases. * Automate repetitive reports and data workflows. * Identify data discrepancies and troubleshoot reporting issues. * Perform trend analysis, customer segmentation and business performance analysis. * Generate actionable insights and recommendations for management. * Coordinate with marketing, sales, finance, operations and e\-commerce teams. * Understand business requirements and develop relevant reports. * Support management with data\-backed business decisions. * Maintain proper documentation of reports, data sources and reporting processes. * Advanced MS Excel – Pivot Tables, XLOOKUP, VLOOKUP, INDEX\-MATCH, Power Query, Power Pivot and advanced formulas. * SQL – Data extraction, joins, subqueries, aggregations and query writing. * Python – Pandas, NumPy, data cleaning, analysis and automation. * Tableau / Power BI – Dashboard creation, data modelling and visualisation. * Google Sheets – Advanced formulas, data management and reporting. * Data analysis, interpretation and business reporting. * Shopify / WooCommerce * Google Analytics 4 (GA4\) * Google Search Console * Meta Ads Manager * Google Ads * CRM and customer data platforms * Razorpay / payment gateway reports * Shiprocket / courier and logistics dashboards * Unicommerce / other order management systems * Marketplace seller dashboards (Amazon, Flipkart, etc.) Work Location: In person Work Location: Delhi, India Availability: Full time

Company: Immunosciences Location: Okhla Phase 3, New Delhi Experience: 2 years (Relevant hands\-on experience mandatory) Employment Type: Full\-time Working Days: 6 Days a Week We are looking for someone with strong expertise in Advanced Excel, SQL, Python, Tableau/Power BI and hands\-on experience working with D2C, e\-commerce and marketing data. Required Technical Skills \& Tools Eligibility \& Qualifications * Bachelor's degree in Statistics, Mathematics, Computer Science, Data Analytics, IT, Commerce or a related field. * 2 years of experience in MIS, Business Analytics or Data Analytics. * Mandatory hands\-on experience in Excel, SQL and Python. * Practical experience in Tableau or Power BI. * Prior experience handling D2C, e\-commerce or retail business data is strongly preferred. * Ability to independently manage large datasets and build automated reporting systems. * Strong analytical thinking and problem\-solving abilities. * Excellent attention to detail and communication skills. Benefits: Key Skills: Python, SQL, Pandas, NumPy, Statistics, Power BI, Tableau Salary: INR 30000 - 50000 per monthly