Systems & Analytics Intern

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.

Responsibilities

The S&A Intern will report to the 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 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 and data lakes and deliver ad-hoc data pulls for 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, DAX, 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 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