Project Role: Analytics Consultants
Work Experience: 2.5 to 5 Years
Work location: Pune
Work Mode: Hybrid
Must Have Skills: Pharma Analytics, Python, SQL, Patient level Data
Job Overview:
Analytics Consultants work with onshore team and India managers to create custom solutions by leveraging disparate data sources to support sales and marketing decisions. Consultants will be responsible for substantial portion of analyses from problem formulation to solution creation and engaging with clients to help them understand the implications and make plans to act on them.
Key Responsibilities:
- Develop and apply advanced statistical models that help clients understand dynamic business issues
- Develop promotion response models that relate promotion and product sales
- Build simulation models using Excel/VBA, SAS, Alteryx Visual Basic and Excel and other tools to assess the effects of sales and marketing programs based on different permutation / combinations
- Synthesize and communicate results to clients and 159 teams through oral and written presentations
- Develop client relationships and serve as key point of contact on aspects of projects
- Create project deliverables and implement solutions
- Assist with creation of PowerPoint slides and online visualization (e.g. Tableau, Qlik, Sisense etc.) to communicate findings
- Advance analytics knowledge base and assist with new capabilities development
- Mentor junior associates and assist with multiple work streams to deliver high quality deliverables on time
Technical/Required Skills:
- Domain Knowledge: Experience in US Healthcare/Pharma/life sciences commercial analytics; Claims or Sales data exposure (Any of IQVIA LAAD, SHA, XPO, OneKey, SP/SD/Hub).
- Analytics Capabilities: Any of the area expertise (Segmentation & targeting, Incentive Compensation, Patient journey/Line of Therapy/Persistency, Reporting, Forecasting)
- Technical Skills: Extensively work on Advanced Excel, SQL, Python, PowerPoint (client-ready decks).
- Data & Automation: Ability to manage and analyze large datasets end-to-end.
- Consulting & Client Skills: Problem solving, structured thinking, solid communication, onshoreoffshore collaboration.
- Leadership: Mentor juniors, own workstreams and deliver on time.
- Tech Ecosystem: Comfortable with standard analytics stack
Good to have Skills/Experience:
- Multi-therapy experience (Oncology, Vaccines, Specialty TAs).
- Marketing Mix Modeling, Test-Control Analyses, Predictive / Prescriptive Analytics.
- VBA automation, R, Power BI, Tableau, Alteryx.
- Fully automated pipelines, workflow optimization
- Acting as client POC, stakeholder management.
- Manage small teams.
- AWS / Git / cloud exposure
Educational Qualification:
- BTech/BCA/BSc/MTech/MCA/MSc/BSc/B. Pharma
📌 Pharma Analytics (Pune)
🏢 Iqvia
📍 Pune