✦ Luna Orbit — AI & Machine Learning

Specialist, Data Engineer (Hybrid - Rahway, NJ)

at Merck

📍 USA - New Jersey - Rahway Hybrid 💰 $79K – $124K USD / year Posted April 03, 2026
Apply Now → ← Browse All Jobs

Position Details

Salary $79K – $124K USD / year
Type Full-Time
Experience mid
Exp. Years 3+ years
Education High School Diploma or GED required
Category AI & Machine Learning

About this role

Specialist, Data Engineer builds and maintains AI-enabled data pipelines and ML services, focusing on production-grade LLMs, RAG workflows, and API-driven automation in a hybrid setup.

Key Responsibilities

  • Design and refine prompts and agent workflows for LLMs
  • Develop data pipelines and AWS Redshift integration
  • Build and deploy inference stacks and managed services
  • Implement API-driven automation and integrations
  • Establish model evaluation practices

Technical Overview

Role centers on prompts, LLM integration, data pipelines with AWS Redshift, and evaluation frameworks; emphasizes production readiness and integration with BI tools like Power BI.

Ideal Candidate

The ideal candidate is a data engineer with 3+ years applying prompt engineering and LLMs in production, strong Python and data pipeline experience, and familiarity with AWS Redshift and Power BI/Power Automate for analytics and automation.

Must-Have Skills

Minimum of 3 years relevant experienceExperience with Prompt EngineeringUnderstanding of RAGAgentic AI and MCP conceptsExperience with API driven automation and integrationExperience with Python programming

Nice-to-Have Skills

Experience with Power BI and Power Automate for data visualization and workflow automationExperience with production-grade LLMsExperience with end-to-end AI deployments

Tools & Platforms

AWS RedshiftPower BIPower AutomatePythonAPIsLLMs

Required Skills

Prompt EngineeringLarge Language Models (LLMs)AIData PipelinesData Warehouse DevelopmentPythonAPIsAWS RedshiftPower BIPower AutomateRAGAgentic AIMCP concepts

Hard Skills

Prompt EngineeringLarge Language Models (LLMs)AI/MLData PipelinesAPIsPythonRAGAgentic AIMCP conceptsAPI-driven automationAWS RedshiftData warehousingPower BIPower Automate

Soft Skills

AdaptabilityAnalytical ThinkingDetail-OrientedCollaborationCommunication

Industry & Role

Industry Healthcare & Medical
Job Function Develop and maintain AI-enabled data pipelines and ML systems at Merck.

Clearance & Visa

Visa Sponsorship No

Keywords for Your Resume

data engineerprompt engineeringlarge language modelsllmragagentic aimcp conceptsapi automationpythonaws redshiftdata pipelinesdata warehousepower bipower automatehybridrahway njsqletlproduction

Deal Breakers

No visa sponsorship, Inability to work in a hybrid model in Rahway, NJ, Lack of Python/data engineering experience, No experience with LLMs or prompt engineering

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile