Advisor, Data Architect – Data Foundry

Eli Lilly and Company

Design and build data infrastructure for AI-native drug discovery at Lilly. Creating schemas, ontologies, and data models to enable optimal scientific decision-making.

Posted 4/29/2026full-timeSan Francisco • California, Colorado, Massachusetts • 🇺🇸 United StatesMid-LevelSenior💰 $151,500 - $222,200 per yearWebsite

Tech Stack

Tools & technologies

ETLKafkaMongoDBNeo4jSpark

About the role

Key responsibilities & impact

Design and implement data models, schemas, and ontologies for chemical, biological, and automation-generated data
Define and maintain controlled vocabularies, metadata standards, and FAIR-compliant data frameworks
Implement semantic data standards (RDF, OWL, SPARQL)
Design and implement data lakehouse architecture using modern platforms (Databricks, Snowflake, or equivalent)
Build and optimize ETL/ELT pipelines using Spark, dbt, or similar tools
Implement real-time and streaming data integration (Kafka, Kinesis)
Design and implement knowledge graphs (Neo4j, Amazon Neptune, TigerGraph)
Partner with scientific software engineers to ensure data architectures are implementable and performant
Contribute to build-versus-buy-versus-adopt decisions by evaluating commercial and open-source data platforms

Requirements

What you’ll need

M.S. or PhD in Computer Science, Data Science, Bioinformatics, Computational Biology, Information Science, or related STEM field
MS (with 6+ years) and PhD (with 2+ years) of data architecture, data engineering, or scientific informatics experience
Deep expertise in at least one of the focus areas: relational databases, data modeling and ontology engineering, data platform and lakehouse architecture (Databricks, Snowflake, Spark), or knowledge graph and specialized database systems (Neo4j, Neptune, MongoDB, TileDB)

Benefits

Comp & perks

Company bonus
Eligibility to participate in a company-sponsored 401(k)
Pension benefits
Vacation benefits
Medical benefits
Dental benefits
Vision benefits
Prescription drug benefits
Flexible benefits
Life insurance
Death benefits
Well-being benefits

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 & Tools

data modelingontologiesETLELTsemantic data standardsdata architecturedata engineeringknowledge graphsrelational databasesdata platform