Data Engineer for clinical research

Medpace is a full-service clinical contract research organization providing phase I–IV clinical development services to the biotechnology, pharmaceutical, and medical device industries. It advances clinical research to accelerate the global development of safe and effective medical therapeutics.

• Utilize data warehousing, business intelligence, and database development skills using Snowflake, ANSI SQL, SQL Server, and T-SQL;
• Support software development using ETL and ELT tools, including dbt, Azure Data Factory, and SSIS;
• Design, develop, enhance, and support business intelligence systems primarily using Microsoft Power BI;
• Collect, analyze, and document user requirements;
• Participate in software validation through the development, review, and execution of test plans, cases, and scripts;
• Create software applications following the software development lifecycle, including requirements gathering, design, development, testing, release, and maintenance;
• Communicate with team members regarding projects, development, tools, and procedures;
• Provide end-user support, including application setup, installation, and maintenance.

• Bachelor's Degree in Computer Science, Data Science, or a related field;
• 3+ Years of experience in Data Engineering;
• Knowledge of dimensional data modeling and the advantages and limitations of Star Schema and Snowflake schema designs;
• Solid ETL development and reporting knowledge based on an intricate understanding of business processes and measures;
• Knowledge of REST API;
• Basic knowledge of SQL Server databases;
• Excellent analytical, written, and oral communication skills;
• Nice to have: Knowledge of Snowflake cloud data warehouse, Fivetran data integration, dbt transformations, Python, C#, and Azure development.

• Competitive compensation programs that recognize and reward performance;
• Comprehensive health, wellness, retirement, and PTO benefits;
• Office-based environment with on-site mentors;
• Defined career paths with clear advancement opportunities;
• Industry-renowned onboarding and training programs;
• Ongoing training and continuous learning opportunities;
• Company-sponsored social events;
• Occasional WFH may be available for eligible positions after training;
• Benefits may vary based on country.