LCCI BI&A – Medical Affairs Data Reporting & Visualization Analyst

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.

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 39,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. The LCCI (Lilly Capability Center India), BI&A (Business Insights & Analytics) team was started in 2017 with the objective of supporting business decisions for functions in the US and ex-US affiliates. This team is part of the LCCI - Commercial Services organization and works very closely with business analytics team based in Indianapolis (HQ). The team currently comprises of more than 200+ staff members, with varied backgrounds and skills across data management, analytics and data sciences, business, and operations etc.

To better meet the evolving analytics needs, the LCCI BI&A team is ramping up Medical Affairs team with a candidate who can lead creation of high-quality data reporting and visualization support that can drive better customer experience and business impact. This role will champion our self-service reporting strategy and play a key role in helping us automate and create scalable frameworks for our reporting and analytics. We are looking for a techno-functional leader to provide thought leadership to a team and operational leads who can help expand the capabilities and drive global initiatives. This candidate will work with a range of stakeholders and lead team to help answer critical business questions, while always striving for process improvement and innovation.

Key Responsibilities:

Project Execution: as individual contributor, responsible for data reporting and visualization

• Build and exhibit deep expertise on available data sets and supports data enabled decision making using data from external suppliers (patient level claims databases, EMR/EHR/Lab, publications, clinical trials etc) and internal Lilly data (EBD, Veeva, Customer 360 etc)
  • Execute and monitor operations tasks to ensure timely availability of data in a reporting/ dashboard structure 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 stakeholders and senior leadership to take key decisions
  • Develop and publish regularly, Omnichannel execution dashboard, patient outcomes, leadership scorecards.
  • Descriptive analytics and visualization to provide data-based insights on planning, execution and outcomes
  • Omnichannel performance analytics to provide insights in progress and health of the initiative. Also, provide data support for analytics including segmentation and campaign measurement

Project management : Support leader as needed on below tasks

• Creation and maintenance of standard operating procedures (SOPs), quality checklists that will enable excellent quality outputs
• Contribute through process improvement and shared learning forums to identify challenges, devise solution, deliver value and establish best practices
• Ensure compliance with all privacy and contractual obligations for work delivered by team members related to the use of data

Experience Related Requirements

• Undergrad in relevant fields (Engineering or Computer Sciences, Math/Stats, quant economics/econometrics, healthcare etc)
• 1-2 years of analytics experience with demonstrated ability to think strategically in an ambiguous environment in analytics, especially in pharma/other lifesciences

• Technical Skills:
  • Expertise in writing and debugging efficient SQL queries.
  • Strong experience in data visualization tools - Power BI or Tableau (Power BI preferred) – Should be able to independently design and develop dashboards as per business requirement.
  • Good to have pharma database knowledge such as Activity Data, patient data (IQVIA) and non-personal campaigns
  • Advanced MS-office skills (MS-Excel and MS-PowerPoint)
  • Coding: SQL mandatory and intermediate Python
• Analytical Skills
  • Experience in business analytics
  • Data cleaning and preparation skill (database querying, descriptive statistics)
  • Problem solving skills and lateral thinking ability and an eye for detail
• Soft Skills
  • Strong work ethic and personal motivation
  • 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.

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 (https://careers.lilly.com/us/en/workplace-accommodation) 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.

#WeAreLilly