Scientific Application Specialist

December 19, 2017
Tampa, Florida
Job Type
Education Required
BS or MS in Computer Science, Engineering, Statistics, Applied Science or related disciplines.


Requisition No.: 22298-1

Status: Full Time

Project Duration: 6 months

Position Description:

  • The process of data modeling with GMS IT is used to define and analyze data requirements needed to support the complex manufacturing processes within the scope of corresponding information and automation systems used within BMS.
  • Working with a design team, analyze and implement the data transformation requirements needed to support manufacturing and process intelligence tools used within Global Manufacturing & Supply organization, including Biovia Discoverant and other process intelligence systems.
  • Working closely with source database DBA’s (ERP, LIMS, MES, Historians, etc.), identify and efficiently aggregate data into a virtual database, with manufacturing related context and meta-data, into a suitable format for statisticians, engineers, and scientists to analyze.
  • Design and develop virtual databases through the transformation of data from existing database structures, creating links between the data sources to enable the BMS analytics software tools to extract data for analysis.
  • Configure SQL views and other standards for data access, along with mapping database elements to Discoverant analysis and reporting software.
  • Working with dedicated validation resources, support software qualification and validation activities in a regulated environment.
  • Identify opportunities for data model and database performance tuning, to ensure efficient and near real-time performance of process analytics. Work with DBA’s and other team members to implement.
  • Working with other members of a project team, develop coordinated design for browser-based data entry. This will include coordinating data entry and data extraction designs to ensure data is available and accessed in appropriate structures, configuring database structure to consolidate process data from offline sources, and configuring processes to load and update process data from offline sources.

Skills Required

• Scientific knowledge or experience (analytical chemistry, process development, etc) required.

• Requires strong written and verbal communication skills, ability to communicate complex ideas to clients at their own level of understanding and ability to analyze, isolate, duplicate and resolve problems.

Skills Preferred

• Functional business process knowledge (for functional area of application set) strongly preferred.
• Knowledge of qualification and validation requirements in a regulated environment is a plus.

Experience Required

• 4+ years of pertinent experience including at least 2 years of experience with Oracle and/or SQL Server performing database design, data modeling, or advanced database development.
• Experience with developing complex SQL Queries.
• Experience or strong technical knowledge regarding the development and use of data marts or warehouses.

Experience Preferred

• Scientific knowledge or experience (analytical chemistry, process development etc.) strongly preferred.
• Previous experience with Biovia – Discoverant is preferred
• Experience with an analytical or statistical package is desired.
Drop files here browse files ...

Related Jobs