Engineer - Automation Engineering – Control System Data Analyst- Lilly Medicine Foundry

Job Title:

Engineer - Automation Engineering – Control System Data Analyst

The Engineer-Automation Engineering – Control System Data Analyst is a technical individual contributor on the Foundry Automation Engineering Team. The role provides data engineering and analytics solutions that support the data historization, analytics, and compliance of automation control systems at the Lilly Medicines Foundry. The position collaborates with Automation Engineers, System Administrators, and other stakeholders to maintain, configure, troubleshoot, and optimize control systems and associated interfaces.

• Provide and 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 the use of data analytics to support site business goals, including awareness and training on data analytics tools and techniques across the Automation Engineering organization.
• 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 activities.
• Support the execution, creation, review, and approval of documentation related to compliance activities such as periodic reviews and application recovery processes.
• 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) and manage CSV documents related to automation systems.
• Administer relational databases with RDBMS tools such as Microsoft SQL Server Management Studio; demonstrate competency with SQL, Power
  
  BI and related software development applications.
• Have experience with data flows and interfaces associated with instrumentation and system integration protocols.
• 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, PI, Ignition, WIN
  911, and Success Factors.
• Ensure compliance with regulatory requirements and industry standards such as GAMP, 21 CFR Part 11, Data Integrity, and Lilly quality policies and procedures.
• Maintain validation documentation, such as validation plans and summary reports.
• Provide training to personnel on CSV principles, procedures, and best practices.
• Collaborate with Site Area leads, System Integrators, and cross‑functional groups on functional requirements, design specifications, test specifications, and system architecture to support data historization.
• Provide periodic status updates to Automation Engineering Management.
• Coordinate change control procedures for data historian systems and perform routine system maintenance checks.
• Lead interfacing of cross‑functional systems such as Historians, QMS, LMS, CMDB, CMMS, and ITSM.
• Develop operating procedures, work instructions, and other job aids to design, operate, organize, maintain, and optimize the Foundry Configuration Management Database (Service Now).
• Identify, track, and report key indicators of functional performance.
• Document and manage knowledge base for troubleshooting applications following templates for problem, traceability, accountability, and resolution.
• Support and implement CSV and quality strategies for control systems in collaboration with Site Quality organization.
• Promote automation and analytics to improve productivity, operational efficiency, and compliance.
• Develop a network of corporate contacts and leverage corporate expertise when needed.
• Set and reinforce standards for appropriate rigor in automation work products in coordination with automation and compliance consultants.
• Participate as an active member of the engineering team in plant operations and management…