Job Description

The Mapping Programmer plays a vital role in supporting the development of Data Management Workbench (DMW) and Electronic Data Capture (EDC) systems for both standard and pipeline projects. This role includes designing, modifying, and documenting clinical databases and their supporting systems to effectively support clinical trials. Additionally, the Mapping Programmer will assist with a variety of data flow mapping activities, ensuring that all processes adhere to company Standard Operating Procedures (SOPs) and ICH-GCP guidelines.

Primary Activities

Primary activities include, but are not limited to:
Assumes the responsibilities for all data mapping deliverables including SDTM structure set-up and transformation maps to support multiple clinical programs. Coordinates and participates in the following activities:

30% Design, build, maintain, test, and document data mapping specifications based on clinical database structures establish by Global Clinical Data Management and Clinical Research.  Mapping specifications must meet SDTM structure requirements utilizing DMW and E2E visibility tools to ensure quality and timeliness of data flow to the Clinical Data Repository.  Review the technical feasibility needs for transformations and technically implements them in support of the Business Rules required for SDTM compliance and the Clinical Data Repository in support of Analysis and Reporting performed by Scientific Programming of study team proposed reports. Work effectively among RaM Mapping team to communicate issues and ideas to improve the business.

30% Support the standard library development for data mapping to the clinical data repository including support of the business rules utilized for Analysis and Reporting and transformations to verify data transfer between and across the various databases among data collection, reporting, and the data repository. This includes the maintenance of the DMW in the PDAMNG library as well as the transformations for the E2E visibility tool.

15% Under proper change management, responsible for change requests and incidence correction into clinical database. Ongoing support in a dynamic and matrix organization.

25% Participate in extra activities including, but not limited to, study improvement task forces, automations, initiatives, testing of new systems, and ongoing training and mentoring.

Requirements

Education:
Master's degree in a relevant field such as Medicine, Computer Science, Big Data, or a related discipline.

Knowledge and Skills:

1. Excellent proficiency in both spoken and written English.
2. Extensive experience with programming languages such as Python, SAS, R, PL/SQL, and Java.
3. Quick learner with the ability to grasp new concepts and skills rapidly.
4. Exceptional communication skills, both verbal and written, with the capacity to engage effectively with both technical and business stakeholders.
5. Demonstrated strong organizational skills and a proven ability to solve problems.
6. Capable of collaborating effectively across different functions and as part of a team.
7. Adaptable and able to perform well under pressure in a dynamic work environment.

Required Skills:

Clinical Data Cleaning, Data Analysis, Database Development, Data Processing, Data Validation, Electronic Data Capture (EDC), PL/SQL (Programming Language)

Preferred Skills:

Database Structures, R Statistics, Standard Operating Procedure (SOP)

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully

Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company.  No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.

Employee Status:

Regular

Relocation:

No relocation

VISA Sponsorship:

No

Travel Requirements:

No Travel Required

Flexible Work Arrangements:

Not Applicable

Shift:

Not Indicated

Valid Driving License:

No

Hazardous Material(s):

NA

Job Posting End Date:

12/31/2026

*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.