Medpace logo
Medpace
Posted 177 days agoVerified live 2d ago

Junior Data Engineer

Brief overview

Cincinnati, OHIn-person
UndergradOr in progress
87 H-1B approvalsDept. of Labor
15 green cardsCertified filings
Data warehousingBusiness intelligenceETL developmentELT toolsdbtAzure Data FactorySSISMicrosoft Power BIRequirements gatheringSoftware development lifecycleTest planning and executionUser communicationEnd-user supportDimensional data modelingStar Schema designSnowflake schema designREST API

About the company

Medpace, Inc., a clinical research organization, provides clinical development services for pharmaceutical and biotechnology

Visa sponsorship history

4 years sponsoring, last filed FY2026

Data powered by U.S. Department of Labor. This does not guarantee sponsorship for this specific role.
87H-1B approved
95%approval rate
46new H-1B hires
15PERM certified
$120,000median wage / yr
H-1B Petition ApprovalsVisas USCIS actually granted: the strongest sign the company sponsors.
202319
202431
202530
20267
LCA Certified ApplicationsAn early filing step, not a visa approval: it signals intent, not confirmed sponsorship.
20235
20241
20255
20262
Green Card (PERM) FilingsCertified green card filings: a long-term commitment to international hires.
20231
20246
20257
20261
Top sponsored roles
Statistical Analyst IIISoftware Engineer IIIBioinformatics Scientist IIIBiostatistician IISoftware Engineer I
Sponsored employees from
ChinaBangladesh

Job description

Summary

Medpace is a full-service clinical contract research organization (CRO) that provides Phase I-IV clinical development services. They are seeking a full-time Junior Data Engineer to join their Information Technology team, where the individual will work on various data-related projects that are crucial to the company's success.

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
  • Provide end-user support including setup, installation, and maintenance for applications

Skills

  • Bachelor's Degree in Computer Science, Data Science, or a related field
  • Internship experience in Data or Software 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
  • Knowledge of REST API
  • Excellent analytical, written and oral communication skills
  • Knowledge of Snowflake cloud data warehouse, Fivetran data integration and dbt transformations
  • Knowledge of Python
  • Knowledge of C#
  • Azure development

Qualifications

Must Haves

  • Bachelor's Degree in Computer Science, Data Science, or a related field
  • Internship experience in Data or Software 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
  • Knowledge of REST API
  • Excellent analytical, written and oral communication skills

Nice to Haves

  • Knowledge of Snowflake cloud data warehouse, Fivetran data integration and dbt transformations
  • Knowledge of Python
  • Knowledge of C#
  • Azure development

Benefits

  • Flexible work environment
  • Competitive PTO packages, starting at 20+ days
  • Competitive compensation and benefits package
  • Company-sponsored employee appreciation events
  • Employee health and wellness initiatives
  • Community involvement with local nonprofit organizations
  • Discounts on local sports games, fitness gyms and attractions
  • Modern, ecofriendly campus with an on-site fitness center
  • Structured career paths with opportunities for professional growth
  • Discounted tuition for UC online programs

More jobs like this