Business Analyst Intern

Contract research clients send us samples from trial sites all over the world. Most of the team works in process development, analytical chemistry and quality control. Lab coats, safety glasses and closed-toe shoes in all lab areas.

Overview

This role is about accuracy first. A wrong number in a report is worse than a late one. Remote within the US. The team meets in Boise once a quarter, travel covered. Normal working hours, Monday to Friday.

What you'll do

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Prepare the weekly MIS report and send it to the team lead every Monday
• Answer ad hoc data requests from sales and support within a day or two
• Join a weekly call with the analytics lead to review your work
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Document metric definitions so everyone calculates churn and conversion the same way

Requirements

• Based in the US for the duration of the internship
• Available 40 hours a week for the full internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027
• Laptop with Excel or Google Sheets and a stable internet connection
• Basic SQL, enough to write SELECT queries with joins and filters
• Comfort with numbers and strong attention to detail

Duration: 4 months

Start date: Dec 2026

Stipend: $32.00-$35.00 an hour

Perks

• Learning and development stipend
• Paid sick time
• Final presentation to leadership
• Flexible hours
• Intern events and speaker sessions (virtual)
• Return offer opportunities

Duration: 4 months. Start: Dec 2026.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Lee Pharmaceuticals.