BI Engineer Intern: Build Scalable Data Pipelines

Medpace; Cincinnati (OH); On-site; USD 30,000 - 39,000; Full time

Benefits offered by this job

Health benefits

On-site parking

On-site dining options

Professional development opportunities

Job summary

Medpace in Cincinnati, OH is seeking a Business Intelligence Intern to help modernize data flows, improve data quality, and migrate fragmented assets toward a governed single source of truth in partnership with leaders and technical teams.

You will design and build scalable data pipelines in Python and SQL, ingest data from enterprise systems, develop reusable data products, and participate in Git-based development, CI/CD, testing, and deployment.

Qualifications

• Pursuing a Bachelor's or Master'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 RBAC.
• 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 office-based in Cincinnati, OH.

Responsibilities

• 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.

Skills

Python

SQL

Git

CI/CD

Azure

Snowflake

Databricks

dbt

Airflow

Education

Bachelor's or Master's in Computer Science / Data Engineering / Software Engineering / Information Systems / Business Analytics

Tools

Azure Data Factory

Fabric

Databricks

dbt

Airflow

Terraform

Bicep / ARM

Job description

Medpace in Cincinnati, OH is seeking a Business Intelligence Intern to help modernize data flows, improve data quality, and migrate fragmented assets toward a governed single source of truth in partnership with leaders and technical teams.

You will design and build scalable data pipelines in Python and SQL, ingest data from enterprise systems, develop reusable data products, and participate in Git-based development, CI/CD, testing, and deployment.