Engineer - Automation Engineering – Control System Data Analyst

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. Lilly recently announced a $4.5B investment to create the Lilly Medicine Foundry, a new center for advanced manufacturing and drug development. The Foundry integrates research and manufacturing in a single location, enabling innovative solutions to optimize manufacturing processes while increasing capacity for clinical trial medicines and reducing costs and environmental impact.

Job Title:
Engineer - Automation Engineering – Control System Data Analyst

The Engineer-Automation Engineering – Control System Data Analyst is a technical individual contributor for the Foundry Automation Engineering Team. In this role you will provide data engineering and analytics solutions, collaborate with Automation Engineers and System Administrators to maintain, configure, and troubleshoot automation control systems and interfaces, support daily operations, and help implement the process control technical agenda across functional disciplines.

• Provide/Support input to design decisions regarding development and integration of Automation Data Analytics systems and overall Foundry Data Analytics initiatives.
• Lead development and implementation of analytics strategies and tools for metrics, visualization and dashboards across multiple platforms and functional areas.
• Interface with Automation teams and user groups to develop requirements and designs that meet business needs.
• Promote use of data analytics to support site business goals, including training on analytics tools and techniques.
• Support qualification and delivery of Automation Servers, Network and Infrastructure and applications.
• Support the Process Control Validation Plan, CSV, Quality Documents, SOPs, and audit readiness.

• Support execution and creation, review, and approval of documentation for compliance activities such as periodic reviews and application recovery process.
• Support key business processes such as audit, investigation and CAPA.
• Monitor, administer and optimize Automation Quality deliverables (Incidents, Actions, Deviations, Resolutions).
• Act as system owner for the electronic testing system (Kneat, ALM, Valgenesis) managing CSV documents for automation systems.
• Administer relational databases using Microsoft SQL Server Management Studio; basic to intermediate competency with SQL, Power
  
  BI and software development.
• Experience with data flows and interfaces associated with instrumentation and system integration protocols is a plus.
• Provide support for computer system data architecture and data integrity for automation systems across the site, including Service Now, Veeva, DCS, SCADA, BMS, MES, Historian, and LMS.
• Ensure compliance with regulatory requirements and industry standards (GAMP, 21 CFR Part 11, Data Integrity) and Lilly quality policies.
• Maintain validation documentation, such as validation plans and summary reports.
• Provide training on CSV principles, procedures and best practices.

• Collaborate with Site Area leads and System Integrator to ensure Data Historization and System architecture are considered in design.
• Provide periodic status updates to Automation Engineering Management.
• Work with Engineering, Operations and cross‑functional groups to troubleshoot issues, coordinate changes with data historian systems, and perform routine system maintenance.
• Interface cross‑functional systems such as Historians, QMS, LMS, CMDB, CMMS, ITSM.
• Develop SOPs, work instructions and other job aids for design, operation, organization, maintenance and optimization of the Foundry Configuration Management Database (Service Now).
• Identify, track and report key performance indicators.
• Organize and manage a knowledge base for troubleshooting applications following templates regarding problem, traceability, accountability, and resolution.
• Support and implement CSV and quality strategies for control systems in collaboration with Site Quality.
• Promote automation and analytics to improve productivity, operational efficiency and…