Data Engineer

Eli Lilly

Indianapolis (IN)

Vor Ort

USD 129.000 - 231.000

Vollzeit

14 Tage+

Erhalte eine Antwort von diesem Arbeitgeber

Dein Lebenslauf und dein Anschreiben, genau auf das zugeschnitten, was gesucht wird.

Schaffe es an den ATS-Filtern vorbei

Benefits dieser Stelle

401(k) participation
Pension
Vacation benefits
Medical, dental, vision benefits
Flexible benefits
Life insurance
Well-being benefits

Zusammenfassung

Eli Lilly’s Lilly Medicine Foundry is building a GMP‑regulated data platform. Onsite Indianapolis role to design and deliver data pipelines and cloud data lakehouse solutions across AWS and Azure for lab, process engineering, manufacturing, quality, and analytics use cases.

You will translate data movement into reusable data domains and data‑as‑a‑product capabilities, focusing on modern ingestion, performance, and quality from the start.

Qualifikationen

  • Bachelor's degree or higher in a technical field.
  • 5+ years of data engineering experience across data modeling, ETL/ELT, and data products.
  • 2+ years in a pharmaceutical GMP setting (CMC/Discovery R&D/Manufacturing).
  • Experience with AWS and Azure cloud platforms.

Aufgaben

  • Design and build data pipelines across multiple systems on site.
  • Collaborate with Data Architect and Data Scientists to translate data flows into reliable data products.
  • Integrate IT and OT sources with AWS/Azure data lakehouse for analytics and AI use cases.
  • Implement data value chain: capture, ingestion, integration, contextualization, harmonization, delivery.
  • Apply medallion architecture, streaming ingestion, and API-based extraction.
  • Write clean, performant code ensuring trustworthy analytics-ready data.
  • Apply GxP and GMP data integrity from design to deployment.
  • Participate in design reviews, governance, and compliance.

Kenntnisse

AWS
Azure
Medallion architecture
Streaming ingestion
API-based extraction
MQTT
AQMP
Kafka
Postgres
Redshift
Aurora
Athena
Neptune
DynamoDB
MongoDB
SQL
ER*Studio
Erwin
TOAD
Data Governance
Master Data Management
Business Intelligence
GxP
GMP
Computer System Validation
CI/CD
GitHub
Data modeling

Ausbildung

Bachelor's degree in Computer Science, Data Science, Engineering, or related field

Tools

ER*Studio
Erwin
TOAD

Jobbeschreibung

Eli Lilly’s Lilly Medicine Foundry is building a data platform purpose-built for a GMP-regulated manufacturing environment. In this onsite role, you will design and deliver data pipelines and cloud data lakehouse solutions that connect IT and OT source systems across AWS and Azure, enabling reliable, scalable data products for lab, process engineering, manufacturing, quality, and analytics use cases.

Working as a Data Engineer, you will translate end-to-end understanding of how data moves through the Foundry into reusable data domains and data-as-a-product capabilities. The role emphasizes modern ingestion and extraction patterns, performance-focused implementation, and a quality mindset from the start.

What you’ll do
  • Design and build data pipelines that support multiple systems across the site.
  • Partner with the Data Architect and Data Scientists to understand Foundry data flows from lab systems, process engineering, and manufacturing execution to quality and process analytics, then turn those insights into reliable, scalable data products.
  • Integrate IT and OT source systems with cloud data lakehouse architecture across AWS and Azure to enable analytics and AI/ML/agentic AI use cases.
  • Enable the full data value chain, including capture, ingestion, integration, contextualization, harmonization, and delivery as reusable data domains and data-as-a-product.
  • Apply modern patterns such as medallion architecture, streaming ingestion, and API-based extraction.
  • Write clean, maintainable code and optimize for performance with careful attention to how data becomes trustworthy and analytics-ready.
  • Apply GxP data integrity requirements and Good Manufacturing Practices from the beginning of design and implementation.
  • Participate in design reviews, maintain traceability, and help contribute to governance frameworks that support ongoing compliance.
  • Collaborate with stakeholders across Operations, Quality, Lab, and Engineering to understand data needs and elicit requirements.
  • Identify gaps between operational realities and technical needs, translate them into sound designs, and communicate architecture decisions to non-technical audiences.
  • Investigate upstream and downstream dependencies, seek reuse opportunities for existing services and integrations, and build in alignment with broader data architecture.
  • Track emerging tools and technologies across AWS and Azure ecosystems, bring informed perspectives on adoption, and contribute to the team’s collective capability.
  • Design, develop, and maintain solutions for data capture, storage, integration, and analytics in partnership with Lilly technology teams.
  • Review architectures and provide practical recommendations on design patterns, performance optimization, database versions, and database deployment strategies.
  • Analyze large, complex data domains and develop practical approaches for downstream data exploitation via analytics.
What you’ll bring
  • Bachelor’s degree in Computer Science, Data Science, Engineering, or a related technical field.
  • 5+ years of experience across several areas including data modeling, ETL/ELT, ontology development, semantic graph construction, and linked data, plus relational schema design.
  • 2+ years of that experience in a relevant pharmaceutical GxP setting (CM&C, Discovery R&D, or Manufacturing).
  • Experience with AWS and Azure cloud platforms.
  • Experience with AI/ML/LLM concepts and tools, including building agentic AI solution sets.
  • 1-3 years designing large-scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional).
  • Demonstrated SQL and data modeling proficiency.
  • Experience using data modeling tools such as ER*Studio, Erwin, or TOAD.
  • Data integration experience including streaming and Industrial IoT using MQTT, AQMP, Kafka, and related protocols.
  • Understanding of modern data architecture concepts, including data lakehouse and data warehousing and/or big data.
  • 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, NoSQL like DynamoDB and MongoDB) and formal database designs (3NF, Dimensional Models).
  • Experience with Agile development, CI/CD, GitHub, and automation platforms.
  • Knowledge of data functions including Data Governance, Master Data Management, and Business Intelligence.
  • Prior work experience in pharma or other GMP settings.
  • Solid knowledge of Computer System Validation process.
  • Strong problem‑solving skills for analyzing, anticipating, and resolving complex issues.
  • Learning agility and curiosity, plus the ability to communicate effectively across diverse forums and methods.
Tools and technologies you may work with
  • AWS, Azure
  • Medallion architecture, streaming ingestion, API-based extraction
  • MQTT, AQMP, Kafka
  • Postgres, Redshift, Aurora, Athena
  • Neptune, DynamoDB, MongoDB
  • SQL, ER*Studio, Erwin, TOAD
  • Agile Development, CI/CD, GitHub
  • GxP, GMP, Computer System Validation
Compensation and benefits
  • Salary: USD 129,000 - 231,000 per year
  • Company bonus (based in part on company and individual performance)
  • Eligibility to participate in a company-sponsored 401(k)
  • Pension
  • Vacation benefits
  • Eligibility for medical, dental, vision, and prescription drug benefits
  • Flexible benefits (for example, 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 (employee assistance program, fitness benefits, and employee clubs and activities)
Location

Onsite in Indianapolis, IN 46260. The role is expected to move to Lebanon, IN beginning late 2027-2028. Until then, work location remains Indianapolis.

Minimum experience: 5 years.

Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

LillyDirect Pharmacy Data Engineer
LillyDirect Pharmacy Data Engineer

Eli Lilly and Company • USA

Vor Ort
USD 66.000 - 189.000
Company bonus
401(k) and pension
Vacation benefits
+3
Lilly Medicine Foundry – Senior Technical Lead – Quality Systems, Automation & AI
Lilly Medicine Foundry – Senior Technical Lead – Quality Systems, Automation & AI

Eli Lilly • Lebanon (IN)

Vor Ort
USD 129.000 - 231.000
Company bonus
401(k) plan
Pension
+3
Engineer - Automation Engineering -- Analytical Systems Support
Engineer - Automation Engineering -- Analytical Systems Support

BioSpace • Lebanon (IN)

Vor Ort
USD 66.000 - 172.000
Company bonus
401(k) plan
Pension
+5
Scientist/Engineer, Biologics Technical Operations - Lilly Medicine Foundry
Scientist/Engineer, Biologics Technical Operations - Lilly Medicine Foundry

Lilly • Indianapolis (IN)

Vor Ort
USD 68.000 - 152.000
Company bonus
401(k) plan
Pension
+2
Scientist/Engineer, Biologics Technical Operations - Lilly Medicine Foundry
Scientist/Engineer, Biologics Technical Operations - Lilly Medicine Foundry

Lilly • Lebanon (IN)

Vor Ort
USD 68.000 - 152.000
Bonus eligible
401(k) plan
Medical, dental, vision benefits
+1
Scientist/Engineer, Mixed Modality Technical Operations - Lilly Medicine Foundry
Scientist/Engineer, Mixed Modality Technical Operations - Lilly Medicine Foundry

Biopharma Asia • Lebanon (IN)

Vor Ort
USD 68.000 - 174.000
Company bonus
401(k) plan
Health benefits
+1
LillyDirect Pharmacy Technical Product Owner Patient Data
LillyDirect Pharmacy Technical Product Owner Patient Data

Biopharma Asia • Indianapolis (IN)

Vor Ort
USD 129.000 - 189.000
401(k) plan
Pension benefits
Vacation benefits
+1
Scientist/Engineer, Mixed Modality Technical Operations - Lilly Medicine Foundry
Scientist/Engineer, Mixed Modality Technical Operations - Lilly Medicine Foundry

BioSpace • Lebanon (IN)

Vor Ort
USD 68.000 - 174.000
401(k) plan
Pension
Vacation benefits
+5
Scientist/Engineer, Biologics Technical Operations - Lilly Medicine Foundry
Scientist/Engineer, Biologics Technical Operations - Lilly Medicine Foundry

Eli Lilly and Company • Indianapolis (IN)

Vor Ort
USD 68.000 - 152.000
Engineer - Automation Engineering -- Analytical Systems Support
Engineer - Automation Engineering -- Analytical Systems Support

Eli Lilly and Company • Indianapolis (IN)

Vor Ort
USD 66.000 - 171.600