Total Experience : 3-8 years
Location – PAN India
Must have worked on Pharmaceutical Data base
Overview
Analytics Function Overview:
The Analytics function focuses on delivering scalable, insight-driven reporting and advanced analytics solutions to leading global pharmaceutical companies. The team supports commercial, medical, market access, and executive stakeholders by transforming complex healthcare data into actionable, persona-based insights using modern BI platforms and AI-enabled analytics.
Experience – 3+ years of experience
Roles and Responsibilities – Summary
- Analyze large, multi-source pharma datasets independently and extract meaningful business insights
- Design, develop, and maintain enterprise reporting solutions primarily using Qlik Sense, with supporting exposure to Power BI where required
- Translate business requirements into KPIs, metrics, and semantic definitions aligned with global standards
- Work with CRM, Field Activity, and Sales performance datasets to enable persona-based reporting across Field Force, Marketing, KAM, and Executive stakeholders
- Develop interactive dashboards with optimized performance and intuitive navigation
- Support conversational and augmented analytics using Qlik Insights Advisor, Power BI Copilot, and GenAI-enabled NLP interfaces to enable natural language querying, automated insight discovery, and AI-assisted decision making
- Assist in setting up KPI explanations, auto-insights, and narrative summaries for business users
- Collaborate with stakeholders across Commercial, Medical, Access, and Analytics teams to refine reporting needs
- Work closely with Data Engineering and Data Modeling teams supporting semantic data layers to ensure accurate data consumption
- Perform data validation, reconciliation, and root-cause analysis for reporting discrepancies
- Support UAT cycles, business validation, and production releases
- Prepare client-ready presentations and storytelling decks highlighting insights and trends
- Take ownership of assigned reporting modules and deliverables
- Mentor junior analysts and ensure adherence to reporting and visualization standards
Core Competencies
Technical & Analytical Skills
- Strong hands-on experience developing enterprise-scale Qlik Sense applications across the full development lifecycle, including
- Designing scalable associative data models using optimized QVD strategies, incremental loading, and modular scripting frameworks across multi-source datasets
- Advanced analytical development using complex Set Analysis, nested aggregations, dynamic variables, alternate states, and period-over-period KPI calculations
- Working within Qlik Sense Enterprise or Qlik Cloud environments including Section Access implementation, row-level security (RLS), governance controls, publishing workflows, spaces management, and application lifecycle management.
- Experience developing reusable dashboard frameworks using master items, variables, and standardized KPI definitions
- Working exposure to Power BI is required, including dashboard development
- Working knowledge of SQL for data validation and analysis
- Exposure to conversational and GenAI-enabled analytics capabilities including:
- – QLIK Sense Insights Advisor
- – Power BI Copilot and AI-assisted querying
- – Natural language querying and KPI explanations with automated narrative generation
- Understanding of dashboard performance optimization (filtering strategies, aggregations, and data extraction approaches)
- Proficiency in MS Excel and PowerPoint for analysis and executive communication
Domain & Business Knowledge
- Life sciences / pharmaceutical analytics experience (3+ years)
- Good understanding of pharma datasets such as:
- – IQVIA (Sales, Claims, Rx, SISO, DDD)
- – CRM / Veeva activity data
- – HUB, Specialty Pharmacy, Claims, Payer data
- Exposure to Commercial Analytics, Field Effectiveness, Brand Performance, or Market Access reporting
- Familiarity with pharmaceutical KPIs across the patient journey, prescriber behavior, sales performance, and HCP engagement analytics
Behavioral & Professional Skills
- Strong verbal and written client communication skills
- Ability to work with offshore/onshore teams in a global delivery model
- Attention to detail with a strong quality and accuracy mindset
- Ability to manage multiple priorities and timelines
- Collaborative mindset with strong stakeholder management skills
- Logical thinking, problem-solving, and analytical reasoning
- Adaptability and willingness to learn emerging BI and AI capabilities
Must-Have Skills
- Advanced Qlik Sense developer with strong hands-on experience building enterprise-scale reporting and dashboard solutions across the full application lifecycle
- Working exposure to Power BI is required, including dashboard development and KPI reporting.
- SQL
- MS Excel and MS PowerPoint
- Analytical thinking and problem solving
- Stakeholder communication and requirement understanding
- Reporting and dashboard development experience
- Written and verbal communication skills
Good-to-Have Skills
- Conversational and GenAI-enabled analytics (Qlik Sense Insights Advisor, Power BI Copilot, NLP-based querying, automated narrative generation)
- Exposure to AI-assisted insights and automated narratives
- Knowledge of Alteryx or similar data preparation tools
- Therapy area knowledge (any one TA is a plus)
- Prior experience supporting global or regional pharma reporting programs.
Highest Education
• Bachelor’s or Master’s degree in Engineering, Technology, Statistics, Mathematics, Economics, or related analytical disciplines
• Strong academic background with quantitative and analytical coursework preferred.
Working Language
• English
…