Analytics Intern

Who we are:

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.

About the role:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Remote position. Most of the team is in Reno, but nobody is required to come in. Standard office hours, Monday to Friday, with flexibility around them. Day-to-day communication is in Slack and Google Meet.

What you'll do:

• Join a weekly call with the analytics lead to review your work.
• 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.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Check numbers across sources and flag mismatches before reports go out.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Track marketing campaign results using Google Analytics 4 data.

Who can apply:

• Based in the US for the duration of the internship.
• Currently enrolled in a bachelor's or master's program, graduating 2028.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• A sample dashboard or analysis project you can share.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Available 20 to 40 hours a week, Monday to Friday.
• Comfort with numbers and strong attention to detail.
• Must be able to follow up on data requests without constant reminders.
• Laptop with Excel or Google Sheets and a stable internet connection.

Duration: 10 weeks

Start date: June 2027

Stipend: $29.50 - $41.50/hr

Perks:

• Paid sick time.
• Final presentation to leadership.
• Home office setup stipend.
• Mentorship from a dedicated buddy and manager.
• Paid company holidays.
• Company laptop.

Please include a short note on why this role interests you.

Duration: 10 weeks. Start: June 2027.

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