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.  

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.  

• Comfortable working in a busy and dynamic environment with competing priorities.  

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 does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

Actual compensation will depend on a candidate’s education, experience, skills, and geographic location.  The anticipated wage for this position is

Full-time equivalent employees may also 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 pension plan; vacation benefits; eligibility for healthcare benefits; flexible benefits (if applicable) 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.