Business Intelligence Intern

About Lakeside Water:

We employ 1,300 people in operations, engineering, customer service and corporate roles. Call centers in Reno and two other locations handle customer service. Pension plan for most employees.

Overview:

Lakeside Water needs a data analytics intern to build reports and dashboards for the Revenue Operations team. Fully remote. You can work from anywhere in the US. Standard office hours, Monday to Friday, with flexibility around them.

Responsibilities:

• Check numbers across sources and flag mismatches before reports go out
• Join a weekly call with the analytics lead to review your work
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Create charts and short slide decks for the monthly review call
• Prepare the weekly MIS report and send it to the team lead every Monday
• Document metric definitions so everyone calculates churn and conversion the same way
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Build and update dashboards in Power BI, Tableau or Looker Studio

What we're looking for:

• Currently enrolled in a bachelor's or master's program, graduating 2027 or 2028
• Available 40 hours a week for the full internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• 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 2027 or 2028
• Must be able to follow up on data requests without constant reminders
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Some familiarity with Power BI or Tableau, even from a course or certification
• A sample dashboard or analysis project you can share
• Clear written English for reports and status updates

Duration: 12 weeks

Start date: Summer 2027

Stipend: $34.50 - $36.50 an hour

Perks:

• Mentorship from a dedicated buddy and manager
• Return offer opportunities
• Flexible hours
• Paid sick time
• Company laptop
• Final presentation to leadership

Duration: 12 weeks. Start: Summer 2027.

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