Associate - Tech@Lilly

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.

Manufacturing and Quality Tech@Lilly (MQ Technology at Lilly) supports manufacturing operational excellence and productivity efforts through utilization of information and technology. MQ Tech@Lilly strives to enable the making of medicine “with safety first and quality always”.  Significant investment and usage of data and analytics in the making of medicine is occurring where capabilities from simple visualizations to predictive and prescriptive analytics and machine learning are rapidly emerging across the global manufacturing landscape. To support and enable the running of the site, a robust data strategy and architecture is required. The architecture needs to include IT and OT data and be based on cloud technology.

The Data Architect will be responsible for defining the vision, strategy, and principles to manage all data most effectively across the site and setting up the necessary processes for its continued expansion, maintenance, and support. In addition, it will have the responsibility of defining this data strategy and related architecture. The Data Architect will need to work with local and global stakeholders to ensure delivery of the solutions prioritized by the site.

Basic Requirements:

• Bachelor’s degree in Engineering or Computer Science
• 3+ years of experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional) 
• Demonstrated SQL and data modeling proficiency
• Demonstrated ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics  
• Ability to review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies  
• Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence
• Experience with data modeling tools.
• Experience in AWS or Azure
• Experience with security models and development on large data sets 
• Experience with multiple database technologies  
• Experience with multiple database solutions (e.g. Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models) 
• Experience with Agile Development, CI/CD, Jenkins, Github, Automation platforms  
• Demonstrated ability to communicate with a geographically dispersed group of business and technical colleagues 
• Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence 
• Experience in moving on premises solutions into cloud and knowledge in multiple data ingestion patterns
• Mobility within and outside Puerto Rico and the Unites States.
• Work as a resource in other areas of the business, based on business needs.
• Availability to provide support to a 24/7 operation as needed (irregular hours, shifts rotation, weekends, holidays, emergencies).
• Fully bilingual (English/Spanish)
• Strong written and verbal communication skills
• Teamwork oriented
• Exceptional interpersonal and customer service skills
• Ability to manage multiple priorities and work under supervision.
• Strong compliance mindset and sound judgment

Additional Preferences :

• CDMP Certification 
• AWS Solution Architect
• Experience in several of the following disciplines: statistical methods, data modeling, ontology development, semantic graph construction and linked data, relational schema design, artificial intelligence and machine learning 

Important Notice: In order to maintain the excellent reputation of our company, the quality of our products, and the safety of our working environment, the company will take all reasonable measures to ensure that drug abuse by employees or other persons does not jeopardize the safety of our operations or the quality of our products or adversely affect in any way the company or its employees. The company recognizes that drug use both on and off the job can be detrimental to the company and its efforts to provide a drug-free workplace. Even if prescribed under a state medical marijuana law, marijuana remains illegal under federal law. Marijuana is considered unauthorized by Lilly.

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 is proud to be an EEO Employer and does not discriminate on the basis of age, race, color, religion, gender identity, sex, gender expression, sexual orientation, genetic information, ancestry, national origin, protected veteran status, disability, or any other legally protected status.

Our employee resource groups (ERGs) offer strong support networks for their members and are open to all employees. Our current groups include: Africa, Middle East, Central Asia Network, Black Employees at Lilly, Chinese Culture Network, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinx at Lilly (OLA), PRIDE (LGBTQ+ Allies), Veterans Leadership Network (VLN), Women’s Initiative for Leading at Lilly (WILL), enAble (for people with disabilities). Learn more about all of our groups.

Actual compensation will depend on a candidate’s education, experience, skills, and geographic location.  The anticipated wage for this position is

Full-time equivalent employees also will be eligible for a company bonus (depending, in part, on company and individual performance). In addition, Lilly offers a comprehensive benefit program to eligible employees, including eligibility to participate in a company-sponsored 401(k); pension; vacation benefits; eligibility for medical, dental, vision and prescription drug benefits; flexible benefits (e.g., healthcare and/or dependent day care flexible spending accounts); life insurance and death benefits; certain time off and leave of absence benefits; and well-being benefits (e.g., employee assistance program, fitness benefits, and employee clubs and activities).Lilly reserves the right to amend, modify, or terminate its compensation and benefit programs in its sole discretion and Lilly’s compensation practices and guidelines will apply regarding the details of any promotion or transfer of Lilly employees.

#WeAreLilly