Data Engineer - Lilly Medicine Foundry

Lilly • Indianapolis, IN

3d • $126,000 - $224,400 • Onsite

About The Position

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.

Requirements

• 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 or Scientific environment.
• Experience with cloud platforms (e.g., AWS, Azure).
• Experience with AI/ML/LLM Concepts and tools and building agentic AI solution sets.
• Communication skills
• Leadership skills
• Teamwork skills
• Problem solving skills
• Solution definition skills
• Business acumen
• Knowledge of architectural processes (e.g. blueprinting, reference architecture, governance, etc.)
• Knowledge of technical standards
• Knowledge of project delivery
• Industry knowledge

Nice To Haves

• 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, ERStudio and Erwin or TOAD.
• 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.
• 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.
• Staying abreast of tools and technologies to influence Tech@Lilly strategy so that it provides best usage opportunities for business.

Responsibilities

• Design and build data pipelines for the site.
• Integrate IT and OT source systems with cloud data Lakehouse architecture spanning AWS and Azure, enabling the advanced analytics and AI/ML capabilities that will define how Foundry operates.
• Manage the full data value chain: capture, ingestion, integration, contextualization, harmonization, and delivery as reusable data domains and data-as-a-product.
• Work across enterprise and edge systems, navigate a diverse technology landscape, and ensure that everything built meets the data integrity and compliance standards required in a GxP-regulated manufacturing environment.
• Design and develop robust data pipelines for ingestion, transformation, and integration across cloud platforms (AWS and Azure), applying modern patterns such as medallion architecture, streaming ingestion, and API-based extraction.
• Write clean, maintainable code, optimize for performance, and think carefully about how data flows from source systems into trustworthy, analytics-ready products.
• Engage proactively with stakeholders across multiple modalities and business teams including Operations, Quality, Lab, and Engineering to understand their data needs.
• Elicit requirements, identify gaps, and translate operational realities into sound technical designs — and explaining architectural decisions back to a non-technical audience.
• Understand upstream and downstream dependencies, seek opportunities to reuse existing services and integrations, and build with the broader data architecture in mind.
• Understand the data integrity requirements of a GxP manufacturing environment and apply Quality guidelines and Good Manufacturing Practices from the start.
• Participate in design reviews, maintain traceability, and contribute to governance frameworks that keep the Foundry consistently compliant.
• Track emerging tools and technologies across the AWS and Azure data ecosystems, bring informed perspectives on what's worth adopting, and actively contribute to the team's collective capability.
• 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@Lilly teams.
• Review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies.

Benefits

• company bonus (depending, in part, on company and individual performance)
• 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
• well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities)

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level