Senior /Associate Consultant

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.

Data Management & Business Intelligence Analyst – ASG Hub
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 35,000 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 BI&A – Data Management & Business Intelligence Analyst – ASG Hub
This role will be based in the LCCI analytics team and work closely with the ASG analytics team in providing
high quality data management and business intelligence
support that can drive better customer experience and business impact. The purpose of the LCCI BI&A team is to collaborate with the affiliates in providing high quality analytical support. The LCCI BI&A team comprises of creative problem solvers who support achievement of the brand's goals, while always striving for process improvement and innovation.

Key Responsibilities

• Project Execution: as individual contributor, responsible for data management and performance reporting

• 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

• Execute and monitor operations tasks to ensure timely availability of data to the business

• Perform thorough data validations to ensure data quality
• Respond to queries from internal stakeholders
• Consistently meet operations SLAs

• Perform incident resolution and root cause analysis to support data and reporting operations

• 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.

• Brand descriptive analytics and visualization to provide data-based insights on planning, measurement, and segmentation

• 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
• 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

Requirements

• Preferred degree in sciences or quantitative discipline i.e. Finance, Econometrics, Statistics, Engineering or Computer Sciences. Experience in pharma/healthcare industry is preferable
• Experience/Familiarity of Medical Affairs Projects is a Plus
• At least 5-7 years of evolving experience in data management, 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

• Lilly Datasets – Comfortable in working with Liily Datasets as RADAR (ERT,ERH and FNSH), 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

• Tools:

• Expertise in writing and debugging efficient SQL queries

• Coding: Python, Knime

• And, visualization tools like Power BI experience (Fabric experience is a plus)

• Analytical Skills

• Experience in business analytics

• Data cleaning and preparation skill (database querying, descriptive statistics)
• Problem solving skills and lateral thinking ability

• An eye for detail

• Experience in working with business partners located in another country, especially non-English speaking country like Germany

• Interpersonal and communication skills, with ability to work, remotely, across time zones
• Ability to operate effectively in an international matrix environment

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.