Procurement 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. 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:
- Strategic dashboards
- Spend and savings analysis
- Financial due diligence
- Supplier diversity
- 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 ( Lilly_Recruiting_Compliance@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.
To submit resume, visit https://www.lilly.com/careers and apply to Req ID R-26197.
Lilly is an EEO/Affirmative Action Employer and 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.
Our scientists and researchers are developing the breakthrough medicines of tomorrow. Join us and become a creative innovator and thinker who can improve the lives of millions.
We’d love to meet you to discuss career opportunities. Check our calendar now to see when we’ll be in your area.View All Events
By signing up for job alerts, you’ll be the first to learn about opportunities that could be a great fit for you via periodic email updates.Sign Up
Join Our Talent Community
Share a bit about yourself, such as the career area you are interested in. We will then reach out to you when the perfect position is available!Sign Up