Intern - Clinical Operations Analytics

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.

**Title - Clinical Trial Foundations Intern (CTF Intern)**

**Location - LCCI, Bangalore**

**Company Overview**

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.

**Responsibilities
**The CTF Intern will report to the CTF Team Leader and will work with a team to provide analytical capabilities for the company. These capabilities may include reporting, dashboard development, process automation, app development & maintenance, data warehousing, performance enhancement & stakeholder engagement.

Key accountabilities will include the following:
**Data Management & Product Development**:

- Automate excel-based operations to SQL/Python for improving processing turn-around time, and set-up quality assurance procedures.
- Collate requirements by interacting with stakeholders, automate the processes and develop end-product(app/dashboards).
- Process data on SQL or AWS, sourced from varied data sources following the standard operating procedure documents.
- Understand the current data architecture within CTF and deliver ad-hoc data pulls and low/medium complexity analysis.
- Validate data quality and accuracy of the results of existing processes.
- Constant vigilance towards data security, sanitisation, and integration.

**Business Processes**:

- Ensure product release and user acceptance & review.
- Engage with stakeholders and setup feedback sessions during & after development processes.
- Process maps creation and update working in collaboration with existing team members.
- Support in documentation and streamlining of processes.
- Understand the Clinical trial foundation as a domain and operations of the same.
- Create test cases & conduct UATs.

**Basic Qualifications**
- Bachelor’s Degree or BS in Analytics

**Essential Skills**
- Experience in writing code (e.g. SQL, R, Python or PowerApps) and Data Visualization tools like PowerBI, Qliksense, Tableau etc.
- Data warehouse experience is preferred.
- Experience in Data Analytics or App development.
- Should understand Product Development Lifecycle.
- Open to learning and practicing Agile framework.
- Strong learning agility.
- Strong analytical mindset.
- Excellent communication skills (written & verbal).
- Work Prioritization skills & strong work ethics.
- High level of motivation and a strong desire to find creative solutions to challenging situations.
- Good focus on detail, accuracy, and ability to solve problems through analytical reasoning.

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