Product Analytics Intern - Summer 2027

Who we are:

Consultants are staffed across industries early on, then specialize after a few years. Engagement teams range from three people to more than 200 on multi-year transformation programs.

The internship:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote within the US. The team meets in Port St. Lucie once a quarter, travel covered. Day-to-day communication is in Slack and Google Meet.

Day to day:

• Create charts and short slide decks for the monthly review call
• Prepare the weekly MIS report and send it to the team lead every Monday
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Document metric definitions so everyone calculates churn and conversion the same way
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Analyse funnel drop-offs and summarise findings in a one-page note

What we're looking for:

• Available 40 hours a week for the full internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Must be able to follow up on data requests without constant reminders
• Available 20 to 40 hours a week, Monday to Friday
• Basic SQL, enough to write SELECT queries with joins and filters
• Clear written English for reports and status updates
• A sample dashboard or analysis project you can share

What you'll learn:

• How business metrics like CAC, churn and retention are actually calculated
• Presenting numbers in a way non-technical people can act on
• Top interns are considered for a junior analyst opening

Duration: 12 weeks

Start date: Summer 2027

Stipend: $31.00 to $37.50/hr

What we offer:

• Paid company holidays
• Learning and development stipend
• Return offer opportunities
• Home office setup stipend

No recruitment agencies, please.

Duration: 12 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Port St. Lucie Advisory.