Business Analytics I (Usa)

Role Overview

We are seeking a talented Business Analytics; Supporting R&D Finance Team in financial planning, accounting, and analysis based in the US to join our esteemed team. As a Business Analytics, you will fully support the R&D Finance team by proficiently applying financial planning and accounting principle knowledge at a high level, consisting of: e.g. budgeting, forecasting, and strategic planning activities for clinical trials and pharmaceutical development pipeline.

Responsibility

• As a critical requirement in this role, must demonstrate an expert level of proficiency and programming with MS Excel. On a routine basis, must be able to create pivot tables, and utilize functions (i.e.: vlookup, concatenation, if/then) within the application.
• Perform KPI analysis and present metric results to the global clinical supplies management team
• Develop metrics via Excel models to analyze resource allocations and forecasts for use by managers within the department
• Must be able to utilize tools to obtain purchase prices for investigational drugs. Must understand SAP BOM structures and functionality for examining and valuing clinical material.
• Responsible for building and maintaining MS Excel models using pivot tables to project costs for distribution and warehousing, 3rd party packaging, 3rd party labelling, and drug costs to develop a budget forecast.
• Ability to follow Standard Operating Procedures (SOP's)
• Must be able to fully utilize SAP for financial analysis of R&D programs (investigational drug) and trial costs to accurately maintain and update rolling forecast and profit plan. Prepare a plan for submission of the annual Profit Plan.

Requirements

• Experience in clinical development and/or clinical supplies
• Experience with clinical trials
• Bachelor's degree with 3-5 years of relevant experience
• APICs certification or Supply Chain knowledge (JDE, SAP, etc.) is preferred
• Prior supply chain, logistics, or operations knowledge
• Familiarity with MS Access is preferred

Join our team and play a pivotal role in advancing clinical research, contributing to groundbreaking discoveries, and improving patients' lives. Apply now and be part of our mission to revolutionize healthcare through scientific excellence!

At Kelly OCG, we believe that the most effective teams are those that are diverse in thought, experience, and perspective. That's why we strive to create a welcoming and inclusive workplace where all employees can bring their unique talents and ideas to the table.