Apollo Hospitals Group - Business Analyst - Pharma Category

Department Icon Data Science Analytics & Machine Learning
Posted: 1 year ago
2-4 years
Hyderabad
Data Science Analytics & Machine Learning
work from office
Full Time

Posted: 1 year ago

This job is no longer accepting applications

It closed on 27 Nov 2025. Here are 6 live jobs like it - apply in one step.

See all live Data Science Analytics & Machine Learning jobs
Job Description
About Company
Similar Jobs
Please verify your account first! Send OTP

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 QuerySql

If 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.

Read More

Similar Jobs

View all
Loading...

Looking for something similar?

Bag Logo
Jobaaj
Get jobs like this by email

New Data Science Analytics & Machine Learning roles in Hyderabad.

Job Alert
Google hiring for Specific Roles Apply Now!
1 min ago
New Opportunity
Amazon is hiring freshers Apply Now!
5 min ago
Featured Jobs
Microsoft opening 50+ positions Apply Now!
10 min ago

One email a day. Unsubscribe any time.