Clinical Business Intelligence Internship - Spring 2027

Medpace; Cincinnati (OH); On-site; USD 20,088 - 33,480; Full time

Benefits offered by this job

Competitive PTO 20+ days

Discounts on local sports games

On-site fitness center

Tuition discounts (UC online)

Job summary

Medpace is seeking a Clinical BI Intern to join the Insights & Analytics team in Cincinnati. You will support BI projects, partner with IT on data warehousing, and build reports in Power BI, gaining hands-on experience with SQL and data visualization.

You will work under supervision, learn analytics concepts, and contribute to process improvements while developing presentation and communication skills for leadership audiences.

Qualifications

• Pursuing Bachelor’s or Master’s degree in Business, Life Science, Computer Science, or analytics with emphasis on data.

Responsibilities

• Support BI projects to drive business decisions.
• Partner with IT teams as data warehousing and analytics solution provider.
• Create reports and dashboards using Power BI.
• Perform data quality audits and ensure accuracy.
• Tasks tailored to experience and abilities.
• Work under supervision of data analysts and Sr. BI staff.
• Take feedback constructively and pursue career development.
• Learn analytics concepts in report generation, data modeling, SQL, and Power BI.
• Develop business understanding through process improvement and communication with leadership.

Skills

Independent work

Cross-functional teamwork

Willingness to learn

Customer focus

Mentoring others

Power BI

Excel

SQL

Communication

Presentation skills

Education

Bachelor’s/Master’s in Business, Life Science, CS or analytics

Tools

Power BI

Excel

Power Automate

Job description

The Insights & Analytics team works directly with management and leadership across the organization to conceptualize, design, and produce compelling visualizations to help answer key business questions and communicate insights across all facets of the organization. This is a highly impactful team which consistently has direct impacts on the bottom line of our business.

The Clinical BI Internship position within this team provides a unique opportunity for students who are currently pursuing a business, business technology, computer information systems, or analytics‑like degree to get hands‑on experience working across operational functions and a variety of enterprise BI tools, such as Power BI (Visualization tool) and Snowflake (Cloud Database).

As an intern on our team, you will contribute across the full development spectrum for new and existing reports – from finding data in our cloud‑based database, manipulating it through SQL, data modeling within Power BI, and creating the report visualizations in Power BI which our end users will interact with.

Responsibilities

• Support the business through key Business Intelligence projects
• Engage and partner with IT organization and its teams as a solution provider in the data warehousing, data analytics and business intelligence areas
• Create reports & dashboards using Power BI
• Perform data quality audits
• Specific tasks will be tailored to experience level and abilities
• Work under close supervision of other team members, data analysts, and Sr. BI analysts
• Accept candid feedback and identify opportunities for ongoing career development
• Learn core analytics concepts through hands‑on experience in report generation in Power BI, data visualization, user interface & user experience, developing data models, SQL, and Power Query
• Learn core business and operational concepts through hands‑on experience in process improvement, development of critical thinking, and presentation skills

Skills and Abilities

• Ability to work independently and as a member of a high performing cross‑functional team
• Willingness to learn, be mentored, and improve
• Desire to contribute and improve the design of new and existing reports and dashboards
• Exceptional customer focus (internal business customers)
• Desire to teach other team members and colleagues about technology in area of expertise
• Familiarity with various Microsoft’s Data Platform (e.g., Power BI, Excel, Power Automate)
• Proficient and adept at data wrangling (SQL) and manipulation
• Aptitude for quickly learning new technology and software with ability to apply its use
• Solid communication skills, with ability and confidence to present to an audience of varied leadership levels
• Ability to work office‑based in Cincinnati, OH (part‑time or full‑time) from January 2027-May 2027 (opportunity to stay on for multiple rotations is determined by performance and team need)

Qualifications

• Pursuing Bachelor’s or Master’s degree in Business, Life Science, Computer Science, or related degree with emphasis (minor or experience) in Analytics

Benefits

• Cincinnati Campus Overview
• 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