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 190+ 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 Delivery Lead: as a lead

• Own project management for seamless project execution, prioritization, and high-quality delivery
• Develop foundational understanding of Medical Affairs strategy, critical objectives, transformation roadmap to ensure measurement workstreams align to the broader organizational strategy
• Present the final outcomes and provide recommendations as needed on objectives related to omnichannel engagement and patient analytics
• Should have good understanding of patient level data along with basics of EMR/EHR/Lab, publications, clinical trials, digital activity
• quality, speed, value, and compliance throughout the analytics value chain
• process improvements and implementation of analytical best practices

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, content creation journeys, patient outcomes.
  • 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 and leadership : Leads

• Creation and maintenance of best project management practices, standard operating procedures (SOPs), quality checklists that will enable excellent quality outputs
• Coaches other members of the team for delivery, and contribute to an inclusive community of expert practitioner
• Contribute through 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

Education 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 Related Requirements

• At least 5-8 years of evolving experience in data management, pharma market intelligence, performance reporting/visualization and/or descriptive analytics for leadership, with demonstrated results in understanding, structuring, and making sense of unfamiliar and messy datasets
• Prior experience of leading engagements, working independently with stakeholders and guiding team for delivery

• 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 one of R, 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.

Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( Lilly_Recruiting_Compliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. 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