Logo for Fortrea

Programmer Analyst

Roles & Responsibilities

  • Experience with Clinical Data Management Systems (CDMS) and Electronic Data Capture (EDC) in clinical trials, including generating SDTM deliverables.
  • Proficiency in data mapping and transformation using Data Management Workbench (DMW) and Clinical Data Warehouse (CDW), including SDTM staging/model transformations and data loading.
  • Knowledge of regulatory requirements and quality practices (SOPs, GCP, GDP, GPP) with hands-on experience in UAT, validation checks, and documenting pass/fail scenarios.
  • Strong collaboration and communication skills to work with trial teams and stakeholders, and ability to maintain system documentation and support change management; experience with Oracle Clinical is a plus.

Requirements:

  • Design, set up, and activate study databases in CDMS for clinical trials based on protocol needs, including applying validation checks and conducting UAT to ensure the database meets specifications.
  • Map metadata and clinical data from source systems to DMW/CDW and generate SDTM deliverables; perform SDTM model updates and data loads; review eCRFs and DCM annotations.
  • Ensure regulatory compliance (SOPs, GCP, GDP, GPP), maintain system documentation, support testing, and manage post-production changes; document pass/fail scenarios.
  • Collaborate with trial teams and Lead Clinical Data Programmer/Process Automation Specialist; share best practices, contribute to process improvements, and maintain TMF documentation.

Job description

Key responsibilities:

  • Design and set-up of study database for data collection in clinical trials based on protocol needs
  • Set up of models and performing transformation updates in DMW
  • Mapping of metadata and clinical data from source system(s) to DMW (Data Management Workbench) / CDW (Clinical Data Warehouse) and generate SDTM (Study Data Tabulation Model)

       deliverables.

  • Active participation in sharing better practices on use of standards in alignment with Lead Clinical Data Programmer and Process & Automation Specialist.
  • Maintain system related documentation.
  • Facilitate implementation of business processes introduced by the systems supported by DaMaSys (Data Management Systems & Standards).
  • Ensure testing is performed and database meets specification requirements before deployed into production and document pass and fail scenarios in a timely manner.
  • Design, Programming and validate programs to check data accuracy and aid report generation.

General responsibilities

  • Be compliant on SOPs, GCP, GDP and GPP (good programming practice).
  • Collaborate with trial teams to agree/negotiate on timelines.
  • Promote the exchange of know-how within the organization via participations in share better practice sessions and trial related meetings.
  • Contribute to the generation of a co-operative and collegial atmosphere within the department.
  • Report regular status updates to Manager.

Design and set-up of study database for data collection in clinical trials based on protocol needs

  • Create trial in CDMS (Clinical Data Management System), set up trial database and activate the database upon approval from relevant stakeholders.
  • Apply or copy global validation/derivation checks, build trial specific checks and perform testing
  • Serve as programming contact to handle database issues within expertise area.
  • Review and provide inputs to EDC (Electronic Data Capture) requirements in relation but not limited to protocol, flow chart, SDTM domains etc.
  • Review and provide inputs to Project plan, Blinding Plan, and any other documents based on trial and process requirement.
  • Perform blinding of data points during database set-up as required by Blinding Plan/Blinding Implementation document.
  • Create and maintain relevant documents as per TMF's (Trial Master File) ToC (Table of Contents).

Set up of models and performing transformation updates in DMW

  • Create trial in DMW, apply template and set up DMW Inform model
  • Create DMW mapping specification and external data specification
  • Update filewatcher configuration for external data models
  • Perform Transformation updates and installation of data models

Mapping of metadata and clinical data from source system(s) to DMW (Data Management Workbench) / CDW (Clinical Data Warehouse) and generate SDTM (Study Data Tabulation Model) deliverables

  • Perform SDTM staging model updates in DMW
  • Perform SDTM model transformation (DMW SDTM Raw)
  • Perform data load for all models
  • Review of (e)CRFs and DCM annotation.
  • Transformation of Metadata and Clinical data within Clinical Data Management System (CDMS) to Statistical Computing Environment (SCE) and enable generation of SDTM datasets.

Active participation in sharing better practices on use of standards in alignment with Lead Clinical Da-ta Programmer and Process & Automation Specialist

  • Share trial learnings along with impact analysis with line manager and team.
  • Ensure the learnings are implemented to forthcoming trials / projects.
  • Ensure that the newest knowledge is collected and shared with relevant stakeholders including super users in Clinical & Data Science on database set-up and SDTM activities
  • Support communication around methods and standards in Clinical & Data Science
  • Give input to internal workshops and seminars.
  • Advise and assist co-workers when needed.

Maintain system related documentation

  • Update documentation related to the system as appropriate.
  • Give input to optimisation of documentation related to the system.

Facilitate implementation of business processes introduced by the systems supported by DaMaSys (Data Management Systems & Standards)

  • Give input to optimisation of processes related to / connected with the use of the systems.
  • Assist in relevant change management activities.
  • Responsible for continuously improving way of working in close collaboration with the other departments in Data Management Systems & Standards and their stakeholders.
  • Facilitate update to relevant processes and documents.
  • Be enablers of timely and fit-for-purpose products.

Ensure testing is performed and database meets specification requirements before deployed into production and document pass and fail scenarios in a timely manner

  • Perform and document UAT (User Acceptance testing) for checking the quality of database.
  • Perform UAT (User Acceptance Testing) of DMW SDTM Raw.
  • Maintain/update testing related documentation.

Design, Programming and validate programs to check data accuracy and aid report generation

  • Perform QC by using relevant UAT reports.
  • Resolve QC issues (as appropriate) in liaison with Lead CDP

Other areas of responsibility:

  • Perform post production changes.
  • Provide inputs to specification documents such as aCRF.
  • Activate the database in OC (Oracle Clinical)
  • Map data from OC to CDW ensuring consistency and correctness according to the SDTM data model / domains.
  • Create aCRF, define.xml. and SDRG (Study Data Reviewer’s Guide).
  • Finalize SDTM package and perform complete run in alignment with Biostats.

Learn more about our EEO & Accommodations request here.

Software Engineer Related jobs

Other jobs at Fortrea

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.