Analytics Intern

About BMG Software

The product is a mobile app plus a React web dashboard, with a Python and PostgreSQL backend on AWS. We started in 2021 and have grown to about 70 people. Code review is required on every pull request, and nobody merges their own changes.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. You can work from home anywhere in the US. We have no office requirement.

Responsibilities

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Create charts and short slide decks for the monthly review call
• Track marketing campaign results using Google Analytics 4 data
• Document metric definitions so everyone calculates churn and conversion the same way
• Prepare the weekly MIS report and send it to the team lead every Monday

Requirements

• Based in the US for the duration of the internship
• Available 40 hours a week for the full internship
• Currently enrolled in a bachelor's or master's program, graduating 2026 or 2027
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Available 20 to 40 hours a week, Monday to Friday
• Clear written English for reports and status updates
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Some familiarity with Power BI or Tableau, even from a course or certification
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026 or 2027

Bonus points

• Familiarity with DAX in Power BI

Duration: 6 months

Start date: Immediately

Stipend: $28.50-$36.00/hr

Perks

• Intern events and speaker sessions (virtual)
• Mentorship from a dedicated buddy and manager
• Home office setup stipend
• Paid company holidays
• Flexible hours
• Paid sick time

We are unable to sponsor visas for this position.

Duration: 6 months. Start: Immediately.

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