Analyst Ii, Portfolio Strategy Analytics

Working with Us Challenging Meaningful Life-changing Those aren t words that are usually associated with a job But working at Bristol Myers Squibb is anything but usual Here uniquely interesting work happens every day in every department From optimizing a production line to the latest breakthroughs in cell therapy this is work that transforms the lives of patients and the careers of those who do it You ll get the chance to grow and thrive through opportunities uncommon in scale and scope alongside high-achieving teams Take your career farther than you thought possible Bristol Myers Squibb recognizes the importance of balance and flexibility in our work environment We offer a wide variety of competitive benefits services and programs that provide our employees with the resources to pursue their goals both at work and in their personal lives Read more The Business Analyst II will play a critical role in portfolio analytics team in Hyderabad They will be responsible for developing and maintaining assessment of our portfolio vs competitors articulating portfolio health to the senior leadership and undertaking in-depth assessment of clinical trials targeted by competitors The right candidate should have extensive experience in conducting therapeutic area assessments consolidating long term forecasts for the company s portfolio hands-on expertise to build excel-based capabilities from scratch and exposure to SQL VBA Python and other coding reporting platforms Key Responsibilities Portfolio Health Analysis Conduct competitor concentration analysis by therapeutic indication using external datasets Benchmark success rates versus modeled PTRS and conduct internal portfolio assessment vs external perspective Asset Favorability Framework Develop leadership dashboard capturing portfolio ranking across key variables of interest and summarize the findings for senior leadership Clinical Trial Analysis Map our existing trials to therapeutic areas of interest articulate risk reward and summarize findings in the form of actionable insights Long-Term Financial Planning LTFP Conduct early asset modeling for LTFP including discrete models early-stage assets and conduct scenario analytics to derive range of possibilities given market dynamics Collaborate with cross-functional teams to gather and analyze relevant data market trends and historical performance Proactively and continuously assesses the relevant marketplace and its dynamics customers competitors and future development trends Provide training guidance and mentorship to junior analysts and team members as required Skills and Competencies Strong analytical skills and experience in conducting portfolio analytics for pharmaceutical MNC Deep understanding of therapeutic areas financial planning process and ability to conduct easy-stage asset evaluations Strong communication skills with the ability to present complex information to non-technical stakeholders in a clear manner Strong project management skills and the ability to work independently or as part of a team Strong attention to detail and ability to work with large datasets to ensure accuracy and reliability of forecasts Experience We welcome people with a bachelor s or master s degree in a relevant field such as Statistics Mathematics Economics Operations Research or a related discipline Proven experience typically 3 to 5 years in a portfolio analytics and long-range forecasting preferably within the biopharma or pharmaceutical industry Hands-on expertise in pharmaceutical forecasting and commercial analytics modeling platforms Advanced Excel VBA data manipulation software and visualization tools e g Tableau Python SQL Power BI etc Awareness of Pharma datasets Visible Alpha ProSight Evaluate Pharma DRG Biodmedtracker IQVIA Pharma projects Alpha sense will be a plus If you come across a role that intrigues you but doesn t perfectly line up with your resume we encourage you to apply anyway You could be one step away from work that will transform your life and career Uniquely Interesting Work Life-changing Careers With a single vision as inspiring as Transforming patients lives through science TM every BMS employee plays an integral role in work that goes far beyond ordinary Each of us is empowered to apply our individual talents and unique perspectives in a supportive culture promoting global participation in clinical trials while our shared values of passion innovation urgency accountability inclusion and integrity bring out the highest potential of each of our colleagues On-site Protocol BMS has an occupancy structure that determines where an employee is required to conduct their work This structure includes site-essential site-by-design field-based and remote-by-design jobs The occupancy type that you are assigned is determined by the nature and responsibilities of your role Site-essential roles require 100 of shifts onsite at your assigned facility Site-by-design roles may be eligible for a hybrid work model with at least 50 onsite at your assigned facility For these roles onsite presence is considered an essential job function and is critical to collaboration innovation productivity and a positive Company culture For field-based and remote-by-design roles the ability to physically travel to visit customers patients or business partners and to attend meetings on behalf of BMS as directed is an essential job function BMS is dedicated to ensuring that people with disabilities can excel through a transparent recruitment process reasonable workplace accommodations adjustments and ongoing support in their roles Applicants can request a reasonable workplace accommodation adjustment prior to accepting a job offer If you require reasonable accommodations adjustments in completing this application or in any part of the recruitment process direct your inquiries to Visit to access our complete Equal Employment Opportunity statement BMS cares about your well-being and the well-being of our staff customers patients and communities As a result the Company strongly recommends that all employees be fully vaccinated for Covid-19 and keep up to date with Covid-19 boosters BMS will consider for employment qualified applicants with arrest and conviction records pursuant to applicable laws in your area If you live in or expect to work from Los Angeles County if hired for this position please visit this page for important additional information Any data processed in connection with role applications will be treated in accordance with applicable data privacy policies and regulations