Associate Director, Pharmaceutical Data Engineer

Merck; West Point (PA); Presencial; USD 129.000 - 203.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical, dental, vision insurance

401(k) retirement plan

Paid holidays and vacation

Sick and compassionate days

Descripción de la vacante

Merck is hiring an Associate Director, Digital Operations in West Point, PA, to shift from traditional BI to a modern data foundation. You will design data pipelines, build custom WebApps, and deploy AI workflows, partnering with supply chain and manufacturing stakeholders across the drug substance and product lifecycle.

The role emphasizes Python/SQL expertise, Databricks, and modern development tools, with Agile practices and robust documentation. A competitive benefits package is provided.

Formación

• Strong expertise in Python and advanced SQL.
• Deep experience with Databricks Lakehouse, Delta Lake, and Unity Catalog for data governance.
• Proven ability to translate complex stakeholder needs into technical roadmaps.
• Familiarity with Agentic Modeling, LLMs, and AI agents in workflows.
• Experience in Agile/Scrum with Jira Cloud and Confluence.
• Proficiency with VS Code and AI-assisted coding tools.
• CI/CD and version control using GitHub.

Responsabilidades

• Design, build, and optimize scalable data pipelines and architectures.
• Develop WebApps for PoC solutions later industrialized on the React Platform.
• Create agentic AI workflows to automate decisions and insights.
• Collaborate with data architects to ensure scalable data models for analytics and transactions.
• Document processes, code, and data models; train end-users on new tech.

Conocimientos

Python

Advanced SQL

Databricks

Agentic AI

Streamlit

React

Data Engineering

Data Modeling

Data Pipelines

Data Science

Jira

Confluence

Educación

M.S. in Computer Science / Data Science / Engineering / related field

B.S. in Computer Science / Data Science / Engineering / MIS / related field

Herramientas

Databricks Lakehouse

Delta Lake

Unity Catalog

SAP / MES / LIMS data

VS Code

GitHub

Descripción del empleo

Job Description

Position Overview

Digital is the multiplier that will allow Development Sciences and Clinical Supply to deliver better experiments faster, efficient filing and launch, more robust supply chains and higher-confidence decisions across the portfolio. The Development Sciences and Clinical Supply Digital Technologies organization is tasked with the mission to pioneer and deploy innovative digital technologies that drive the acquisition, automation and utilization of data to enhance insights, efficiency, and quality of Development Sciences and Clinical Supply processes and methods.

The Development Sciences and Clinical Supply Digital Technologies organization within our Company Research Laboratories is accountable for driving the digital transformation, data architecture, and technology solutions that enable the execution and operations of the Development Sciences and Clinical Supply ecosystem.

The Associate Director, Digital Operations, is a highly technical role responsible for shifting the organization from traditional BI reporting to a robust, modern data foundation. This role will heavily focus on data engineering, building custom web applications, and deploying advanced AI/Agentic models to solve complex business problems. The data underpinning this work spans the end-to-end clinical and commercial supply chain - from drug substance manufacturing and process orders through drug product packaging, quality notifications, and global distribution.

The Associate Director, Digital Operations, will:

• Execute solutions to business needs by designing, building, and implementing modern data foundations and pipelines.

• Employ innovation and technology solutions (e.g., Databricks, Python, Agentic AI) to manage data and generate advanced insights more effectively.

• Develop custom web applications (WebApps) for Proof-of-Concept solutions that will later be industrialized in our React Platform.

• Work strategically and tactically to streamline processes and eliminate manual work through advanced automation and machine learning.

• Contribute to the advancement of the Data Strategy and Strategic Roadmap, supporting the organization's transition toward future-ready systems and intelligent data architectures.

Primary Activities

• Data Engineering & Foundations: Design, build, and optimize scalable data pipelines and architectures leveraging Databricks, Python, Dataverse, and advanced SQL - transforming raw SAP, MES, LIMS, and other Operational data from drug substance and drug product manufacturing and supply operations into highly accessible, analytics-ready data foundations.

• Requirements Translation: Act as a critical bridge between business and technology by deeply understanding stakeholder needs - working with supply chain planners, quality teams, and manufacturing stakeholders across drug substance and drug product functions - and accurately translating those needs into clear business requirements and precise technical specifications for development.

• Agentic Modeling & AI: Design, test, and implement agentic AI workflows and machine learning models to automate decision-making processes and generate proactive business insights.

• Web Application Development: Develop and deploy custom, user-friendly WebApps to support business operations, data entry, and interaction with underlying data models.

• Development & Code Management: Utilize modern development environments (VS Code) and AI coding assistants (Cline) alongside GitHub for robust version control of scripts, applications, and data models to ensure code quality.

• Systems Architecture: Work closely with data architects to ensure scalable, secure, and efficient data models that support both analytical and transactional workloads.

• Documentation & Enablement: Document processes, code, data models, and system architectures; provide training and technical support to end-users as new technologies are rolled out.

Required Skills, Education, and Qualifications

• Core Technical Stack: Strong expertise in Python and advanced SQL.

• Data Platforms & Custom Products: Deep, hands‑on experience with the Databricks Lakehouse architecture, Delta Lake, and Unity Catalog for robust data governance. Proven experience building custom data products and rapid‑prototype front ends (Streamlit/React). Strong familiarity with SAP (or similar ERP/manufacturing systems) as a primary source for complex supply chain and manufacturing data.

• Business Analysis: Proven track record of gathering complex requirements from non-technical stakeholders and translating them into actionable, technical roadmaps.

• Agentic AI & Automation: Familiarity with or strong interest in Agentic Modeling, Large Language Models (LLMs), and integrating AI agents into workflows (e.g., using Copilot Studio).

• Agile & Team Collaboration: Proven experience working in an Agile/Scrum environment, utilizing Jira Cloud for sprint planning, story estimation, and tracking, and Confluence for maintaining robust, multi‑system technical documentation.

• Modern DevTools : High comfort level working in VS Code and actively leveraging AI-assisted coding tools to accelerate development.

• CI/CD & Version Control : Strong experience using GitHub for version control, collaborative code reviews (PRs), and automated CI/CD pipelines.

• Analytical Skills: Strong analytical and problem-solving skills to tackle complex data challenges and translate them into technical solutions.

• Collaboration & Influence: Demonstrated ability to develop strong, trust‑based relationships to drive change and execute priorities with a group of technical and non‑technical stakeholders.

• Communication: Excellent written and verbal communication skills; demonstrated ability to communicate technical concepts clearly to different global professional levels.

• Independence: Independent decision‑making abilities with a proactive approach to leading projects and delivering results.

• Domain Knowledge (preferred): Familiarity with pharmaceutical drug substance or drug product supply chain operations, including concepts such as process orders, batch genealogy, MRP/MPS planning, tech transfer, quality management, or global distribution. Experience working with SAP (MM/PP/QM/SD modules) or related manufacturing execution systems (MES/LIMS) is a strong plus.

Education Experience

• M.S. in Computer Science, Data Science, Engineering, Supply Chain Management, Operations Research, or a closely-related quantitative field with at least 5 years of industrial, pharmaceutical, or relevant data engineering experience.

• B.S. in Computer Science, Data Science, Engineering, Supply Chain Management, Operations Research, Management Information Systems (MIS), or a closely-related quantitative field with at least 7 years of industrial, pharmaceutical, or relevant data engineering experience

Required Skills

Agent Based Modeling, Automation, CAPA Management, Clinical Supply Chain Management, Customer Experience Optimization, Databricks Unified Data Analytics Platform, Data Engineering, Data Modeling, Data Pipelines, Data Science, Driving Continuous Improvement, Manufacturing Execution Systems (MES), Proof of Concept (POC), Quantitative Analytics

US and Puerto Rico Residents Only

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities.

As an Equal Employment Opportunity Employer, we provide equal opportunities to all employees and applicants for employment and prohibit discrimination on the basis of race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or other applicable legally protected characteristics. As a federal contractor, we comply with all affirmative action requirements for protected veterans and individuals with disabilities. For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit:

EEOC Know Your Rights (https://www.eeoc.gov/sites/default/files/2022-10/22-088_EEOC_KnowYourRights_10_20.pdf)

EEOC GINA Supplement

We are proud to be a company that embraces the value of bringing together, talented, and committed people with diverse experiences, perspectives, skills and backgrounds. The fastest way to breakthrough innovation is when people with diverse ideas, broad experiences, backgrounds, and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively.

Learn more about your rights, including under California, Colorado and other US State Acts (https://www.msdprivacy.com/us/en/CCPA-notice/)

Primary location for this posting

USA - Pennsylvania - West Point

Where required by law, the compensation range for this role is provided below.

The salary range for the primary location of this role is:

$129,000.00 - $203,100.00

This range reflects the Company's reasonable expectation of the base salary applicable to this role at the time of posting. An employee’s position within the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs. The successful candidate will be eligible for annual bonus and long-term incentive, if applicable.

We offer a comprehensive package of benefits. Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.merck.com/us/en/compensation-and-benefits .

Additional location(s)

Please note the salary range above applies to the Primary Location of the position. Where a role has other listed locations, different compensation guidelines may apply. You may find the salary ranges for additional locations below. If the salary range is not listed for the location you are applying to, our Talent Acquisition team will provide further information to you relevant to your location.

Additional location(s) Compensation Information

San Francisco Residents Only: We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance

Los Angeles Residents Only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance

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.

Regular

Hybrid

11/13/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.

Requisition ID: R424311