Intern - Business Analytics

About the RoleWe're seeking a motivated and analytical Data Analytics Intern to join our growing team in Mumbai .This is a 6-month full-time internship with the potential for conversion to a full-time role based on individual and company performance. You'll work closely with cross-functional teams to transform data into actionable insights that drive business decisions in the fast-paced healthcare and e-commerce space.Key ResponsibilitiesData Cleaning & Preparation: Clean, validate, and prepare large datasets from multiple sources (retail stores, e-commerce platform, inventory systems) to ensure data quality and integrity.Ad-hoc Analysis: Respond to business queries by conducting exploratory data analysis and presenting findings to stakeholders across operations, marketing, and supply chain teams.Dashboard Development: Build and maintain interactive dashboards using Tableau to track key business metrics such as sales performance, inventory levels, customer behavior, and operational efficiency.Project Support: Collaborate with product, operations, and business teams on specific projects to provide data-driven recommendations.Automation: Identify repetitive tasks and build automated solutions using Python and SQL to improve efficiency and reduce manual effort.Reporting: Generate regular reports for management highlighting trends, anomalies, and opportunities for improvement.QualificationsRequired:Bachelor’s degree (B.Sc./B.Tech/B.E.) in any Science stream or Engineering (Mathematics must be one of the subjects studied)Strong foundation in mathematics and statisticsProficiency in SQL for data extraction and manipulationWorking knowledge of Python (pandas, numpy, matplotlib/seaborn)Advanced Microsoft Excel skills (pivot tables, VLOOKUP, formulas)Experience with Tableau or willingness to learn quicklyStrong problem-solving skills and attention to detailExcellent communication skills to present findings to non-technical stakeholdersGood to Have:Prior internship or project experience in data analyticsUnderstanding of basic statistical concepts and A/B testingFamiliarity with healthcare, retail, or e-commerce domainsExperience with data automation and scriptingKnowledge of Git for version controlWhat You’ll LearnReal-world application of data analytics in a high-growth healthcare startupExperience working with large-scale retail and e-commerce datasetsBuilding production-grade dashboards and automated reporting systemsCollaborating with cross-functional teams in a fast-paced environmentBusiness acumen in the pharmacy and healthcare sectorWork ArrangementLocation: Mumbai (Hybrid model)Duration: 6 months full-time internshipConversion: Opportunity for full-time employment based on performanceTechnical SkillsSQL:Proficiency in writing complex queries, joins, subqueries, and data manipulation (SELECT, WHERE, GROUP BY, HAVING, etc.)Python:Working knowledge of Python for data analysis including:Data manipulation libraries (pandas, numpy)Data visualization libraries (matplotlib, seaborn)Basic scripting and automationMicrosoft Excel:Advanced proficiency including:Pivot tables and pivot chartsComplex formulas (VLOOKUP, INDEX-MATCH, IF statements)Data cleaning and transformationBasic macros (preferred)Tableau:Ability to create interactive dashboards and visualizations (or strong willingness to learn)Statistics:Understanding of basic statistical concepts (mean, median, standard deviation, correlation, distributions)Data Cleaning:Experience with data validation, handling missing values, outlier detection, and data transformation