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