Enterprise Data - Senior Data Engineer

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.

Senior Data Engineer P2 - Enterprise Data Management

Advanced Analytics and Data Sciences

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

The Enterprise Data program is developing a fully integrated and intuitive data and analytics platform.  This platform will enable Lilly team members to quickly view, access, and analyze data sets in statistical environments, advanced analytics environments, and BI/visualization tools. Contributors can easily ingest, prepare, and analyze new data sets (cleanse, enhance, publish) for others to utilize.

Key responsibilities include:

• Build high-performance and scalable data pipelines adhering to data lake house, data warehouse & data marts standards for optimal storage, retrieval, and processing of data.
• Ability to work with business owners to define key business requirements and convert to technical specifications.
• Experience with security models and development on large data sets
• Responsible for system testing, ensuring effective resolution of defects, timely discussion around business issues and appropriate management of resources relevant to data and integration.
• Participate in regular SAFe Agile framework team ceremonies.

Basic Qualifications:

• Bachelor’s degree in computer science, information technology, management information systems or equivalent work experience 
• 8 to 10 years of development experience in the core tools and technologies like SQL, Python, AWS ( Lambda, Glue, S3, Redshift, RDS, DMS, Athena, IAM Roles & Policies) , PySpark used by the solution services team.
• 3+ years of experience in Agile Development and code deployment using Github & CI-CD pipelines.
• Exposure in the design, data modelling, creation and management of large datasets/data models
• Performance tuning.
• OLTP and OLAP data modeling.
• Devops impelementation.
• 5 Years of ETL and ELT solution implementation.

Additional Information:

• Strong Commitment to the Principles of Good Software Design
• Understanding of Cloud / Hybrid data architecture concepts
• Strong Written and Oral Communication Skills
• Ability to analyze, design, and implement components by applying best practices and coding standards
• Strong Commitment and Willingness to Learn

Lilly is a global healthcare leader that unites caring with discovery to make life better for people around the world. For more than a century, we have stayed true to a core set of values—excellence, integrity, and respect for people—that guide us in all we do: discovering medicines that meet real needs, improving the understanding and management of disease, and giving back to communities. We also are committed to investing in our employees and supporting a culture of well-being —through competitive pay, comprehensive employee benefit programs, and training and development resources. 

We’re doing extraordinary things. Join us and you could be, too!

Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( Lilly_Recruiting_Compliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. 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