LCCI Commercial BI&A – AC/ – IBU

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 BI&A – AC/Sr.AC – IBU

This role will be based in the LCCI Commercial BI&A team and work closely with the IBU Central BI&A/OCE and market sales data team to provide high-quality market intelligence support to drive better customer experience and business impact. IBU Central BI&A team is well established and works closely with leadership teams and 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 IBU Countries 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, etc.
• 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
• At 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.
• 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.
• Lilly Datasets – Comfortable in working with Lilly Datasets as RADAR (ERT,ERH), Veeva CRM, IQVIA .
• Hands-on experience of managing and querying data on a range of relational data servers is highly preferred and working knowledge establishing workflows or pipelines to automate the process at maximum.
• Keen understanding of different Therapeutic areas and markets of Lilly products and its competitors.

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
• Experience in understanding how relational database cubes (SSAS) are works.
• Experience in designing, developing, and deploying Reports, Dashboards, and Apps in Power BI including
• Expertise in Power BI DAX and Power Query M-Code
• Solid understanding of Data warehousing and BI concepts & building Data Models in Power BI.
• Experience in automation tools like Power Automate, Power Apps
• Alteryx/KNIME experience highly desirable
• Experience with the following technologies: Cloud platforms like AWS & Azure
• Experience in business analytics tasks like data cleaning, preparation, and basics of good reporting

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form ) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.

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.