Business Analyst for Laboratory Data Calculations (m/w/d) – Freelance – on hold

  • Position zu besetzen ab 1. Oktober 2020
  • Permanent-ID OCR-FL-1080
  • Branche Pharma
  • Beschäftigungsform Freelance/ Contracting
  • Standort Deutschland / 5x
  • Kategorien Beschäftigungsform, Branche, Freelance/Contracting, Pharma

We need a senior Business Analyst to work on:

  • Evaluate the excel spreadsheets and calculations and write the requirements in close collaboration with the business
  • Understand the business process and the calculations used in the macros working in close collaboration with the development team
  • Evaluate (macro) calculations in the spreadsheets and define the requirements for the integration into CBA in close collaboration with the development team (R and RShiny, Phyton)
  • Define priority and bundles
  • Coordinate and create plans for integrating the Excel sheets into CBA in close collaboration with the program manager
  • Perform risk assessments and SDLC documentation (Requirement Specification, Test Scripts, etc.)
  • Conduct Developer and User Test
  • Hand over and training
  • Conversion of code would be performed within the technology abilities offered by the suite of RShiny and R.
  • Communication and project governance will be performed using Excel sheets, email, and SharePoint
  • Onsite coordination and communication on progress and activities

To Do:

Analyse 60+ Excel calculations in scope of integration into CBA:

  • 2 Spreadsheets with macros that are used at different R&D Laboratories
  • 1+ Spreadsheets with macros that are used in Bergen/Norway
  • 27 GLP Spreadsheets used in Bioanalytical Lab
  • 15 GLP Spreadsheets used at Animal Facilities


  • Very good problem-solving skills working closely with the business areas in an interdisciplinary team
  • Experienced with Computerized Systems Validation;
  • Familiar with the pharmaceutical industry, laboratory area;
  • Familiar with GLP, GMP writing the documentation and coordinate reviews by IT, Business and Quality;
  • SDLC processes (System Development Lifecycle);
  • Planning and coordination of the project using agile project management methodologies
  • Experience with document management platforms like documentum
  • Good communicative properties (ENG);
  • Proactive and used to work remotely in interdisciplinary teams
  • Good knowledge of IT configurations of Computerized Laboratory Systems and Spreadsheets.

PDF herunterladen