This role will be based in the LCCI Commercial BI&A team and work closely with the NAPAC (Australia, New Zealand, Hong Kong, South Korea and Taiwan) BI&A / OCE team to provide high-quality market intelligence support to drive better customer experience and business impact. NAPAC BI&A team is we'll established and works closely with brand teams to provide data insights and enable informed decision-making.
Project Execution :
- Build and exhibit deep expertise on available data sets and supports data-enabled decision-making using data from external suppliers in NAPAC and internal data from various other sources.
Consistent delivery of high-quality, timely, and insightful reports to enable brand and senior leadership to track the performance of Eli Lilly brands.
Develop and publish regular market intelligence reports on KPIs related to Sales, sales growth, wholesaler inventory, market share, market growth, sales force activity, P2P and non-personal channel promotional impressions and engagement metrics, etcWork on prescriptive and predictive analytical models to answer unstructured questions from the business.
Map physicians journey in an omnichannel environmentUnderstand the preferred communication channel for a physician.Calculate ROI of various marketing tactics.Developing into a trusted advisor by actively participating in various phases of the project, including kick-off, methodology development, execution, insight generation and data visualization, and results presentation to various stakeholdersFind and execute opportunities for productivity improvements by automation or process changes.Requirements
Preferred degree in sciences or quantitative discipline, ie, Econometrics, Statistics, Engineering, or Computer SciencesAt least 3-5 years of evolving experience in business / market intelligence, performance reporting, and descriptive analytics for Marketing or other commercial leadership, with demonstrated results in understanding, structuring, and making sense of unfamiliar and messy datasets in the pharma Industry.Experience in working on prescriptive analytical problems like physician journey and behaviour changes, ROI modelling, forecasting.Exposure to advanced analytics algorithms to create predictive data models.Experience in working with business partners located in another country.Interpersonal and communication skills, with the ability to work remotely across time zones.Ability to operate effectively in an international matrix environment.Preferred Technical Skills
Hands-on experience of managing and querying data on a range of relational data serversExpertise in writing and debugging efficient SQL queries, Python or R (one of them), Excel and VBAExperience in designing, developing, and deploying Reports, Dashboards, and Apps in Power BI includingExpertise in Power BI DAX and Power Query M-CodeSolid understanding of Data warehousing and BI concepts & building Data Models in Power BI.Alteryx / KNIME experience highly desirableExperience with the following technologies : Cloud platforms like AWS & AzureExperience in business analytics tasks like data cleaning, preparation, and basics of good reportingExperience in pharmaceutical forecasting is good to haveRole : Analytics Consultant
Industry Type : Pharmaceutical & Life Sciences
Department : Data Science & Analytics
Employment Type : Full Time, Permanent
Role Category : Business Intelligence & Analytics
Education
UG : Any Graduate
PG : Any Postgraduate
Skills Required
Share Market, Business Analytics, Automation