Data Integration Engineer

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!

Role Overview:

The Data Integrations Engineer is a key member of the Platform Engineering organization, responsible for designing, building, and operating secure, scalable, and automated data movement and integration services across the enterprise. This role focuses on modernizing traditional integration pipelines, enabling frictionless data flow between systems, and driving cloud-first, self-service capabilities that accelerate business outcomes.

Key Responsibilities:

Required Skills & Experience

• 7+ years hands-on experience with enterprise integration tools:
  SFTP, DataSync, Storage Gateway, Axway B2Bi, IBM MQ, Aspera
• Strong experience with ETL/ELT tools and modernization to cloud ecosystems.
• Proficiency in Informatica, or equivalent integration/ETL platforms.
• Knowledge of cloud platforms (AWS/Azure) and data movement services.
• Understanding of networking, APIs, secure protocols, data encryption, certificates, and compliance needs.
• Experience with automation (Python, Shell, Terraform, CI/CD) for deployments and operations.
• Ability to troubleshoot complex integration issues across distributed systems.

Enterprise Data Movement & Integration:

• Design, implement, and support end-to-end data movement solutions using SFTP, DataSync, Storage Gateway, Axway B2Bi, IBM MQ, Aspera, and other enterprise integration tools.
• Build and operate secure file transfer and application-to-application (A2A) messaging solutions across hybrid and multi-cloud environments.
• Ensure reliable, high-throughput, and compliant data exchanges for internal systems, partners, vendors, and regulatory bodies.

ETL/ELT & Cloud Modernization:

• Modernize legacy ETL/ELT pipelines and migrate workloads to cloud-native integration patterns and services.
• Work closely with data engineering teams to establish scalable ingestion, transformation, and synchronization workflows.
• Optimize data pipelines for performance, resilience, and cost efficiency on cloud platforms.

Integration Platform Engineering:

• Contribute to the design and development of reusable integration frameworks, standards, and patterns used across the enterprise.
• Improve platform reliability, observability, and operational automation through monitoring, alerting, and health dashboards.
• Implement secure connectivity patterns including VPN, Direct Connect, private endpoints, and secure protocols.

Automation & Self-Service Enablement

• Build automation for provisioning, deployment, configuration, and monitoring of integration services.
• Develop self-service capabilities for data onboarding, file transfer setups, connector provisioning, and pipeline execution using API-driven workflows.
• Enable policy-based automation for access controls, lifecycle management, compliance, and governance.

Operational Excellence

• Troubleshoot integration failures, performance bottlenecks, and transfer issues across systems and environments.
• Partner with Production Support & SRE teams to ensure high availability, resilience, and recoverability of data transfer services.
• Maintain documentation, runbooks, dashboards, and knowledge artifacts for enterprise adoption.

Collaboration & Stakeholder Management

• Work with application teams, data engineering, cloud engineering, security, and external partners to ensure seamless data movement and integration experiences.
• Communicate technical solutions, integration patterns, and best practices to both technical and business stakeholders.

Preferred Qualifications

• Experience building self-service integration capabilities and reusable frameworks.
• Exposure to event-driven, streaming, or message-based architectures.
• Familiarity with observability stacks (CloudWatch, Splunk, Datadog, OpenTelemetry).
• Knowledge of hybrid data architecture, governance, and data security principles.

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