Associate Specialist, Data Architect

Merck seeks an Associate Specialist, Data Architect to design, build, and maintain clinical databases and operational systems. The role involves programming, data engineering, system validation, and cross-functional collaboration to support clinical study infrastructure and reporting.

Responsibilities

• Design, build, test, and maintain clinical technology systems (EDC, RTSM, eCOA/ePRO) using programming and automation frameworks
• Implement and validate data logic including edit checks, derivations, and dynamic rules
• Configure, test, and validate data sources for integrations; troubleshoot data ingestion and consumption issues
• Develop data models, queries, and optimize extracts; create and maintain reporting solutions and dashboards
• Perform unit and integration testing, document test cases, and partner with stakeholders on requirements and user acceptance testing

Requirements

• Proficiency in at least one programming language (Python, SQL, SAS, R)
• Experience with data collection, integration, transformation, reporting, and visualization
• Knowledge of scripting and automation tools for data ingestion and cleaning
• Familiarity with Good Clinical Practice (GCP) and clinical data integrity standards
• Understanding of System Development Lifecycle and validation practices
• 1–2 years of clinical data programming, data engineering, or clinical operations experience