Associate - Lcci Bi&a Ibu Team

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.

**LCCI Commercial Analytics - Associate in BI&A IBU team**

This role will be based in the LCCI analytics team and work closely with the IBU affiliates, providing high quality market intelligence support that can drive better customer experience and business impact.

Associate will closely with brand teams to provide data insights and enable informed decision making. They work together to develop marketing tactics to better promote Lilly brands.

**Key Responsibilities**:

- **Project Execution**:

- Build and exhibit deep expertise on available data sets and supports data enabled decision making using data from external suppliers and internal data for various other sources
- Consistent delivery of high quality, timely and insightful reports to enable brand and senior leadership to track performance of Eli Lilly brands
- Develop and publish regularly, 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 etc
- Work on prescriptive and predictive analytical models, to answer unstructured questions from the business.
- Map physician journey in an omni channel environment
- Understand 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 stakeholders
- Find and execute opportunities for productivity improvements by automation or process changes

**Requirements**:

- Preferred degree in sciences or quantitative discipline i.e. Econometrics, Statistics, Engineering or Computer Sciences
- Exposure in business/market intelligence, performance reporting and/or descriptive analytics for Marketing or other commercial leadership, with demonstrated results in understanding, structuring and making sense of unfamiliar and messy datasets
- Experience in working on prescriptive analytical problems like physician journey and behavior changes, ROI modelling, targeting
- 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 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 servers
- Expertise in writing and debugging efficient SQL queries, Python or R (one of them), Excel and VBA
- Tableau experience highly desirable
- Alteryx experience highly desirable
- Experience in business analytics tasks like data cleaning, preparation and basics of good reporting
- Detailed knowledge of pharmaceutical data and business rules is preferred, but not mandatory

Lilly does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

WeAreLilly