About the role#
The Medpace Analytics and Business Intelligence team builds scalable solutions to create a trusted data foundation. As a Business Intelligence Intern, you will focus on modernizing data flows, improving data reliability, and migrating fragmented assets toward a governed single source of truth. You will work alongside data engineering, analytics, operations, and finance teams to deliver production-ready data products.
What you'll do#
- Design, build, test, and maintain scalable batch and event-driven data pipelines using Python and SQL.
- Ingest and integrate data from enterprise applications, databases, files, APIs, and cloud platforms.
- Develop reusable data products and analytical models for reporting and AI use cases.
- Migrate legacy data assets toward a governed source of truth with consistent business rules.
- Implement automated data quality checks, reconciliation controls, schema validation, and performance monitoring.
- Partner with stakeholders to document source-to-target mappings and define data contracts.
- Write clean, documented code and participate in peer reviews using Git, CI/CD, and release practices.
- Investigate pipeline failures and data discrepancies to perform root-cause analysis.
- Optimize pipeline performance and cost while supporting secure data governance.
What you'll need#
- Current status as a rising junior or senior pursuing a bachelor's degree in Computer Science, Computer Engineering, Business Administration, Data Science, or a related field.
- Proficiency in Python and SQL.
- A foundation in data structures, debugging, modular design, and maintainable code.
- Understanding of relational databases, data warehousing, data modeling, and ETL/ELT patterns.
- Strong analytical, problem-solving, and communication skills.
- Familiarity with Git, automated testing, and software development lifecycle practices, or a willingness to learn.
- Preferred: Experience with cloud platforms like Microsoft Azure or Snowflake.
- Preferred: Exposure to orchestration tools such as Azure Data Factory, Databricks, dbt, or Airflow.
- Preferred: Familiarity with dimensional modeling, data catalogs, lineage, and data contracts.
- Preferred: Experience with APIs, containerization, or Infrastructure as Code.
Location & details#
- This is a full-time, paid internship located on-site in Cincinnati, Ohio.
- Available terms include Spring 2027 and Summer 2027.
- Candidates must be able to work fully office-based during their selected rotation.
About Medpace
Medpace is a clinical contract research organization founded in 1992. It provides Phase I-IV clinical development services for the pharmaceutical, biotechnology, and medical device industries. The company operates in 46 countries and maintains its headquarters in Cincinnati, Ohio. It employs approximately 6,650 people.
How to get in at Medpace
Applying early to Medpace is a significant advantage because recruiters review applications as they arrive. Intern Insider sends an instant alert the moment a role matching your target is published anywhere, so you apply among the first and get seen before the pile grows. You can improve your response rate by reaching out to the people managing these roles directly. Intern Insider surfaces the recruiters behind the company's roles so you can reach out to ask about the position or a referral, which often helps you stand out more than a standard application.
