Sr. Principal Analyst - Data Engineering

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.

Job Posting:

 The Principal 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 and related architecture. This role needs to work with local and global stakeholders to ensure delivery of the solutions prioritized by the site.

Basic Qualifications:

• Bachelor’s degree in engineering, computer science or related scientific discipline. 
• 10 plus years of experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional) 
• Demonstrated SQL and data modeling proficiency.  
• Experience with data modeling tools such as, ER*Studio and Erwin or TOAD 
• Experience in AWS. 
• 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 analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.  
• Demonstrated ability to communicate with a geographically dispersed group of business and technical colleagues 
• 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 in moving on premises solutions into cloud and knowledge in multiple data ingestion patterns
• 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. 
• Previous health care experience  
• 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).

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

$105,000 - $154,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