LCCI BI&A IBU Analytics Japan – Sr. Associate Consultant
Eli Lilly
- Bangalore, Karnataka
- Permanent
- Full-time
- Project Execution: as individual contributor, responsible for
- Building and exhibiting deep expertise on available data sets and supports data enabled decision making using data from external suppliers (JDI, JPM, DDD, etc.) in Japan and internal data for various other sources in Eli Lilly Japan
- Ensuring high stakeholder satisfaction through consistent delivery of high quality, timely and insightful outputs throughout analytics value chain on various objectives related to –
- Brand descriptive analytics and visualization to provide data-based insights on planning, measurement and segmentation e.g. Lilly brand performance, market monitoring, new brand launches, customer analysis
- OCE (omni-channel engagement) analytics, segmentation, targeting and campaign measurement etc. e.g. analysis on source of business, test and control, engagement segmentation, channel spend optimization, trade off analysis, etc.
- market intelligence reporting 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 etc.
- data support through data mining and warehousing
- 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 stakeholders
- Participating in meetings with stakeholders and communicating the final outputs and recommendations
- Project Delivery: as team member, supporting the team lead in driving
- quality, speed, value and compliance throughout the analytics value chain
- project management for seamless project execution, prioritization and high quality delivery
- creation and maintenance of standard operating procedures (SOPs), quality checklists that will enable excellent quality outputs
- shared learning forums to identify challenges and establish best practices
- expansion of analytical capability of the team by taking on more complex projects and delivering value
- process improvements and implementation of analytical best practices
- Degree in sciences or quantitative discipline i.e. Finance, Econometrics, Statistics, Engineering or Computer Sciences. Experience in pharma/healthcare industry is preferable.
- 4-6 years of analytics experience with demonstrated ability to think strategically in an ambiguous environment in analytics
- Experience in pharma industry is preferable
- Technical Skills
- Strong experience in SQL
- Strong experience in data visualization tools e.g. Tableau/PowerBI
- Experience in R, Python, Knime (at least 1)
- Excel, VBA (added advantage)
- Strong knowledge of various pharma databases (high preference for Japan dataset and landscape knowledge including JDI, JPM, DDD, Ultmarc, M3/NMO/MedPeer/Carenet etc.)
- Advanced MS-office skills (MS-Excel and MS-PowerPoint)
- Analytical Skills
- Strong experience in business analytics including insight generation for commercial leadership.
- Experience in data manipulation, cleaning and preparation (database querying, descriptive statistics)
- Problem solving skills and lateral thinking ability
- An eye for detail
- Soft Skills
- Strong work ethic and personal motivation
- Good presentation skills
- Experience in working with business partners located in another country, especially non-English speaking country like Japan
- Interpersonal and communication skills with ability to work across time zones
- Ability to operate effectively in an international matrix environment
- Strong stakeholder management skills
- Strong team player who is dynamic and result-oriented