Sr. Analyst / Manager - Automation Engineer

At Lilly, the work is demanding because patients are waiting. We unite caring with discovery to help make life better for people around the world, knowing that every decision, every detail, and every day matters. Headquartered in Indianapolis, Indiana, our over 50,000 employees around the globe take on complex challenges to discover and deliver life-changing medicines, strengthen how health is understood and managed, and support the communities we serve. This is hard, urgent, selfless work—but it’s work worth doing. If you’re driven by purpose and ready to bring your best to work that truly matters for patients, we invite you to join us. Overview The GBS Capability Optimisation and Automation (GCOA) organisation is a strategic function focused on transforming finance operations through intelligent automation and AI. GCOA acts as a centralised capability hub, enabling scalable, secure, and compliant solutions that deliver measurable business value. GCOA partners with finance and technology teams to: Identify automation opportunities. Design innovative solutions. Embed automation as a core enabler of operational excellence and digital transformation. Position Description The Automation engineer role (P1-P3) will design and build end-to-end automation solutions for Lilly’s global Finance organization working across our full stack platform. The solutions will primarily be built on a platform consisting of a next.js React frontend with Python and PostgresSQL backend hosted on AWS that will interact with Lilly’s AI Platform (NLM and OCR use cases), Microsoft Fabric (PySpark, Delta Lake), SAP API, Graph API and additional systems APIs where necessary. The primary objective of the team is to develop and deliver automation solutions and other emerging technology solutions for the Finance organization globally. This is a fixed term role, ending November 30 th , 2027. Responsibilities Partner with analyst team to review business opportunities and assessing solution feasibility. Participate in various types of interviews, meetings or workshops to define, design and configure solutions. Use technology to solve problems concerned with business strategy, organisation, procedures & performance and present findings. Analyses and interprets information gained and makes recommendations to business partners and analyst team. Develop solutions in accordance with team standards and best practices. Create architecture and design documents as part of development process. Create and document test procedures and scenarios prior to launching User Acceptance Testing (UAT). Conduct validations with team and business during the development of the project. Support business teams in testing activities, including integration testing, end-to-end (business process) testing and UAT. Support BAU team when necessary to problem-solve issues that arise in day-to-day running of automation processes. Participate in the problem identification/error resolution process, including tracking, repairing and reporting defects. Communicate any identified and potential risks and issues to leadership team accordingly and provide actionable inputs to mitigate. Support QA, audit activities and platform migration activities as needed. Experience 5+ Years of programming experience with systems and applications of varying scope and complexity. Preferably finance and supply chain business processes. Experience with the following technologies: Python, PySpark, TypeScript JS, PostGresSQL. Bachelor’s degree in Business/Management Information Systems or Computer Science or similar related field. Ability to work independently, or in groups, sometimes as lead technical participant. Ability to take on complex assignments and assume increasingly greater responsibilities. Additional preferences Experience with Microservices architecture for modular and independently deployable components. Experience with Docker and Kubernetes for containerization and orchestration, to enable streamlined deployment and scaling processes. Experience with building system interactions through APIs, SAP being most preferable. Experience with SAP, MS Fabric (PySpark notebooks, Delta Lake/OneLake), PowerBI, SharePoint Online. Exposure to GenAI platforms (OpenAI, Anthropic etc). Experience in analysing, debugging, and refactoring legacy code. Exposed to applying statistical concepts and data-quality/anomaly-detection techniques (e.g outlier or threshold-based checks) to business data. Behavioural Skills Strong problem solving and troubleshooting skills. An understanding of workflow-based logic; ability to both understand a business process from a workflow diagram or procedural documentation. Ability to prioritize, schedule and complete development and testing required for multiple applications with overlapping schedules. Experienced in supporting/training more junior team members. Strong verbal and written communications skills