Cloud Data Engineer - Pipelines, Analytics & GenAI

Merck & Co.; Fort Worth (TX); On-site; USD 83,000 - 152,000; Part time

Job summary

Merck & Co. is seeking a contractor data engineer to design, build, and maintain cloud-based data pipelines in a AWS-centric environment.

You will ingest, transform, and refresh data from multiple sources, creating analytics-ready datasets and reusable data models for dashboards and GenAI workflows. The role collaborates with data scientists, analysts, and platform teams to ensure well-documented, high-quality data with strong governance.

Qualifications

• Strong hands-on experience building data pipelines in cloud environments using AWS services (S3, Glue, Athena, Lambda, Step Functions, DynamoDB, RDS).
• Proficient in Python and SQL for ETL, data cleansing, and automation.
• Ability to design practical data models and metadata structures for analytics, dashboards, and application backends.

Responsibilities

• Design, build, and maintain cloud-based data pipelines for structured and semi-structured data sources.
• Develop ingestion, transformation, and refresh workflows using AWS services and Python-based automation.
• Create curated datasets, metadata tables, and reusable schemas to support analytics, dashboards, reporting, and app development.
• Build data models that link related business objects using reliable identifiers and reference tables.
• Develop SQL queries, views, and data access layers for recurring analytical needs.
• Collaborate with data scientists and analysts to prepare clean, trusted datasets for modeling and GenAI workflows.
• Implement data quality checks, logging, monitoring, and pipeline validation.
• Document data sources, transformations, assumptions, refresh logic, and known limitations.
• Support migration from manual workflows to automated, scalable cloud data pipelines.
• Work with security and platform teams to follow enterprise data handling standards.

Skills

AWS Cloud Data Engineering

Pyspark / Python / SQL ETL

Data Modeling & Metadata

Education

Bachelor's degree in Computer Science, Data Engineering, Information Systems, Software Engineering or related field

Master's degree or equivalent experience in data engineering or cloud architecture

Tools

AWS S3

AWS Glue

AWS Athena

AWS Lambda

AWS Step Functions

DynamoDB

RDS

Python

Job description

Merck & Co. is seeking a contractor data engineer to design, build, and maintain cloud-based data pipelines in a AWS-centric environment.

You will ingest, transform, and refresh data from multiple sources, creating analytics-ready datasets and reusable data models for dashboards and GenAI workflows. The role collaborates with data scientists, analysts, and platform teams to ensure well-documented, high-quality data with strong governance.