Data Engineer, Research IDS

We’re looking for people who are determined to make life better for people around the world.Position: Data Engineer, Research IDS

Lilly’s PurposeAt 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 versaElicits and defines requirementsEnsures 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 businessAbility to adapt quickly in a constantly changing environmentRequired 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 pipelinesAdvanced knowledge of database security, backup and recovery, and performance monitoring standards.Expertise with the design of infrastructure and integration into new and existing database systemsWorking 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 efficiencyShould 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.#WeAreLillyLilly 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

---