This job has closed.

Eli Lilly and Company · 3 hours ago

Data Engineer - Lilly Medicines Foundry

US: Indianapolis IN Tech Center North

Full-time

Hybrid

Mid Level

$64K/yr - $185K/yr

3+ years exp

Eli Lilly and Company is a global healthcare leader headquartered in Indianapolis, Indiana, dedicated to discovering and bringing life-changing medicines to patients. The Data Engineer will be responsible for designing, developing, and maintaining data pipelines and solutions to ensure data availability and quality for the Lilly Medicines Foundry, focusing on integrating IT/OT systems with cloud data architecture to enable advanced analytics and AI/ML capabilities.

BiotechnologyHealth CareMedicalPharmaceutical

No H1B

Responsibilities

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

Work closely with the Data Architect and Data Scientists

Work with business and IT groups beyond the data sphere, understanding the enterprise infrastructure and the many source systems

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

Qualification

Data EngineeringCloud PlatformsData ModelingETL/ELTAI/ML ConceptsData GovernanceBusiness IntelligenceDatabase SolutionsLearning AgilityCommunicationProblem SolvingTeamworkLeadership

Required

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

Preferred

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