Business Analyst Intern

Most clients live within an hour's drive and come in for reviews twice a year. Everyone here is salaried. Nobody is paid on product sales. Founded in 1969, we now have 11 employees.

Overview:

Freeman Asset Management needs a data analytics intern to build reports and dashboards for the Revenue Operations team. This role is fully remote within the US. Flexible schedule. We have one team call a day, usually in the morning. You will need a reliable internet connection and a quiet place to work.

Day to day:

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• 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.
• Maintain the data dictionary and keep dashboard filters up to date.

Requirements:

• Currently enrolled in a bachelor's or master's program, graduating 2028.
• Available 40 hours a week for the full internship.
• Based in the US for the duration of the internship.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028.
• Available 20 to 40 hours a week, Monday to Friday.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Clear written English for reports and status updates.
• A sample dashboard or analysis project you can share.

Nice to have:

• Google Data Analytics or Microsoft PL-300 certification.
• Experience with Google Analytics 4 or Mixpanel.
• Python with pandas for data cleaning.

What you'll learn:

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

Duration: 10-12 weeks

Start date: May 2027

Stipend: $30.00 to $34.00 an hour

Perks:

• Home office setup stipend.
• Flexible hours.
• Return offer opportunities.
• Paid sick time.
• Mentorship from a dedicated buddy and manager.

No agencies or third-party recruiters, please.

Duration: 10-12 weeks. Start: May 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Freeman Asset Management.