Associate Director-Data Architect

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.

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

$106,500 - $156,200

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 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

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. 

·       Previous health care experience  

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 an EEO/Affirmative Action Employer and 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.

Our employee resource groups (ERGs) offer strong support networks for their members and help our company develop talented individuals for future leadership roles. Our current groups include: Africa, Middle East, Central Asia Network, African American Network, Chinese Culture Network, Early Career Professionals, Japanese International Leadership Network (JILN), Lilly India Network, Organization of Latinos at Lilly, PRIDE (LGBTQ + Allies), Veterans Leadership Network, Women’s Network, Working and Living with Disabilities. Learn more about all of our groups.

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