Job Description
Strong skills in Excel (Advanced Excel) and VBA (macros), and around 3 4 years of experience in the pharma domain.
Can you please look out for candidates from companies such as PharmaAce, WNS, Axtria, NTT Data, ZS Associates, IQVIA, Sun Pharma, AbbVie, GSK, Novo Nordisk, Roche, Sanofi, Cognizant Life Sciences, Accenture Life Sciences, Genpact, Indegene, Solutionec, and other pharma/life sciences organizations where Excel and VBA are commonly used.
About Us
phamax is a specialized healthcare research, consulting, and technology firm, headquartered in Zug, Switzerland. We empower healthcare organizations to attain a better user experience with business analytics and technology solutions. Our business support wing comprises domain experts, data specialists, and physicians who work as Wingman , empowering customers to focus on important tasks. We deliver our services across the world, covering all aspects of commercial, scientific and digital analytics.
Job Summary We are seeking an experienced Consultant/Senior Consultant to collaborate with cross-functional teams in delivering high-impact commercialization solutions for leading global pharmaceutical clients. This role involves developing and implementing advanced analytics strategies to enhance commercial/perational performance across the product lifecycle. The individual will manage client relationships, oversee project execution, mentor a team of analysts, and contribute to business development and strategic initiatives.
Key Responsibilities Project Delivery Lead and support analytics engagements in areas such as Advisory, Strategic consulting, Portfolio management, promotion response, and data analytics. Monitor brand forecasts, proactively identify deviations, and drive strategic forecasting discussions. Present insights and recommendations using compelling storytelling, data visualization, Excel dashboard development and PPT. Client Relationship Management Serve as the primary point of contact for clients on Advisory/Strategic/commercial analytics topics. Understand client objectives and translate them into actionable analytics solutions. Build and maintain strong relationships with key stakeholders. Team Leadership & Project Management Lead and mentor a team of analysts, fostering professional growth and high performance. Oversee project execution from initiation to delivery, ensuring quality and timeliness. Coordinate cross-functional efforts to solve complex business challenges. Business Development & Strategic Growth Identify new business opportunities and support proposal development and client pitches. Collaborate with leadership to shape the strategic direction of the analytics practice. Stay current with industry trends, market dynamics, and emerging technologies.
Qualifications Education Bachelor s degree in a quantitative field (e.g., B.Tech, B.E, Statistics, Mathematics, Economics)
B.Pharma/ Biotech with pharma analytics experience working on Advanced Excel VBA, Macros etc Advanced degree (MBA, MS) preferred Candidates with degrees in pharma domains and analytics experience are equally considered. Experience 5-7 years in commercial analytics and in pharma/life sciences consulting. Proven track record of delivering impactful analytics solutions and managing client relationships. Desired Skills Strong leadership and people management capabilities. Excellent communication and presentation skills for diverse audiences. Strategic mindset with a focus on innovation and continuous improvement. Proficiency in tools such as:
o Mandatory: Excel, VBA (macros), SQL, and Power BI.
o Good to have Python, and Tableau
Familiarity with pharmaceutical datasets (e.g., Sales, patient-level, claims, Rx, EMR/EHR, diagnostics). Hands-on experience in pharma forecasting, including inline forecasting, scenario modelling, and trend analysis.