Business Analytics Intern

Who we are:

Since 1976, the firm has done strategy and operations work for utilities and public agencies. Most engagements run three to nine months, with a small team on site part of the week. We have been family run since 1976. We write a lot: proposals, status reports, slide decks and final reports.

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 internship with a team based in Oklahoma City. The stipend is paid at the end of each month. You will need at least 4 hours of overlap with US Central time. You get a company laptop and a headset before you start.

Responsibilities:

• Prepare the weekly MIS report and send it to the team lead every Monday
• Check numbers across sources and flag mismatches before reports go out
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

Requirements:

• Available for at least 30 hours a week, work from home
• Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program
• Based anywhere in Pakistan
• Have a working laptop and a stable internet connection, ideally with a UPS backup
• Basic SQL, enough to write SELECT queries with joins and filters
• Comfort with numbers and strong attention to detail
• Must be able to follow up on data requests without constant reminders
• Some familiarity with Power BI or Tableau, even from a course or certification
• Laptop with Excel or Google Sheets and a stable internet connection
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts

Duration: 6 months

Start date: Jan 2027

Stipend: $250 - $300 per month

Perks:

• Certificate
• Letter of recommendation
• 5 days a week
• Flexible work hours
• Free access to paid learning courses
• Pre-placement offer (PPO) for strong performers

Duration: 6 months. Start: Jan 2027.

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