Business Analyst Intern

Who we are:

Headquartered in Pittsburgh, the firm is employee-owned. Consultants are staffed across industries early on, then specialize after a few years. Utilization target for consultants is 75 percent.

About the role:

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 Pittsburgh once a quarter, travel covered. Normal business hours, Monday to Friday, with some flexibility. You will write a lot of updates, so clear written English is important.

What you'll do:

• Analyse funnel drop-offs and summarise findings in a one-page note.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Join a weekly call with the analytics lead to review your work.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Check numbers across sources and flag mismatches before reports go out.
• Answer ad hoc data requests from sales and support within a day or two.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

Who can apply:

• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Available 20 to 40 hours a week, Monday to Friday.
• Comfort with numbers and strong attention to detail.
• Must be able to follow up on data requests without constant reminders.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027 or 2028.
• Some familiarity with Power BI or Tableau, even from a course or certification.

What you get out of it:

• Presenting numbers in a way non-technical people can act on.
• Top interns are considered for a junior analyst opening.
• Certificate, letter of recommendation and flexible hours.
• Writing SQL against a real production warehouse.

Duration: 4 months

Start date: Jan 2027

Stipend: $29.00 - $40.00 per hour

Perks:

• Flexible hours.
• Company laptop.
• Paid company holidays.
• Paid sick time.

Duration: 4 months. Start: Jan 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Briarwater Associates, LLC.