Data Engineer

Lilly-Lilly

Data Engineer building AWS/Azure data pipelines for Lilly’s new pharmaceutical manufacturing campus. Integrating compliant IT/OT data systems to enable analytics and AI/ML capabilities.

Posted 8/12/2026full-timeLebanon • 🇺🇸 United StatesMid-LevelSenior💰 $126,000 - $224,400 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and building data pipelines, integrating IT and OT systems with AWS and Azure cloud platforms, and applying data governance principles in a pharmaceutical environment. Proficient in data modeling, ETL/ELT processes, and utilizing advanced data technologies for analytics and operational needs.

Highest-signal resume keywords

AWS Cloud Platform ExperienceAzure Cloud Platform ExperienceData Pipeline DevelopmentSQL ProficiencyGxP Compliance Knowledge

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingETL/ELTStatistical MethodsData ArchitectureData WarehousingAI/ML ConceptsStreaming IngestionDatabase DesignPostgreSQLAgile Development

Soft Skills

Problem-Solving SkillsLearning AgilityCommunication Skills

Tools & Technologies

AWSAzureKafkaGitHubER/StudioErwinTOADDynamoDBMongoDBCI/CD

Industry Keywords

PharmaceuticalGxPData GovernanceMaster Data ManagementBusiness IntelligenceIndustrial IoTBig Data ConceptsComputer System Validation

Tech Stack

Tools & technologies

Amazon RedshiftAWSAzureCloudDynamoDBERPETLIoTKafkaMongoDBPostgresSQL

About the role

Key responsibilities & impact

Design and build data pipelines for the Lilly Medicine Foundry site
Integrate IT and OT source systems with AWS and Azure cloud data Lakehouse architecture
Capture, ingest, integrate, contextualize, harmonize, and deliver data as reusable data domains and data products
Work across enterprise and edge systems spanning ERP, ELN, MES, LIMS, Historians, PLM, and QMS platforms
Engage with Operations, Quality, Lab, and Engineering stakeholders to understand data needs
Elicit requirements, identify gaps, and translate operational needs into technical designs
Explain architectural decisions to non-technical audiences
Design and develop data pipelines for ingestion, transformation, and integration
Apply medallion architecture, streaming ingestion, and API-based extraction patterns
Write maintainable code and optimize data-flow performance
Participate in design reviews, maintain traceability, and contribute to governance frameworks for GxP compliance
Track emerging AWS and Azure data technologies and contribute to team capability and Tech@Lilly strategy
Analyze complex data domains and develop solutions for analytics
Design, develop, and maintain data solutions for capture, storage, integration, and analytics
Review and recommend data design patterns, performance optimizations, database versions, and deployment strategies

Requirements

What you’ll need

Bachelor’s degree in Computer Science, Data Science, Engineering, or related field
At least 3 years of experience in several disciplines including statistical methods, data modeling, ETL/ELT, ontology development, semantic graph construction and linked data, or relational schema design
At least 1 year of experience in a pharmaceutical GxP or scientific environment
Experience with AWS and Azure cloud platforms
Experience with AI/ML/LLM concepts and tools and building agentic AI solution sets
1–3 years of experience designing large-scale data models for functional, operational, and analytical environments
Demonstrated SQL and data modeling proficiency
Experience with ER/Studio, Erwin, or TOAD
Experience with data streaming, Industrial IoT, MQTT, AMQP, Kafka, and related protocols
Understanding of data architecture, data lakehouses, data warehousing, and/or big data concepts
Experience with security models and development on large datasets
Experience with PostgreSQL, Redshift, Aurora, Athena, Neptune, DynamoDB, MongoDB, and formal database designs
Experience with Agile development, CI/CD, GitHub, and automation platforms
Knowledge of Data Governance, Master Data Management, and Business Intelligence
Prior experience in pharma or another GMP setting
Solid knowledge of Computer System Validation processes
Problem-solving skills for analyzing, anticipating, and resolving complex issues
Learning agility and curiosity
Ability to communicate using varied methods in diverse forums
Ability to work onsite five days per week in Lebanon, Indiana beginning late 2027–2028; until then, work location is Indianapolis, Indiana

Benefits

Comp & perks

Company bonus depending, in part, on company and individual performance
Company-sponsored 401(k)
Pension
Vacation benefits
Medical benefits
Dental benefits
Vision benefits
Prescription drug benefits
Flexible benefits, including healthcare and/or dependent day care flexible spending accounts
Life insurance and death benefits
Time off and leave of absence benefits
Well-being benefits, including employee assistance program, fitness benefits, and employee clubs and activities
Employee resource groups and support networks
Disability accommodation support during the application process