Excel & Data Analysis Intern

Our practice areas include healthcare, higher education, science and technology, and aviation. Deadlines cluster around permit submissions and bid sets.

The internship:

Remote internship for a student who likes spreadsheets and is not scared of messy data. Our headquarters is in Stockton, and about a third of the team works remotely from other countries. This is a remote internship. You will work with our team in Stockton, and the stipend is paid monthly in USD. You will need at least 3 hours of overlap with US Pacific time.

Day to day:

• 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
• Maintain the data dictionary and keep dashboard filters up to date
• Join a weekly call with the analytics lead to review your work
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Document metric definitions so everyone calculates churn and conversion the same way

Requirements:

• Can commit full time, from home, for the whole internship
• Have their own laptop and a reliable internet connection
• Can start right away or within the next two weeks
• Women returning to work after a career break are welcome to apply
• Clear written English for reports and status updates
• Basic SQL, enough to write SELECT queries with joins and filters
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026, 2027 or 2028
• A sample dashboard or analysis project you can share
• Some familiarity with Power BI or Tableau, even from a course or certification
• Laptop with Excel or Google Sheets and a stable internet connection

Nice to have:

• Experience with Google Analytics 4 or Mixpanel

What you'll learn:

• Top interns are considered for a junior analyst opening
• Certificate, letter of recommendation and flexible hours
• You will build at least one dashboard that managers use every week
• Presenting numbers in a way non-technical people can act on

Duration: 3 months

Start date: Within 2 weeks

Stipend: $500 - $600/month

Perks:

• Certificate
• Informal dress code
• Free access to paid learning courses
• Job offer on successful completion
• Pre-placement offer (PPO) for strong performers

Let us know your current notice period and salary expectations.

Duration: 3 months. Start: Within 2 weeks.

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