Role Overview
As a Data Engineer, you will design, build and maintain scalable data pipelines and platforms and ensure pipeline reliability, performance and governance through automation, monitoring, logging and documentation. You will partner with data scientists, analysts and business stakeholders to translate requirements into production-grade, observable pipelines and datasets. You will operate within a matrix environment, participating in project planning, delivery and cross-team collaboration.
What will you do in this role
Design, develop, and maintain data pipelines to extract data from various sources
and populate a data lake and data warehouse.
Work closely with data scientists, analysts, and business teams to understand
data requirements and deliver solutions aligned with business goals.
Build and maintain platforms that support data ingestion, transformation, and orchestration across various data sources, both internal and external.
Use data orchestration, logging, and monitoring tools to build resilient pipelines.
Automate data flows and pipeline monitoring to ensure scalability, performance, and resilience of the platform.
Monitor, troubleshoot, and resolve issues related to the data integration platform, ensuring uptime and reliability.
Maintain thorough documentation for integration processes, configurations, and code to ensure easy onboarding for new team members and future scalability.
Develop pipelines to ingest data into cloud data warehouses.
Create and deliver standard reports in accordance with stakeholder needs.
Work within a matrix organizational structure, reporting to both the functional manager and the project manager.
Participate in project planning, execution, and delivery, ensuring alignment with both functional and project goals.
What should you have
Primary: (Python, SQL, PySpark, AWS, Apache Spark, Databricks, cloud object storage, ci/cd, ETL, data modelling)
Bachelors’ degree in Information Technology, Computer Science or any Technology stream.
7-11 years of experience in developing data pipelines & data infrastructure, ideally within a drug development or life sciences context.
Strong SQL skills and solid programming experience in Python (including PySpark)
Practical experience with AWS S3 and core AWS console concepts (IAM, regions, basic cloud architecture)
Hands-on experience with Apache Spark (concepts and usage) and Databricks (platform use, Delta Lake, Unity Catalog)
Experience with cloud object storage (e.g., Amazon S3) and cloud data warehouses or lakehouses (e.g., Redshift, Snowflake, Azure Synapse, Delta Lake)
Familiarity with data modeling, ETL/ELT patterns, and data transformation best practices
Experience implementing monitoring, logging, and data quality checks for operational pipelines
Familiarity with CI/CD concepts and pipelines for data deployments, experience with Git-based tooling (GitHub Actions, Jenkins, or Azure DevOps)
Proven ability to work collaboratively with data scientists, analysts, and business stakeholders
Good interpersonal and communication skills (verbal and written)
Product and customer-centric approach and innovative thinking
Secondary skills (nice to have) : (Experience with AI Assisted code development, GitHub Copilot, people management, and team lead experience)
Prior experience in a global or matrixed organization
Exposure to observability and data quality platforms (Monte Carlo, Great Expectations, Deequ)
Knowledge of orchestration and scheduling tools (Airflow, Prefect, Azure Data Factory)
Who we are
We are known as Merck & Co., Inc., Rahway, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, we have been bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.
What we look for
Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.
Additional location(s) Compensation Information
Required Skills
Amazon Web Services (AWS), Apache Spark, CI/CD, Cloud Software, Databricks Platform, Data ETL, Data Modeling, PySpark, Python (Programming Language), Structured Query Language (SQL)
Preferred Skills
GitHub, Microsoft Copilot, People Management
Current Employees apply HERE
Current Contingent Workers apply HERE
Secondary Language(s) Job Description
#MSDHYDIT
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
Domestic
VISA Sponsorship
No
Travel Requirements
No Travel Required
Flexible Work Arrangements
Hybrid
Shift
Not Indicated
Valid Driving License
No
Hazardous Material(s)
n/a
Job Posting End Date
- 11/20/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.
