Apollo Hospitals Group - Business Analyst - Pharma Category
This job is no longer accepting applications
It closed on 27 Nov 2025. Here are 6 live jobs like it - apply in one step.
Apply nowApply- Data Engineer - Information TechnologyApply nowApplycareers-myhr-apolloChennai, Tamil Nadu · 2-5 yrs · Posted 7 days ago
- Data Scientist - Information TechnologyApply nowApplycareers-myhr-apolloChennai, Tamil Nadu · 2-5 yrs · Posted 4 days ago
Apply nowApply
CRM - Campaigns (Clinical & Patient Engagement)Apply nowApplyApollo HospitalsHyderabad · 5-8 yrs · Posted 26 days ago
Apply nowApply
Job Description
Business Analyst - Pharma Category
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 performance
2. 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 categories
3. 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 identification
4. 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 propensity
5. 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 formats
Technical 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 tools
Data 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 workflows
Key Performance Indicators (KPIs):
- 1. Dashboard Delivery: Timely delivery of accurate dashboards and reports as per business requirements
- 2. Data Accuracy: Maintain >98% data accuracy across all analytical outputs and dashboards
- 3. Automation Efficiency: Automate 80% of recurring reports to reduce manual effort
- 4. Insight Quality: Provide actionable insights that lead to measurable business improvements
- 5. Process Improvement: Identify and implement process improvements to enhance analytical efficiency
Required 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 preferred
Experience 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 solutions
Soft 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 space
What 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 leadership
Ideal 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.
Skills
Data AnalyticsData ModelingData ScienceSQLData VisualizationAnalyticsPower BIPythonData ManagementMachine LearningStatisticsData AnalyticsData MiningData VisualizationBusiness AnalyticsPythonCustomer AnalyticsBusiness AnalystDashboard CreationDashboard DevelopmentData AnalysisData IntegrityData ModelingData ScienceEtlData ExtractionMachine LearningPredictive ModelingRegression AnalysisProcess ImprovementRoot Cause AnalysisVisualizationAnalystAnalyticsBig QuerySqlIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
With over 6000 stores, Apollo Pharmacy is the largest pharmacy retail chain in India. We have been serving our customers dedicatedly for over 35 years while touching the lives of over 20 Crore customers annually with genuine quality healthcare products.
Build your career with a strong purpose to serve communities by joining our vibrant workforce of over 40,000 committed personnel spread across the country.
Similar Jobs
View allLooking for something similar?
New Data Science Analytics & Machine Learning roles in Hyderabad.
One email a day. Unsubscribe any time.

