Data Architect - M&Q IT at Lilly

Pleasant Prairie, Wisconsin, United States -

Full Time

Start Date

Immediate

Expiry Date

16 May, 26

Salary

184800.0

Posted On

15 Feb, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Modelling, Data Warehousing, Data Integration, Data Governance, Data Security, Cloud Architecture, SQL, ER*Studio, Erwin, TOAD, AWS, Azure, Database Technologies, Dimensional Models, Master Data Management, Business Intelligence

Industry

Pharmaceutical Manufacturing

Description

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. Key Objectives/Deliverables: 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. Basic Qualifications: 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." What you should Bring: Experience with SQL and data modelling proficiency. Experience with data modelling tools such as, ER*Studio and Erwin or TOAD. 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 All data architecture roles should have a foundational set of knowledge in: 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. Additional Skills/Preferences: 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. 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 $64,500 - $184,800 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

Responsibilities

The Data Architect will be responsible for defining, designing, building, and maintaining the data architecture vision, strategy, and principles for the Kenosha Manufacturing Site. This includes defining standards for data naming, governance, modeling, transformation, and searching across the enterprise or a business function.