Apollo Hospitals Group

Business Analyst - Pharma Category (2-4 yrs) Role Overview:The Business Analyst - Pharma Category will be responsible for building and maintaining analytical infrastructure to support data-driven decision making across Apollo Pharmacy's category operations. This role involves creating dynamic dashboards, automating reporting processes, and conducting deep-dive customer analytics to drive category growth and operational efficiency.Key Responsibilities:1. Dashboard Development & Automation:- Dynamic Dashboard Creation: Develop interactive dashboards in Power BI and Google Sheets for real-time business monitoring and category performance at national, regional, cluster, and store levels - Process Automation: Automate recurring reports and data workflows to improve efficiency and reduce manual effort- Data Visualization: Design intuitive and actionable visualizations, especially on Geospatial analytics that enable quick decision-making by business teams- Dashboard Maintenance: Ensure data accuracy, troubleshoot issues, and continuously improve dashboard performance2. Category Performance Analytics:- Growth & margin analysis: Conduct detailed analysis of category performance across different dimensions (geography, time, customer segments, therapies)- Competitive Intelligence: Monitor market share trends and competitive positioning through data analysis- Promotional Impact: Measure effectiveness of promotional campaigns and initiatives through before/after analysis- Trend Identification: Identify emerging trends, seasonal patterns, and growth opportunities within pharma categories3. Inventory & Fill Rate Analytics:- Inventory Performance: Monitor and analyze inventory levels, fill rates, stock-outs, and replenishment cycles across therapeutic categories to support inventory optimization decisions- Demand Forecasting Support: Assist in demand planning through historical trend analysis and seasonality identification4. Customer Analytics & Segmentation:- Customer Segmentation: Apply clustering techniques to segment customers based on purchasing behavior, demographics, and engagement patterns- Acquisition & Retention Analysis: Analyze customer retention rates, churn patterns, and lifetime value across different segments- Behavioral Analysis: Conduct deep-dive analysis on customer purchasing patterns, frequency, and category preferences- Cohort Analysis: Perform cohort-based analysis to understand customer journey and engagement evolution- Predictive Modeling: Develop models to predict customer behavior, churn probability, and purchase propensity5. Business Analytics Support:- Root Cause Analysis & strategic support: Conduct detailed investigations into performance variations and business anomalies. Provide analytical insights to support strategic initiatives and business planning- Strategic Support: Data Quality: Ensure data integrity and accuracy across all analytical outputs- Stakeholder Reporting: Present findings and recommendations to various stakeholders in clear, actionable formatsTechnical Requirements:Core Technical Skills:- Advanced Excel: Expert-level proficiency in Excel including advanced formulas, pivot tables, macros, and VBA- SQL Programming: Strong SQL skills for data extraction, transformation, and analysis from databases- Power BI: Proficiency in Power BI for dashboard creation, data modeling, and visualization- Google Workspace: Advanced skills in Google Sheets, Big query, and other Google analytics toolsData Science & Analytics:- Data Science Techniques: Knowledge of clustering algorithms (K-means, hierarchical), segmentation methods, and classification techniques- Machine Learning Basics: Familiarity with predictive modeling concepts, regression analysis, and data mining techniques- Programming Knowledge: Basic knowledge of Python or R for advanced analytics Business Intelligence Tools:- Data Modeling: Understanding of data warehouse concepts, ETL processes, and data modeling best practices- Automation Tools: Knowledge of automation techniques for recurring reports and data workflowsKey Performance Indicators (KPIs):1. Dashboard Delivery: Timely delivery of accurate dashboards and reports as per business requirements2. Data Accuracy: Maintain >98% data accuracy across all analytical outputs and dashboards3. Automation Efficiency: Automate 80% of recurring reports to reduce manual effort4. Insight Quality: Provide actionable insights that lead to measurable business improvements5. Process Improvement: Identify and implement process improvements to enhance analytical efficiencyRequired Qualifications:Educational Background:- Bachelor's degree in Engineering, Mathematics, Statistics, Economics, or related quantitative field- MBA or advanced degree in Analytics/Data Science is a plus- Relevant certifications in Power BI, SQL, or data analytics tools preferredExperience Requirements:- 1-3 years of experience in business analytics, data analysis, or business intelligence roles- Prior experience in retail, e-commerce, or healthcare analytics is a plus- Experience with large datasets and complex business problems- Track record of creating impactful dashboards and analytical solutionsSoft Skills:- Analytical Thinking: Strong problem-solving abilities and attention to detail- Business Acumen: Understanding of retail business operations and key performance metrics- Project Management: Ability to manage multiple analytical projects simultaneously- Continuous Learning: Eagerness to learn new tools and techniques in the rapidly evolving analytics spaceWhat We Offer:- Opportunity to work with one of India's largest pharmacy chains and operate on large complex data sets- Career growth in Data science and business analytics domain- Collaborative environment with direct access to senior leadershipIdeal Candidate Profile:- We are seeking a technically proficient, detail-oriented analyst who is passionate about turning data into actionable business insights. - The ideal candidate should have strong technical skills combined with business understanding, excellent communication abilities, and a drive to continuously improve analytical processes and methodologies. (ref:iimjobs.com)