Applications are being made for the Data Engineer Intern at Lilly, Bangalore. This is a full-time opportunity. Check the details below!
About Lilly
At Lilly, we unite caring with discovery to make life better for people worldwide. We are a global healthcare leader headquartered in Indianapolis, Indiana. Their employees worldwide 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 worldwide.
Job Description
The Intern-DE will report to the BI&A Data Engineering team and work with it to ensure the right data is ingested, structured, and seamlessly flows to analytical and operational tasks downstream.
Responsibilities
- 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 multidimensional modelling, such as Star Schema and Snowflake Schema, normalization, de-normalization, and joining of datasets.
- Hands-on Experience creating Fact and dimensional tables and ingesting datasets into Cloud-based tools. Job Scheduling and automation experience are a must.
- Identify, design, and implement internal process improvements, such as automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability.
- Set up and maintain data ingestion, streaming, scheduling, and job monitoring automation. Connectivity between Lambda, Glue, S3, Redshift, and Power BI needs to be maintained for uninterrupted automation.
- Build the infrastructure required for optimal data extraction, transformation, and loading 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.
Qualifications
Bachelor’s Degree
Preferred Skill Sets
- Strong learning agility
- Strong problem solving
- Excellent teamwork
- Flexibility and adaptability
- Experience in SQL, Python
- Pharma / Healthcare experience or interest
How to Apply?
Interested candidates can directly apply through this link.
Location
Bangalore, Karnataka.
