Company: Immunosciences
Location: Okhla Phase 3, New Delhi
Experience: 4–9 Years (Relevant hands-on experience mandatory)
Employment Type: Full-time
Working Days: 6 Days a Week
Job Summary
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.
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.
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.
2. D2C & E-commerce Data Analytics
- 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.
3. Marketing & Performance Analytics
- Analyse digital marketing performance across Meta Ads, Google Ads and other marketing channels.
- Track CAC, ROAS, ROI, CPA, CTR, CPC and conversion rates.
- Prepare campaign-wise and platform-wise performance reports.
- Analyse marketing spend against revenue generated.
- Measure influencer and affiliate campaign performance wherever applicable.
- Provide insights on customer acquisition costs and marketing efficiency.
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.
5. Data Analysis & Automation
- 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.
6. Cross-Functional Coordination
- 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.
Required Technical Skills & Tools
Must-Have Skills:
- 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.
D2C & E-commerce Tools (Preferred):
- 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.)
Additional Advantage:
- Knowledge of ETL and data integration.
- Experience with APIs and automated data extraction.
- Knowledge of MySQL / PostgreSQL.
- Experience with BigQuery.
- Understanding of data warehousing and database management.
- Experience with forecasting, cohort analysis and customer segmentation.
Eligibility & Qualifications
- Bachelor's degree in Statistics, Mathematics, Computer Science, Data Analytics, IT, Commerce or a related field.
- 2–4 years of relevant professional 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.
What We Are Looking For
- A candidate who can independently handle end-to-end MIS and data analytics.
- Someone comfortable working with large volumes of D2C business data.
- Ability to convert raw data into meaningful business insights.
- Strong understanding of sales, marketing, customer and operational metrics.
- A proactive professional who can automate reports and build scalable dashboards.
Apply Now
Interested candidates can share their updated resume at:
Email: hr@immunosciences.in
Contact: +91 9910908132
Website: https://www.immunosciences.in/
Location: Okhla Phase 3, New Delhi
Pay: ₹30,000.00 - ₹50,000.00 per month
Benefits:
Work Location: In person
