Data Engineer, Research IDS

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.

At Lilly, we believe in the talent of our workforce. One of the best ways to utilize and develop that talent is to use our existing workforce to fill new and/or open positions. If you are looking for a new position within Lilly, you can view and apply to open roles posted in the internal job posting system. You must meet the minimum qualifications outlined in the job description and have/obtain work authorization in the country the position is located in order to be considered. When applying internally for a position, your current supervisor will receive notification that you have applied to the position. We encourage employees to discuss the opportunity with their supervisor prior to applying.

Path/Level:

R1

Note: Roles are posted at the lowest level of a band, however, employees should search across all levels of the band to identify all opportunities. Employees hired on banded positions (ex: P1-P3, R1-R2, B1-B3, etc.) transfer at their current level, despite the level indicated on the job posting. For example, if a P2 candidate is selected for a P1-P3 banded position, the candidate will remain a P2 in the new role.

Position: Data Engineer, Research IDS

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 39,000 employees 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 globe.

Detailed Description:

Competency with Data Information Management:

Information Management is the overall management of all types of information, structured and unstructured, whether produced internally or externally, which are used to support decision-making, business processes and digital services.

Individuals in Information Management are perceived as subject matter experts on the Cloud Database products for their function to provide recommendation on Cloud services.

Key capabilities in this role family includes:

• Information Lifecycle – is the application of policies and standards to enable information management continuum (the acquisition and exchange, validation, integration and preparation, accessibility, and storage and archival of information).

• Information Strategy - is responsible for defining the information framework that ensures compliance with regulations, standards and codes of good practice relating to information and records management, information assurance and data protection.

• Information Governance - ensure the data assets are fit for purpose, reliable, and protected at all levels of organization across all functions and locations.

• Information Stewardship - include management of taxonomies, data and metadata along with data quality. Ensures Master and Reference data domains are well defined and mapped to authoritative sources.

Note: All information management roles should have a foundational set of knowledge in: communication, leadership, teamwork, problem solving skills, solution / blueprint definition, business acumen, architectural processes (e.g. blueprinting, reference architecture, governance, etc.), technical standards, project delivery, and industry knowledge.

Business Analysis and Technical Leadership:

• Engages with business and proactively seeks opportunities to deliver business value.

• Understands business requirements and effectively translates business needs and process into technical terms, and vice versa

• Elicits and defines requirements

• Ensures appropriate business roles are engaged in solution execution.

• Participates in design reviews to ensure traceability of requirements.

• Networks with appropriate IT colleagues to determine solutions to meet business partners’ needs.

• Seeks opportunities to reuse existing processes and services to streamline support and implementation of key systems.

• Stay abreast of tools and technologies to influence IT strategy so that it provides best usage opportunities for business

• Ability to adapt quickly in a constantly changing environment

Required Technology skillset:

• 5+ year’s hands-on experience with AWS services, AWS Cloudformation(CFT), CI/CD, AWS CodePipeline, CodeBuild, databases and related technologies.

• Programming experience with SQL and Python.

• Strong Hands-on experience in built/deploy of end-to-end project.

• Experience in ETL processing in AWS cloud, experience in works on orchestration tools preferably Airflow.

• Strong working experience in data lakes and data concepts.

• Advanced administration experience with AWS PaaS DB offerings such as RDS, Aurora, DynamoDB, ElastiCache RedShift, and IaaS options i.e. Databases provisioned on EC2 instances.

• Experience in managing operational support and implementation of large-scale, enterprise level solutions.

• Oversees and provides technical direction in design, install, configure, maintain, troubleshoot, test, monitor, and analyze the performance of the AWS Data Instances including AWS Postgres and SQL Server . Provide detailed usage, storage, and system performance to management.

• Design data models, implement, automate, optimization and monitor data pipelines

• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.

• Expertise with the design of infrastructure and integration into new and existing database systems

• Working knowledge on different AWS technologies such as S3, Redshift, Lambda, Athena,Glue, etc... and explore and learn the latest AWS technologies to provide new capabilities and increase efficiency

• Should have worked on at least 1 project involving hybrid cloud implementation.

• Should be aware of basic ITSM principles and knowledge.

• Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

• Must possess strong verbal and written communication skills, be self-driven, and deliver high quality results in a fast-paced environment.

Basic Qualifications:

• Bachelor’s degree in computer science or related scientific discipline.

• 5 + years of relevant work experience.

Preferred Qualifications / Certifications:

• Experience working in regulated environments and with internal systems quality policies and procedures.

• Experience in working in Scrum /agile methodologies.

• Experience in development and deployment on cloud infrastructure.

• Pharmaceutical or healthcare industry experience.

• Defining best practices and developing technical standards, design principals, best practices, and frameworks.

• Technical curiosity and desire to innovate.

About the Organization:

Lilly IT builds and maintains capabilities using cutting edge technologies like most prominent tech companies. What differentiates Lilly IT is that we create new possibilities through tech to advance our purpose – creating medicines that make life better for people around the world, like data driven drug discovery and connected clinical trials. We hire the best technology professionals from a variety of backgrounds, so they can bring an assortment of knowledge, skills, and diverse thinking to deliver innovative solutions in every area of our business.

Lilly is entering an exciting period of growth, and we are committed to delivering innovative medicines to patients around the world. Lilly is investing around the world to create new state-of-the-art manufacturing site’s and continue expanding our existing facilities to created capacity required to continue with our mission. The brand-new facilities will utilize the latest technology, advanced highly integrated and automated manufacturing systems, and have a focus on minimizing the impact to our environment.

Note: When applying internally for a position your current supervisor receives notification that you have applied to the position. We encourage employees to discuss the opportunity with their supervisor prior to applying.

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

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