Junior Data Engineer

Medpace is a clinical contract research organization providing clinical development services to the biotechnology, pharmaceutical, and medical device industries. The Junior Data Engineer will help build and support data pipelines and models for analytics, reporting, and AI agents while developing skills in data engineering, AI, databases, and enterprise development.

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 the data foundations that support them
• Help collect, analyze, and document user requirements
• Participate in design and code reviews and learn to apply enterprise data standards and best practices
• Contribute to solutions by following the lifecycle process, which includes requirements gathering, design, development, testing, release, and maintenance
• Monitor pipelines and help troubleshoot data quality and reliability issues
• Participate in the software validation process through development, review, and/or execution of test plan/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; and
• Provide end-user support including setup, installation, and maintenance for applications released

Preferred

• Exposure to Snowflake cloud data warehouse and dbt transformations is preferred
• Snowflake
• Cloud Data Warehousing
• dbt Transformations

Benefits

• Work alongside physicians, scientists, and industry-leading experts committed to advancing the global development of medical therapeutics through clinical research excellence
• Contribute to an interactive team environment that empowers decision making, creative thinking, and continuous learning through open communication and mutual trust
• Office based environment with on-site mentors
• Defined career paths with clear advancement opportunities
• Industry renowned onboarding and training programs designed to accelerate professional development
• Ongoing training and continuous learning opportunities throughout your career
• An environment that encourages employees to influence change, contribute ideas, and grow quickly
• Comprehensive health, wellness, retirement, and PTO benefits
• Office based culture with occasional WFH that provides flexibility for eligible positions after training
• Company-sponsored social events and intramural sports
• A modern corporate campus designed to support collaboration and productivity
• Multiple on-site dining options in the heart of Madison Square
• Free on-site parking
• Convenient access to on-site 24-7 fitness and wellness facilities

Company

• Full-service clinical research organization for biotech, pharma, and medical devices
• Cincinnati, Ohio, USA
• http://www.medpace.com/
• Founded in 1992
• 5001-10000 employees

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 the advantages and limitations of star schema and snowflake schema designs
• Foundational ETL/ELT and reporting knowledge, with an interest in learning the underlying business processes and measures
• Working proficiency in SQL
• Familiarity with Python is preferred
• Familiarity with version control (Git)
• Familiarity with REST APIs
• Interest in building with AI — LLM APIs, agent frameworks, or AI-assisted development tools
• Knowledge of C# or Azure development is a bonus
• Excellent analytical, written, and oral communication skills
• Exposure to Snowflake cloud data warehouse and dbt transformations is preferred

Required skills

• AI Agent Frameworks, Azure Data Factory, Data Warehousing, Dimensional Data Modeling, ETL/ELT, Git, LLM APIs, Python, REST APIs, SQL, Snowflake, dbt

Experience

• Entry level