Business Intelligence Engineer Internship - Spring & Summer 2027
Medpace
A complete application in a minute — tailored resume and cover letter, ready to send.
Benefits offered by this job
Job summary
Medpace is seeking a BI Intern to contribute to data modernization across the analytics and business intelligence team in Cincinnati. You will design and build data pipelines, create reusable data models, and collaborate with data engineering, analytics, and operations to deliver trusted datasets for reporting and decision-making.
Ideal candidates are rising juniors or seniors pursuing a related degree, proficient in Python and SQL, with interest in cloud platforms such as Azure and Snowflake,
Qualifications
- Rising Junior or Senior pursuing a Bachelor's Degree in CS, Data Engineering, or related field.
- Proficiency in Python and SQL with solid data fundamentals.
- Understanding of relational databases, data warehousing, ETL/ELT patterns, and data quality.
- Familiarity with Git, automated testing, CI/CD, and SDLC, with willingness to learn.
- Strong analytical, problem-solving, and clear communication skills.
- Preferred: cloud data platforms (Azure/Snowflake) and orchestration tools.
Responsibilities
- Design, build, test, and maintain scalable data pipelines in Python/SQL.
- Ingest data from enterprise apps, databases, files, APIs, and cloud sources.
- Develop reusable data products and dimensional/analytic models for reporting and AI use cases.
- Move legacy assets toward a governed single source of truth with clear rules.
- Implement data quality checks, lineage, logging, and monitoring.
- Document mappings, define data contracts, and meet acceptance criteria.
- Optimize pipelines for performance, cost, and secure access.
- Write clean, tested code; participate in peer reviews and CI/CD practices.
- Investigate failures and perform root-cause analysis with durable fixes.
- Leverage modern engineering tools, including AI-assisted development, as appropriate.
Skills
Education
Tools
Job description
The Medpace Analytics and Business Intelligence team is growing rapidly and is focused on creating a trusted, data-driven foundation across the enterprise. We build scalable solutions leveraging data pipelines and reusable data products that ingest, transform, standardize, and serve data from operational systems for analytics, applications, and decision-making. As a Business Intelligence Intern, you will hold a highly visible role focused on modernizing data flows, improving data quality and reliability, and helping migrate fragmented data assets toward a governed single source of truth in partnership with leaders and technical teams across Medpace.
What’s in this for you?
- Work in a collaborative, fast paced, entrepreneurial, and innovative workplace.
- Build production-grade data pipelines and trusted data products used by analysts, applications, leaders, and teams across the enterprise.
- Develop your craft in Python and SQL by designing, testing, deploying, and monitoring maintainable workflows—not just one-off scripts or notebooks.
- Gain business and data domain context by partnering across Medpace to consolidate fragmented sources into scalable, governed, and reusable data solutions.
What’s involved?
We are looking for an intern to add depth to our growing team by designing and building data pipelines, shared data models, and production-ready data products in Python and SQL. This role partners closely with data engineering, analytics, operations, finance, and other technical teams to understand source systems, define trusted business logic, and deliver reliable datasets that can serve as the enterprise system of record for reporting and downstream applications.
An ideal candidate brings strong programming and data fundamentals and is excited to build reliable, maintainable data systems at scale. You enjoy tracing data from source to consumption, resolving ambiguity in definitions, designing reusable models, and implementing controls that make data accurate, discoverable, secure, and observable. You are eager to learn enterprise practices such as version control, automated testing, orchestration, deployment, lineage, monitoring, and operational ownership. We are looking for team members who are intensely curious, thrive on complex problems, and prefer durable platform solutions over short-term fixes.
What you bring to the table – and why we need you!
- Design, build, test, and maintain scalable batch and event-driven data pipelines using Python, SQL, and modern orchestration patterns.
- Ingest and integrate data from enterprise applications, databases, files, APIs, and cloud platforms into standardized data layers.
- Develop reusable, well-documented data products and dimensional or analytical models that support reporting, analytics, applications, and AI use cases.
- Help migrate legacy and duplicative data assets toward a governed single source of truth with consistent definitions, ownership, and business rules.
- Implement automated data quality checks, reconciliation controls, schema validation, lineage, logging, alerting, and performance monitoring.
- Partner with business and technical stakeholders to document source-to-target mappings, translate requirements into data contracts, and define acceptance criteria.
- Optimize pipeline performance, reliability, and cost while supporting secure access, privacy, and appropriate data governance.
- Write clean, tested, documented code; participate in peer reviews; and contribute to Git-based development, CI/CD, and release practices.
- Investigate pipeline failures and data discrepancies, perform root-cause analysis, and implement durable corrective actions.
- Use modern engineering tools, including AI-assisted development tools where appropriate, to accelerate delivery while maintaining quality, security, and human review.
- Rising Junior or Senior pursuing a Bachelor's Degree in Computer Science, Data Engineering, Software Engineering, Information Systems, Business Analytics, or a related degree.
- Proficiency in Python and SQL, with a solid foundation in data structures, debugging, modular design, and maintainable code.
- Understanding of relational databases, data warehousing, data modeling, ETL/ELT patterns, and data quality concepts.
- Familiarity with Git, automated testing, CI/CD, and software development lifecycle practices, or a strong willingness to learn.
- Strong analytical and problem-solving skills, attention to detail, and clear written and verbal communication.
- Preferred: experience with cloud data platforms and services, especially Microsoft Azure and/or Snowflake, including object storage, managed databases, compute, and role-based access.
- Preferred: exposure to data engineering and orchestration tools such as Azure Data Factory, Fabric, Databricks, dbt, Airflow, or comparable technologies.
- Preferred: familiarity with dimensional modeling, metadata, data catalogs, lineage, data contracts, observability, or master/reference data management.
- Preferred: experience with APIs, containerization, Infrastructure as Code such as Bicep, ARM, or Terraform, and deploying data workloads in cloud environments.
- Ability to work fully office-based in Cincinnati, OH during spring 2027, summer 2027, or both rotations.
Medpace is a full-service clinical contract research organization (CRO) providing phase l-lV clinical development services to the biotechnology, pharmaceutical, and medical device industries. Our mission is to accelerate the global development of safe and effective medical therapeutics through the advancement of clinical research. We leverage in-country regulatory and therapeutic expertise across all major therapeutic areas including oncology, cardiology, metabolic, endocrinology, central nervous system, and anti-viral and anti-infective. Headquartered in Cincinnati, Ohio, we employ more than 6,500 people across 40+ countries.
When you join Medpace, you become part of an innovative team that brings cutting-edge therapies to market while building a meaningful and rewarding career focused on scientific excellence and improving patient outcomes around the world through continuous learning and cross-functional collaboration.
- 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.
- Leadership throughout Medpace is both accessible and approachable
- 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
- Competitive compensation programs that recognize and reward performance
- 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
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
