Apply on Employer Site

Eli Lilly and Company · 14 hours ago

Data Engineer - Lilly Medicines Foundry

Indianapolis, IN

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. They are seeking a Data Engineer to design, develop, and maintain data pipelines and solutions to ensure data availability and quality for their new Lilly Medicines Foundry facility, focusing on integrating IT/OT systems with cloud architecture for 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

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)

Qualification

Data EngineeringETL/ELTData ModelingCloud PlatformsSQLData GovernanceMaster Data ManagementAI/ML ConceptsAgile DevelopmentProblem SolvingCommunicationTeamworkLeadership

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

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

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

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