Lilly Procurement Data Analyst in Cork, Ireland
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 35,000 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.
At Lilly, we believe in the talent of our workforce. One of the best ways to utilize and develop that talent is to use our existing workforce to fill new and/or open positions. If you are looking for a new position within Lilly, you can view and apply to open roles posted in the internal job posting system. You must meet the minimum qualifications outlined in the job description and have/obtain work authorization in the country the position is located in order to be considered. When applying internally for a position, your current supervisor will receive notification that you have applied to the position. We encourage employees to discuss the opportunity with their supervisor prior to applying.
At Lilly, we make a difference for people the world over by discovering, developing and delivering medicines that help people live longer, healthier and more active lives. Central to all that we do are our talented and motivated professionals, circa 950 of whom are based at our Global Business Solutions centre in Little Island, Cork. There we boast vibrant workforce made up of over 38 nationalities, speaking over 27 languages.
Established in 2010 to gain efficiencies in areas such as General Accounting, Purchase to Pay and Order to Cash, the GBS Cork quickly excelled in its financial mandate, allowing the Cork leadership to ask, how can we apply these processes to other areas of the business? And so the GBS we have today was born, still leading in finance, but also evolving and expanding into diverse Business Service functions including Customer Care, Global HR Data Management, Clinical Trial Management and Scientific Communications, and more to come on stream across 2022.
This, along with the recent physical expansion of the Little Island campus, means there has never been a more exciting time to be part of the GBS story! Mirroring the existing Island House building, the new Island Hall facility extends our overall capacity where Lilly offers a premium workspace across both buildings, complete with flexible working options, healthcare, pension and life assurance benefits, subsidised canteen, wellbeing facilities, travel subsidies, on-site parking and much more.
This role is part of the Souring Centre of Excellence (COE) team. The initial focus of the role is dedicated to helping the Sourcing COE advance its Data Strategy in the areas of Artificial Intelligence (AI) & Machine Learning (ML) along with consulting on the S/4 Hana implementation project to aid Procurement advance its data and analytics capability.
This role will be responsible for managing the strategic metrics & technology platforms and reporting for Lilly’s Global Procurement Organization. The analyst will also design and develop the next generation of procurement reports and analytics. The analyst will bring innovative ideas to improve and implement optimal solutions. Perform simple to complex analysis of data using variables and apply other techniques to achieve sustainability.
Metrics & reporting includes:
Spend and savings analysis
Financial due diligence
Design and Develop Management reports using SAP Hana database & SAP business objects
Data visualization and dashboard creation using tools like Tableau and Power BI
Responsible for developing and managing the Procurement dashboards including Spend, Savings tracker, Supplier Diversity reporting etc.
Partner with data governance team to improve data quality and close spend gaps
Classification of data and consolidation with complete end to end view
Support the category teams with data and analytics requirements
Perform data cleaning activities while the analysis/report is being prepared
Analyze required data sources and the health of data as it pertains to a reporting solution
Assist in mapping the requirement into SAP processes, design and document the solution
Assist the testing of new releases, upgrades or patches of SAP HANA Database
Manage the SHAREPOINT Website for Global Procurement
Manage & Develop all the Apps (Power App, Power Automate, backend system) used by Global Procurement Colleagues
Onboard and train new procurement associates on the Spend Analytics Reporting Solution
Develop adhoc analytic solution using reporting tools like excel, Power Bi, Tableau
Maintain Standard operating Procedures (SOP’s)
Willing to learn new technologies as per the new requirements
Strong Written, Verbal, and Communication Abilities, Analytical Strategic & Tactical Approach, Critical Thinker, Self-Initiator
Technical Skills (Must Have)
Power BI, Power Automate, Project Management, Advanced MS Excel (lookups, Pivot, if else statements), Business Objects
Technical Skills (Good To have)
SAP, Blueprinting and Testing (Preferably SAP),VBA, SQL Server, Power App.
Language - English (required)
Experience - 3 – 5 Years (Healthcare or Pharma Preferred)
Education -Bachelor’s in engineering, Finance or IT
Travel - None
Eli Lilly and Company, Lilly USA, LLC and our wholly owned subsidiaries (collectively “Lilly”) are committed to help individuals with disabilities to participate in the workforce and ensure equal opportunity to compete for jobs. If you require an accommodation to submit a resume for positions at Lilly, please email Lilly Human Resources ( LillyRecruitingCompliance@lists.lilly.com ) for further assistance. Please note This email address is intended for use only to request an accommodation as part of the application process. 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.
At Lilly we strive to ensure our employees are part of a team that cares about them and our shared purpose of making life better for those around the world. How do we do this? We continue to look for ways to include, innovate, accelerate and deliver while maintaining integrity, excellence and respect for people. We hope that you seek to join us on our journey as we create medicine and deliver improved outcomes for patients across the globe!