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.
This is an opportunity you don’t want to miss!
Lilly is entering an exciting period of growth, and we are committed to delivering innovative medicines to patients around the world. LRL has increasing needs for in-house manufacture of material for clinical supplies and will therefore construct a new campus to manufacture Clinical Trial (CT) Active Pharmaceutical Ingredient (API) to meet needs for an expanding portfolio (more and new areas), to accelerate development timelines, and to enhance supply chain robustness.
The brand-new facility also known as Lilly Medicine Foundry (LMF) will utilize the latest technology to augment the current clinical supply chain for small molecules (SM), oligonucleotides, peptides, and Antibody Drug Conjugates (ADCs), monoclonal antibodies and bioconjugates, and add new capabilities including mRNA.
The new site will be built using the latest high-tech equipment, advanced highly integrated and automated manufacturing systems, and have a focus on minimizing the impact to our environment.
What You’ll Be Doing:
As Data Engineer you will be responsible for engaging with business stakeholders to design, develop, and maintain the data pipelines and data solutions that ensure the availability and quality of data sets and actionable insights for the Foundry. This includes data capture, integration, acquisition, , contextualization, and harmonization, leading to the delivery of data-as-a-product and reusable data domains and products. The focus is to integrate IT/OT systems with cloud data lakehouse architecture (AWS/Azure) to enable advanced analytics and AI/ML capabilities while ensuring data integrity and compliance with relevant regulatory standards and best practices.
The Data Engineer will work closely with the Data Architect and Data Scientists. They also work with business and IT groups beyond the data sphere, understanding the enterprise infrastructure and the many source systems.
How You’ll Succeed:
Bring a foundational set of knowledge in: communication, leadership, teamwork, problem solving skills, solution definition, business acumen, architectural processes (e.g. blueprinting, reference architecture, governance, etc.), technical standards, project delivery, and industry knowledge.
Provide Business Analysis and Technical Leadership including:
Engaging with business and proactively seeking opportunities to deliver business value.
Understanding business requirements and effectively translating business needs and process into technical terms, and vice versa
Eliciting and defining requirements.
Participating in design reviews to ensure traceability of requirements.
Seeking opportunities to reuse existing processes and services to streamline support and implementation of key systems.
Staying abreast of tools and technologies to influence Tech at Lilly strategy so that it provides best usage opportunities for business
Analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
Design, develop and maintain data solutions for data capture, storage, integration and analytics in partnership with Tech at Lilly teams.
Review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies
Ensure that Data solutions adhere to regulatory requirements including FDA guidelines and Good Manufacturing Practices (GMP).
Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence
Your Basic Qualifications:
Bachelor’s degree in Computer Science, Data Science, Engineering or related field
At least 3 years of experience in several of the following disciplines: statistical methods, data modeling, ETL/ELT, ontology development, semantic graph construction and linked data, relational schema design.
At least 1 year of experience in a pharmaceutical GxP environment.
Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support or sponsor work authorization and/or visas for this role
Additional Skills / Preferences:
1-3 years of experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional).
Demonstrated SQL and data modeling proficiency.
Experience with data modeling tools such as, ER*Studio and Erwin or TOAD.
Experience with cloud platforms (e.g., AWS, Azure).
Experience with AI/ML/LLM Concepts and tools and building agentic AI solution sets
Experience with data integration such as data streaming, Industrial IOT, using MQTT, AQMP, Kafka and related protocols.
Understanding of modern data architecture, data lakehouse, data warehousing and/or big data concepts.
Experience with security models and development on large data sets.
Experience with multiple database solutions (e.g. Postgres, Redshift, Aurora, Athena, Graph DB like Neptune, No SQL like DynamoDB, MongoDB) and formal database designs (3NF, Dimensional Models).
Experience with Agile Development, CI/CD, Github, Automation platforms.
Demonstrated ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
Ability to review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies.
Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence.
Prior work experience working in pharma or other GMP setting.
Solid knowledge of Computer System Validation process.
Demonstrated ability to analyze, anticipate, and resolve complex issues through sound problem-solving skills.
Demonstrated learning agility and curiosity.
Desire and ability to communicate using a variety of methods in diverse forums.
Additional Information:
Must be willing to relocate to the Indianapolis/Lebanon, IN area
Work schedule is hybrid: At least three days onsite.
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 is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status.
Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Women’s Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups.
Actual compensation will depend on a candidate’s education, experience, skills, and geographic location. The anticipated wage for this position is
$64,500 - $184,800Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lilly’s compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.
#WeAreLilly