Data Analyst Intern - Remote

Customers use our platform to manage equipment rentals: reservations, check-out, damage photos, invoicing and QuickBooks sync. Most of what we build is back-office software for property managers, including lease tracking, work orders and tenant payments. Founded in 1998, we now have 100 employees.

About the role

Remote internship for a student who likes spreadsheets and is not scared of messy data. This role is fully remote within the US. Flexible hours with a daily team call in the morning. We ship you a laptop and accessories before your first day.

Day to day

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Analyse funnel drop-offs and summarise findings in a one-page note
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Check numbers across sources and flag mismatches before reports go out
• Join a weekly call with the analytics lead to review your work
• Answer ad hoc data requests from sales and support within a day or two
• Maintain the data dictionary and keep dashboard filters up to date
• Track marketing campaign results using Google Analytics 4 data

Who can apply

• 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
• Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028
• Must be able to follow up on data requests without constant reminders
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Comfort with numbers and strong attention to detail
• A sample dashboard or analysis project you can share

Nice to have

• Experience with Google Analytics 4 or Mixpanel
• Google Data Analytics or Microsoft PL-300 certification
• Prior project with real business data from a college club, family business or freelance client

What you get out of it

• Top interns are considered for a junior analyst opening
• Certificate, letter of recommendation and flexible hours
• How business metrics like CAC, churn and retention are actually calculated
• Presenting numbers in a way non-technical people can act on

Duration: 5 months

Start date: Jan 2027

Stipend: $35.00 to $39.50 per hour

Perks

• Intern events and speaker sessions (virtual)
• Flexible hours
• Paid sick time

Duration: 5 months. Start: Jan 2027.

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