Intern - BI&A

 
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 45,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 

Ware seeking a motivated and enthusiastic intern to join our BI&A Data Engineering team for a 3-month internship. This position offers hands-on experience in data engineering and an opportunity to contribute to meaningful projects while gaining valuable skills and knowledge. 

Key accountabilities will include the following: 

• Create and maintain optimal data pipeline architecture ETL/ ELT into Structured data 

• Assemble large, complex data sets that meet functional / non-functional business requirements and create and maintain multi-dimensional modelling like Star Schema and Snowflake Schema, normalization, de-normalization, joining of datasets. 

• Hands-on Experience creating Fact tables, Dimensional tables and ingest datasets into Cloud based tools. Job Scheduling, automation experience is must. 

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. 

• Setup and maintain data ingestion, streaming, scheduling, and job monitoring automation. Connectivity between Lambda, Glue, S3, Redshift, Power BI needs to be maintained for uninterrupted automation. 

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and “big data” technologies like AWS and Google 

• Build analytics tools that utilize the data pipeline to provide actionable insight into customer acquisition, operational efficiency, and other key business performance metrics 

• Work with cross-functional teams including external consultants and IT teams to assist with data-related technical issues and support their data infrastructure needs 

• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader 

Basic Qualifications 

• Bachelor’s Degree 

Additional Skills/Preferences 

• Strong learning agility 

• Strong problem solving 

• Excellent teamwork 

• Flexibility and adaptability 

• Experience in SQL, Python 

• Pharma / Healthcare experience or interest