Junior Data Engineer

About the Role

Medpace is seeking a full-time, office-based Junior Data Engineer to join its Information Technology team. This role will support the development and maintenance of data pipelines and models for analytics, reporting, and AI agents.

Key Responsibilities

• Develop skills in data, AI, and development areas including data warehousing, business intelligence, databases, and AI agents (Snowflake, SQL Server, Azure, Python).
• Build and maintain data pipelines under guidance using Extract, Load, and Transform (ELT) tools (dbt, Python, Snowflake, Azure Data Factory).
• Assist with AI-enabled solutions, including AI agent and LLM integrations and their supporting data foundations.
• Help collect, analyze, and document user requirements.
• Participate in design and code reviews, learning to apply enterprise data standards and best practices.
• Contribute to solutions by following the lifecycle process: requirements gathering, design, development, testing, release, and maintenance.
• Monitor pipelines and assist with troubleshooting data quality and reliability issues.
• Participate in the software validation process through development, review, and/or execution of test plans/cases/scripts.
• Use AI coding assistants and agentic development tools as part of daily engineering work.
• Communicate with team members regarding projects, development, tools, and procedures.
• Provide end-user support, including setup, installation, and maintenance for released applications.

Qualifications

• Bachelor's degree in computer science, data science, or a related field.
• Internship or project experience in data or software engineering.
• Familiarity with dimensional data models and an awareness of star schema and snowflake schema designs.
• Foundational ETL/ELT and reporting knowledge.
• Working proficiency in SQL.
• Familiarity with version control (Git).
• Familiarity with REST APIs.
• Interest in building with AI — LLM APIs, agent frameworks, or AI-assisted development tools.

Preferred Qualifications

• Exposure to Snowflake cloud data warehouse and dbt transformations.
• Familiarity with Python.
• Knowledge of C# or Azure development is a bonus.

Skills

• Excellent analytical, written, and oral communication skills.