remote
Senior Specialist, Data Engineering - Merck
Software Engineer
Lead the design, development, and deployment of scalable data pipelines and analytics solutions using Python, SQL, and AWS services to deliver actionable insights across Discovery, Preclinical, and Translational Medicine operations.
About the role
Key Responsibilities
- Own the full lifecycle of data products, from intake and prioritization to delivery and adoption, ensuring alignment with DPTM Ops portfolio objectives.
- Design, build, and maintain robust ETL pipelines and data warehouses on AWS, leveraging services such as Redshift, S3, and Glue.
- Collaborate with cross‑functional teams to consolidate fragmented data sources, standardize schemas, and implement data quality controls.
- Develop and automate workflow solutions that enable real‑time decision‑ready insights for capital asset management, regulatory compliance, and site operations.
- Document architecture, processes, and best practices, and mentor junior engineers on data engineering principles.
Requirements
- 5+ years of experience in data engineering, with a strong focus on Python, SQL, and AWS.
- Proven track record building scalable ETL pipelines and data warehouses in a regulated environment.
- Deep understanding of data modeling, data quality, and metadata management.
- Excellent communication skills and ability to translate business needs into technical solutions.
- Experience with Spark or similar big‑data processing frameworks is a plus.