Data Architect – Nextgen Qms

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

Come help us transform Lilly’s Quality Management System! 

Lilly has initiated a multi-year QMS transformation program that will enable 1) simplified, standardized, and optimized QMS processes, 2) innovation and agility for unprecedented growth with new sites, modalities, and partnerships, and 3) modernization of solution infrastructure by moving to cloud-based solutions and advanced technology.  The MQ Tech@Lilly Global Quality team is actively looking for a Data Architect to join the NextGen QMS Program.   

What You’ll Be Doing: 

You will be responsible for defining, designing, building, and maintaining the Data Architecture vision, strategy, and principles for the NextGen QMS Program.  You will define standards for naming, describing, governing, managing, modeling, transforming, and searching data from Lilly’s NG QMS solution.  You will be a key contributor to the Integration and Data Workstream of the NextGen QMS Program with a focus on QMS data publication strategy.   

How You’ll Succeed: 

• Partner with Lilly architects, software vendor, and third party implementation partner to develop and execute on a technical strategy for NG QMS data structure and data products. 

• Work with business to identify future uses for Lilly data and anticipated business results and enable processes to support these needs.  

• Develop and provideexpertise in enterprise data domains; this includes data relationships, data quality, understanding of business data needs and the associated technology toolsets and methodologies.  

• Develop understanding how the enterprise data strategies, platforms, and technologies enable business execution. Use this knowledge to appropriately challenge status quo and drive business and Tech@Lillycollaborations.   

• Continuously scan the technology environment for new trends and techniques; interface with external consultants and thought leaders as needed.  

• Synthesize new scalable approaches for Lilly data integration; derive the supporting arguments, communicate, and articulate the reasons for the new approaches to fellow engineers as well as senior management.  

• Possess a deep working knowledge of how data is or will be used and implications on people, processes, capabilities, and technologies including analytics and data integrations.  

• Work closely with data producers, information management, data engineers, AI/ML engineersand data consumers. 

• Should be able to provide direction to the data engineers from implementation standpoint, should guide the team, able to see the holisitic picture, understand the upstream and downstream systems, analyse impacts when there are new changes made to the architecture and provide the right solution.

What You Should Bring: 

• Demonstrated communication, leadership, teamwork, project delivery, andproblem solving skills 

• Experienced in architectural processes (e.g. blueprinting, reference architecture, governance, etc.)  

• Experienced in driving atleast 1-2 large scale implementations from Data Architecture standpoint.

• Understanding of external data standards (e.g. HL7, CDISC, SDTM) andexternal data vocabularies (e.g.MedDRA, RxNorm, SNOMED)  

• Skills in data modeling, data warehousing, data integration, data governance and an understanding of data security, data standards, and cloud architecture principles. 

• Demonstrated ability to influence IT and business strategies to drive large-scale outcomes. 

• Validated skills of strong learning agility and relationship building to influence change using knowledge and relationships. 

• Successful record of high quality, user focused, on-time & budget IT service and project delivery. 

• Experience with formal project management methodologies, agile frameworks (including Scrum, Kanban, SAFe, etc. ) and working knowledge of associated practices and tools. 

• Excellent analytical, problem solving and communication skills, working across agile and diverse teams.  

• A high level of intellectual curiosity, external perspective, and innovation interest. 

• Experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional) including the creation of data dictionary.

• Experience with data modelling tools like Erwin Data Modeler, ER/Studio, Lucidchart etc. 

• Experience in several of the following disciplines: statistical methods, data modeling, data administration, ontology development, semantic graph construction and linked data, relational schema design.  

• Demonstrated SQL/PLSQL and data modeling proficiency.   

• Experience in AWS, Azure techstack and other cloud technologies.  

• Experience with security models and development on large data sets. 

• Experience working with a variety of relational and non-relational databases. 

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

Basic Qualifications: 

• Bachelor’s Degree in computer science or related scientific discipline.  

• 10 plus years of relevant work experience. 

• Experience working in regulated environments and with internal systems quality policies and procedures. 

Additional Preferences  

• Knowledge of GxP, Pharmaceutical manufacturing processes and automations systems   

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