Senior Specialist, Data Architect

MSD; Województwo mazowieckie; Hybrid; PLN 180,000 - 300,000; Full time

Benefits offered by this job

Hybrid work arrangements

Job summary

Merck & Co., Inc. is seeking a Senior Specialist, Data Architect to lead and execute the build, integration, and maintenance of clinical databases and operational systems.

You will drive data integration, transformations, and enterprise-wide standards across EDC, RTSM, and eCOA/ePRO environments. The role requires expert SQL/Python/SAS/R skills, design of data models, and guidance on testing/validation in a regulated setting.

Qualifications

• Non-Degree with a minimum of 8 years of experience in clinical data programming, data engineering, or related data-management/clinical operations functions.
• OR Associate's Degree with a minimum of 7 years of experience in clinical data programming, data engineering, or related data-management/clinical operations functions.
• OR Bachelor’s Degree with a minimum of 5 years of experience in clinical data programming, data engineering, or related data-management/clinical operations functions.
• OR Advanced degree (Masters or Doctorate) with a minimum of 2 years of experience in clinical development and/or clinical data programming, data engineering, or related data-management/clinical operations functions.

Responsibilities

• Design and deploy clinical technology system solutions (e.g., EDC, RTSM, eCOA/ePRO) using programming/reporting frameworks and automation tools.
• Implement and validate complex data logic with fit-for-purpose scripting and validation frameworks.
• Develop advanced reporting solutions (dashboards, listings, visual analytics) with reusable components.
• Define and optimize integration architecture, data sources, and transformation workflows across systems.
• Monitor and troubleshoot data ingestion and consumption to improve reliability.
• Lead testing strategies and automate validation; ensure traceability from requirements to evidence.

Skills

SQL

Python

SAS

R

Data modeling

Education

Bachelor’s Degree with minimum 5 years

Associate’s Degree with minimum 7 years

Non-Degree with minimum 8 years

Advanced degree (Masters or Doctorate) with minimum 2 years

Tools

ETL Tools

Data Integration Platforms

Cloud Computing

Job description

The Senior Specialist, Data Architect, GDMS Data Integration and Automation leads and/or executes the build, integration, and maintenance of clinical databases/clinical operational systems. In addition, the Senior Specialist, Data Architect enables clinical study systems setup, transformations, and data-integration activities across systems while enforcing enterprise standards. The Senior Specialist, Data Architect manages escalations and dependencies, ensures SLAs (Service Level Agreements) and audit readiness, guides resourcing, mentors teams, maintains SOPs/WIs (Standard Operating Procedures/ Work Instruction), and provides subject matter expertise support on training.

Responsibilities

Programming and reporting

• Design and deploy clinical technology system solutions (e.g., for EDC [Electronic Data Capture], RTSM [Randomization & Trial Supply Management], eCOA/ePRO [electronic Clinical Outcome Assessment/ electronic Patient-Reported Outcome]) using programming / reporting frameworks and automation tools.
• Implement and validate complex data logic (edit checks, derivations, dynamic rules) with fit-for-purpose scripting and validation frameworks.
• Recommend and implement tools to streamline design, build, and validation processes.
• Act as a domain expert, providing technical guidance and reviews to peers and stakeholders.
• Apply data literacy to design transformation strategies for actionable insights.
• Develop advanced reporting solutions (dashboards, listings, visual analytics) with reusable components and role-based access.

Data Engineering

• Define and optimize integration architecture, including data sources and transformation workflows across systems.
• Monitor and troubleshoot data ingestion and consumption to improve reliability.
• Automate and strengthen data engineering processes for efficiency and risk reduction.
• Collaborate with stakeholders to translate business needs into data and system requirements.
• Develop robust data models, semantic layers, and curated datasets; monitor pipelines and enforce quality checks.

Process

• Validate system functionality and ensure compliance with SOPs (Standard Operating Procedures) and regulations.
• Set documentation standards and identify process gaps for improvement.
• Lead testing strategies for solutions; automate validation and ensure traceability from requirements to evidence.
• Lead or participate in process improvement initiatives and cross-functional projects.
• Mentor junior colleagues, share best practices, and support onboarding and training.
• Lead or support release processes for various business needs across environments (data management/clinical operations), including change control and risk assessment.
• Align stakeholders by translating requirements into technical specs; lead UAT (User Acceptance Testing), capture feedback, and improve reporting standards.
• Partner across teams to turn data and technical findings into clear, actionable stories.
• Act as a reliable partner to GDMS (Global Data Management & Standards) and other cross-functional teams, actively seeking input, aligning priorities, and closing feedback loops to drive high-quality, coordinated delivery.

Technical skills

• Expert-level proficiency in various languages including SQL, Python, SAS, and R for implementing clinical data collectors, integrations, transformations, reporting and visualizations
• Experienced in the interoperability of EDC platforms, data integration environments, clinical operations systems, and cloud computing platforms
• Advanced understanding of requirements, testing, validation, and change control in a regulated environment, and how these apply to data-management tools and clinical operations solutions.
• Deep understanding of clinical data lifecycles—from design and collection through cleaning, integration, and reporting—and how these activities support trial delivery and regulatory submissions.
• Proficiency and ability to contribute in System Development Lifecycle Management / system validation activities
• Strong knowledge of common clinical and regulatory data standards, clinical operational data models and the ability to design or review data structures, mappings, and controls that are consistent and reusable.
• Experience leveraging automation, scripting, or digital solutions to streamline data-management activities and reduce manual effort.
• Knowledgeable drug discovery process, FDA regulations, GxP/ ICH (International Council for Harmonization) guidelines Ability to connect business outcomes to technical deliverables

Soft skills

• Communicate and negotiate effectively (oral/written) with technical and business partners and external service providers; adapt style to audience and able to translate technical topics for non-technical stakeholders.
• Lead day-to-day activities; drive issue triage to closure; coordinate stakeholders.
• Mentor junior team members on tools, checks, documentation quality, and best practices.
• Prioritize independently; escalated with context, impact, and recommendation.
• Deliver clear updates on status, decisions, and blockers; maintain decision logs.

Enterprise Leadership Skills

• Decision Making | Identify and understand problems and opportunities by gathering, analyzing, and interpreting quantitative and qualitative information; solve complex problems and apply knowledge of business challenges; able to weigh multiple options and implications
• Motivation & Inspiration | Communicate effectively, promote teamwork and open discussion, effectively communicate and engage / motivate teammates; inspire others toward higher levels of performance aligned with organization's Purpose and Strategic Framework
• Coaching & Development | Build self-insight, demonstrate awareness of own strengths and development needs as well as impact of own behavior on others; modify behavior based on self-awareness to improve impact, serve as a resource for colleagues; coach and guides others

Qualifications & experience

• Non-Degree with a minimum of 8 years of experience in clinical data programming, data engineering, or related data-management/clinical operations functions.
• OR [Minimum preferred] Associate's Degree with a minimum of 7 years of experience in clinical data programming, data engineering, or related data-management/clinical operations functions.
• OR Bachelor’s Degree with a minimum of 5 years of experience in clinical data programming, data engineering, or related data-management/clinical operations functions.
• OR Advanced degree (Masters or Doctorate) with a minimum of 2 years of experience in clinical development and/or clinical data programming, data engineering, or related data-management/clinical operations functions.

Additional location(s) Compensation Information:

Employment Details

• Employee Status: Regular
• Relocation: Domestic
• VISA Sponsorship: No
• Travel Requirements: 10%
• Flexible Work Arrangements: Hybrid
• Shift: Not Indicated
• Valid Driving License: No
• Hazardous Material(s): n/a

Job Posting End Date: 11/16/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.

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.

Our company is a global health care leader with a diversified portfolio of prescription medicines, vaccines and animal health products. The difference between potential and achievement lies in the spark that fuels innovation and inventiveness; this is the space where we have codified our legacy for over a century. Our success is backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.