Business Analytics Intern

Who we are:

We prepare audits, reviews and compilations for nonprofits, construction companies and HOAs. We track time in six-minute increments.

About the role:

This role is about accuracy first. A wrong number in a report is worse than a late one. The internship is fully remote. Interns join our College Station team on daily calls and get a named mentor. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT. We use Slack, Notion and Google Meet. Cameras on for team calls.

Responsibilities:

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Check numbers across sources and flag mismatches before reports go out.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Track marketing campaign results using Google Analytics 4 data.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Join a weekly call with the analytics lead to review your work.
• Create charts and short slide decks for the monthly review call.

Requirements:

• Have their own laptop and a reliable internet connection.
• Are able to join within 15 days.
• Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2026, 2027 or 2028 batch)
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Available 20 to 40 hours a week, Monday to Friday.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

Nice to have:

• Google Data Analytics or Microsoft PL-300 certification.

Duration: 6 months

Start date: Dec 2026

Stipend: $500 - $550/month

What we offer:

• Certificate.
• Informal dress code.
• Internet allowance.
• Performance bonus.
• Free access to paid learning courses.
• Job offer on successful completion.

Duration: 6 months. Start: Dec 2026.

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