Job Summary:
Medpace is a full-service clinical contract research organization (CRO) that provides Phase I-IV clinical development services to the biotechnology, pharmaceutical, and medical device industries. They are seeking a Senior Data Engineer to join their Information Technology team, where the role involves developing business intelligence systems, supporting data warehousing, and ensuring effective data management practices.
Responsibilities:
• Utilize skills in development areas including data warehousing, business intelligence, and databases (Snowflake, ANSI SQL, SQL Server, T-SQL);
• Support programming/software development using Extract, Transform, and Load (ETL) and Extract, Load and Transform (ELT) tools, (dbt, Azure Data Factory, SSIS);
• Design, develop, enhance and support business intelligence systems primarily using Microsoft Power BI;
• Collect, analyze and document user requirements;
• Participate in software validation process through development, review, and/or execution of test plan/cases/scripts;
• Create software applications by following software development lifecycle process, which includes requirements gathering, design, development, testing, release, and maintenance;
• Communicate with team members regarding projects, development, tools, and procedures; and
• Provide end-user support including setup, installation, and maintenance for applications released.
Qualifications:
Required:
• Bachelor's Degree in Computer Science, Data Science, or a related field
• 5+ years of experience in Data Engineering
• Knowledge of developing dimensional data models and awareness of the advantages and limitations of Star Schema and Snowflake schema designs
• Solid ETL development, reporting knowledge based off intricate understanding of business process and measures
• Basic knowledge of SQL Server databases is required
• Excellent analytical, written and oral communication skills
Preferred:
• Knowledge of Snowflake cloud data warehouse, Fivetran data integration and dbt transformations
• Knowledge of Python
• Knowledge of REST API
• Knowledge of C#, Azure development is a bonus
Company:
Medpace, Inc., a clinical research organization, provides clinical development services for pharmaceutical and biotechnology Founded in 1992, the company is headquartered in Cincinnati, USA, with a team of 5001-10000 employees. The company is currently Late Stage.