Mindlance
Business Analytics
Mindlance, Lansdale, Pennsylvania, United States, 19446
Business Analytics (8am-5pm EST)
Summary:
Fully support 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.
Selected Responsibilities: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.Responsible for building and maintaining MS Excel models using pivot tables to project costs for distribution and warehousing, 3rd party packaging, 3rd party labeling, and drug costs to develop budget forecast.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 plan for submission of annual Profit Plan.Develop metrics via Excel models to analyze resource allocations and forecasts for use by managers within the departmentPerform KPI analysis and present metric results to global clinical supplies management teamMust be able to utilize tools to obtain purchase prices for investigational drug. Must understand SAP BOM structures and functionality for examining and valuing clinical material.Ability to follow Standard Operating Procedures (SOP's)
Education and Work Experience Requirements:
Bachelor degree with 3-5 years of relevant experienceExperience in clinical development and/or clinical suppliesExperience with clinical trialsPrior supply chain, logistics, or operations knowledgeAPICs certification or Supply Chain knowledge (JDE, SAP, etc.) is preferredFamiliarity with MS Access is preferredEEO:
"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."
Summary:
Fully support 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.
Selected Responsibilities: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.Responsible for building and maintaining MS Excel models using pivot tables to project costs for distribution and warehousing, 3rd party packaging, 3rd party labeling, and drug costs to develop budget forecast.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 plan for submission of annual Profit Plan.Develop metrics via Excel models to analyze resource allocations and forecasts for use by managers within the departmentPerform KPI analysis and present metric results to global clinical supplies management teamMust be able to utilize tools to obtain purchase prices for investigational drug. Must understand SAP BOM structures and functionality for examining and valuing clinical material.Ability to follow Standard Operating Procedures (SOP's)
Education and Work Experience Requirements:
Bachelor degree with 3-5 years of relevant experienceExperience in clinical development and/or clinical suppliesExperience with clinical trialsPrior supply chain, logistics, or operations knowledgeAPICs certification or Supply Chain knowledge (JDE, SAP, etc.) is preferredFamiliarity with MS Access is preferredEEO:
"Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of - Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans."