Data Architect, 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 Architect, 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:

• Extensive experience designing, building, and maintaining enterprise-scale data warehouses using relational database technologies (e.g., PostgreSQL, MySQL, Graph) and data modeling techniques.
• Deep understanding of ETL (Extract, Transform, Load) processes and best practices for data integration.
• Experience working with large datasets and optimizing data warehouse performance for reporting and analytics
• Strong knowledge of cloud-based data platforms and their components (required):
• AWS (essential): Amazon Redshift, Amazon S3, AWS Glue, Amazon EMR, Amazon Athena.
• Azure (preferred): Azure Synapse Analytics, Azure Data Lake Storage, Azure Databricks.
• Experience designing and implementing data pipelines on these platforms, including data ingestion, processing, and storage optimization
• Familiarity with big data concepts and technologies such as Hadoop, Spark, or similar, for processing and analysing massive datasets Proficiency in data modelling for Databases, Data Warehouses
• Knowledge / working experience in Datalake architecture
• Have experience in Data Security and Data migration
• Good to have
  • Working knowledge in Tools / Platforms such as Airflow, Kafka, GraphDB, Github CodeSpaces
  • DevOps deployment tooling such as Jenkins
  • Experience in Data Migration from on-prem to AWS
  • Experience in DBs such as Oracle, MSSql, Postgres
• Data Governance & Security:
  • Experience defining and implementing data governance policies and procedures to ensure data quality, integrity, security, and compliance with regulations.
  • Understanding of data privacy concerns and best practices for data anonymization and security.
  • Strong communication and collaboration skills to work effectively with data engineers, analysts, and business stakeholders to understand requirements and translate them into robust data architectures

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