Data Architect - M&Q IT

Lilly • Pleasant Prairie, WI

1d • Onsite

About The Position

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.
Lilly is entering an exciting period of growth, and we are committed to delivering innovative medicines to patients around the world. This is an exciting once-in-a-lifetime opportunity to work in a state-of-the-art manufacturing site, in Kenosha County, Wisconsin.
The facility will utilize the latest technology to increase the company's manufacturing capacity in parenteral (injectable) medications, device assembly and packaging operations. The Lilly Kenosha site will leverage use of high-tech equipment, advanced highly integrated and automated manufacturing systems, and have a focus on minimizing the impact to our environment.
As Data Architect you will be responsible for defining, designing, building, and maintaining the data architecture vision, strategy, and principles for the Kenosha Manufacturing Site. Define standards for naming, describing, governing, managing, modelling, transforming, and searching all data within the enterprise or a business function. Data architect has deep working knowledge of how data is or will be used and implications on people, processes, capabilities, and technologies including analytics and data integrations. This role requires skills such as data modelling, data warehousing, data integration, data governance and an understanding of data security, data standards, and cloud architecture principles. Data architects work closely with data producers, information management, data engineers, and data consumers.

Requirements

• Bachelor’s Degree in Computer Science, Information Technology or related technical field.
• 10 plus years of experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional).
• 7 plus years of experience in several of the following disciplines: statistical methods, data modelling, ontology development, semantic graph construction, linked data and/or relational schema design.
• 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.
• Experience with SQL and data modelling proficiency. Experience with data modelling tools such as, ERStudio and Erwin or TOAD.
• Demonstrated communication, leadership, teamwork, project delivery, and problem solving skills
• Experienced in architectural processes (e.g. blueprinting, reference architecture, governance, etc.)
• Understanding of external data standards (e.g. HL7, CDISC, SDTM) and external data vocabularies (e.g. MedDRA, RxNorm, SNOMED)
• Health care industry knowledge and business acumen
• Experience as an autonomous IT leader leading large scale portfolios and sophisticated high demanding customers.
• 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.

Nice To Haves

• Experience in cloud technologies: AWS and/or Azure.
• Experience with security models and development on large data sets.
• Experience with multiple database technologies and solutions (e.g. Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models).
• 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
• Master’s degree in Computer Science, Information Technology, Business Administration, or a related field is preferred.
• Exposure to international operations, diverse teams, global IT projects, or working in a global organization.
• Previous Agile experience. Experience with Agile Development, CI/CD, Jenkins, Github, Automation platforms.
• CDMP Certification.
• AWS Solution Architect.
• Previous health care experience.
• Previous pharmaceutical manufacturing experience.

Responsibilities

• Data/Information Vision and Strategy includes the ability to work with business to identify future uses for Lilly data and anticipated business results and enable processes to support these needs.
• Data Planning/Modelling and Data Lifecycle Design includes the ability to develop a technical strategy for future data structure and data integration.
• Develop and provide expertise 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 at Lilly collaborations.
• Analyze data from multiple domains; discover trends and associations, synthesize new integration constructs that assist non-expert users to find similar trends and associations.
• Facilitate efficient and scalable data exchange between Lilly and its external partners using industry standards and data integration methodologies.
• Use cutting edge information technologies to organize and analyze data.
• Extend publicly available data sets, ontologies, and taxonomies for internal Lilly use.
• 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.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level