> Markdown version of [/jobs/ext/4378660-data-engineer-lilly-medicine-foundry](https://www.wearedevelopers.com/jobs/ext/4378660-data-engineer-lilly-medicine-foundry). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - Lilly Medicine Foundry - **Company:** The Lilly Company - **Location:** Indianapolis, IN, United States - **Experience:** Starter - **Salary:** $129,000.0 - $231,000.0 - **Contract:** Permanent contract - **Skills:** Third Normal Form, Adobe InDesign, Agile Methodology, Artificial Intelligence, Amazon Web Services, Microsoft Azure, Big Data, Cloud Computing, Databases, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Database Design, Database Development, Software Design Patterns, Dimensional Modeling, Amazon DynamoDB, Github, Laboratory Information Management Systems, PostgreSQL, Linked Data, Automation of Marketing, MongoDB, Message Queuing Telemetry Transport (MQTT), NoSQL, SQL Databases, Data Streaming, System Testing, Azure Data Factory, Large Language Models, Information Technology, Toad (Software), Apache Kafka, Data Management, Data Lakehouse, GXP - **Published:** October 26, 2026 - **Apply:** https://www.indianapolisgigs.com/job.asp?id=3472133196&tx=HT767TYI&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54 ## About the Role * Bachelor's degree in Computer Science, Data Science, Engineering or related technical field * 5+ years of experience in several of the following disciplines: data modeling, ETL/ELT, ontology development, semantic graph construction and linked data, relational schema design. * 2+ years of that data engineering experience should be in a relevant pharmaceutical GxP (CM&C, Discovery R&D, or Manufacturing) setting. Additional Skills / Preferences: * Experience with cloud platforms (e.g., AWS, Azure). * 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 (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 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. ## Description * Ensure compliance : You understand the data integrity requirements of a GxP manufacturing environment and apply Quality guidelines and Good Manufacturing Practices from the start. You participate in design reviews, maintain traceability, and contribute to governance frameworks that keep the Foundry consistently compliant. * Translate business needs into technical outcomes. You engage proactively with stakeholders across multiple modalities and business teams including Operations, Quality, Lab, and Engineering to understand their data needs. You're comfortable eliciting requirements, identifying gaps, and translating operational realities into sound technical designs - and explaining your architectural decisions back to a non-technical audience. * Navigate a diverse enterprise landscape : The Foundry operates within a broader Lilly ecosystem of enterprise systems including ERP, ELN, MES, LIMS, Historians, PLM, and QMS platforms. You invest time in understanding upstream and downstream dependencies, seek opportunities to reuse existing services and integrations, and build with the broader data architecture in mind. * Continuous learning : You 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. * 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. * Staying abreast of tools and technologies to influence Technology 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 Technology at Lilly teams. * 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