Analyst-Tech@Lilly

At Lilly, the work is demanding because patients are waiting. We unite caring with discovery to help make life better for people around the world, knowing that every decision, every detail, and every day matters. Headquartered in Indianapolis, Indiana, our over 50,000 employees around the globe take on complex challenges to discover and deliver life-changing medicines, strengthen how health is understood and managed, and support the communities we serve. This is hard, urgent, selfless work—but it’s work worth doing. If you’re driven by purpose and ready to bring your best to work that truly matters for patients, we invite you to join us.

Patients are at the center of everything we do at Lilly. We are currently hiring a Analyst-Tech@Lilly

This role supports critical work that helps bring medicines and solutions to patients responsibly and efficiently. #WeAreLilly.

The Analyst 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. The analyst 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.

"Qualified applicants must be authorized to work in the United States on a full-time basis. Lilly will not provide support for or sponsor work authorization or visas for this role, including but not limited to F-1 CPT, F-1 OPT, F-1 STEM OPT, J-1, H-1B, TN, O-1, E-3, H-1B1, or L-1."

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 (AMECA), Black Employees at Lilly (BE@Lilly), Chinese Culture Network (CCN), EnAble, Evolve, Lilly Indian Network (LIN), Organization of Latinx at Lilly (OLA), Pride (LGBTQ+ Allies), Veterans Leadership Network (VLN) and Women’s Initiative for Leading at Lilly (WILL).

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

$52,500 - $132,000

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