EDM Data Architect – Enterprise Data Operations

Overview

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.

Lilly’s Purpose

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our 35,000 employees around the world work to discover and bring life‑changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We’re looking for people who are determined to make life better for people around the world.

Come bring to life technologies to lead in Pharma‑Tech!

The Enterprise Data organization has developed an integrated and intuitive data and analytics platform that enables Lilly team members to ingest, transform, consume, and analyze data quickly. Contributors can easily prepare and publish new data sets for enterprise use, promoting a culture of data accessibility, quality, and innovation.

Job Summary

The Data Architect – Enterprise Data Operations will be a key contributor to the design, performance optimization, and governance of enterprise data platforms. This role is central to ensuring high‑quality, secure, and efficient data flows across the organization. You will lead architectural design, enforce data quality and data contracts, and act as a gatekeeper to production through rigorous code and data quality assessments. This role guides data teams toward scalable, resilient, cloud‑ready solutions across AWS and Databricks, supporting data‑driven decision-making across Eli Lilly.

What You Will Be Doing

Reporting to the Manager, LCCI Tech@Lilly, you will collaborate closely with data engineers, business analysts, quality teams, platform SMEs, data owners, and other stakeholders to design future‑ready data architectures while ensuring performance, reliability, and strong DataOps practices across the lifecycle.

Key Responsibilities

Architecture, Design & Enterprise Governance

• Design robust, scalable, and secure enterprise data models and architectures across business domains.
• Drive and enforce data architecture standards, patterns, and best practices aligned with Lilly’s global data strategy.
• Lead the definition and implementation of data governance policies, including data quality, metadata management, data lineage, and data security.
• Oversee the end‑to‑end data lifecycle — ingestion, transformation, storage, access, and consumption.
• Conduct design reviews and ensure architectural compliance for all data products.
  
  
  

• Optimize Databricks, AWS, and SQL‑based workloads for performance, scalability, and cost efficiency.
• Perform code reviews, validate design decisions, and ensure all workloads meet performance benchmarks prior to production release.
• Continuously assess and tune data pipelines, storage layers, and compute frameworks for speed and reliability.
  
  
  

• Champion DataOps practices across CI/CD, observability, validation, and automation.
• Implement automated checks for code quality, schema enforcement, data quality, and data contracts.
• Drive automation across monitoring, incident detection, lineage updates, and validation workflows.
  
  
  

• Implement and enforce data quality frameworks ensuring accuracy, consistency, and reliability.
• Ensure architecture and systems align with security guidelines, audit requirements, and compliance controls.
• Support patching, cyber vulnerability closure, and validated state maintenance of data systems.
  
  
  

• Partner with data engineers, data scientists, and business stakeholders to translate needs into optimal architecture.
• Provide architectural leadership and mentoring across technical teams.
• Act as a subject matter expert for enterprise data and help upskill teams on architecture and data standards.
• Communicate architectural decisions and performance improvement plans to technical and non‑technical audiences.
  
  
  

• Develop comprehensive architecture documentation, data flows, lineage diagrams, and standards.
• Participate in project planning, estimation, and risk assessment.
• Conduct post‑incident reviews and drive continuous improvement in data architecture and operations.
  
  
  

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or equivalent.
• 5–8+ years of experience in data engineering, data architecture, or enterprise data management roles.
• Strong expertise in AWS services (S3, Lambda, Glue, RDS, Redshift, CloudWatch, IAM) and/or Azure Data Engineering(ADLS, ADF, Azure Databricks).
• Hands‑on proficiency in Databricks, including performance tuning, Spark optimization, Delta Lake, and medallion architectures.
• Deep experience with ETL/ELT processes, SQL optimization, and distributed compute frameworks.
• Strong knowledge of data governance, MDM, metadata management, data lineage, and data quality frameworks.
• Expertise in data modeling (conceptual, logical, physical) using tools like ER/Studio, Erwin, or Sparx EA.
• Experience with CI/CD (GitHub Actions), Apache Airflow, and DataOps methodologies.
• Strong analytical, problem‑solving, and performance‑tuning abilities.
• Solid communication and stakeholder engagement skills.
• ITIL Foundations or hands-on experience with incident, problem, event, and change management.
• Cloud certifications (AWS/Azure) preferred.
• Experience in agile frameworks (Kanban, Scrum, SAFe).
  
  
  

• Experience with AWS Lakehouse, Databricks Unity Catalog, Delta Live Tables.
• Knowledge of privacy and regulatory frameworks in pharma or life sciences.
• Experience designing enterprise-scale architectures (data warehouses, data lakes, data mesh).
• Previous pharma or life sciences industry experience is a plus.
• High learning agility, innovation mindset, and curiosity for emerging tech.
  
  
  

Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form (https://careers.lilly.com/us/en/workplace-accommodation) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.

Lilly does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

#WeAreLilly