Transit Data Analytics Intern: Operations & Scheduling

Octa+ Energie

Orange (CA)

On-site

USD 28,000 - 32,000

Part time

13 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

OCTA is seeking a College Intern for its Bus Operations & Scheduling team in California. You will gain hands-on experience in data analytics, automation, and process improvement while using Excel, VBA, SQL, Power BI, and AI tools.

You will work ~20 hours per week in a paid program, with a cap of 1,000 hours in a 12‑month period, under a mentor. This role offers exposure to transit operations and career opportunities in transportation.

Qualifications

  • Currently enrolled full‑time as a freshman, sophomore, junior, or senior at a four‑year college or university pursuing a bachelor’s degree.
  • GPA 2.5 or higher required.
  • Familiarity with Excel, SQL, VBA, Power BI or similar tools.

Responsibilities

  • Analyze existing workflows and identify opportunities to improve reporting accuracy and automation.
  • Assist with developing automated reports and streamline processes using Excel, VBA, SQL, Power BI, and AI tools.
  • Research, compile, analyze, and reconcile operational data to support initiatives and decisions.
  • Support development and enhancement of dashboards, spreadsheets, and reporting tools.
  • Collaborate with staff to understand business needs and recommend improvements.
  • Develop and document procedures, workflows, and technical solutions.
  • Participate in special projects to improve performance and data management.

Skills

Analytical skills
Technical skills
Organizational skills
Problem solving
Data analytics interest
Automation
Process improvement
Emerging technologies
Excel
SQL
VBA
Power BI

Education

Bachelor’s degree in Computer Science, Data Analytics, Information Systems, Business Analytics, Engineering, Business Administration, or related field

Tools

Excel
SQL
VBA
Power BI

Job description

OCTA is seeking a College Intern for its Bus Operations & Scheduling team in California. You will gain hands-on experience in data analytics, automation, and process improvement while using Excel, VBA, SQL, Power BI, and AI tools.

You will work ~20 hours per week in a paid program, with a cap of 1,000 hours in a 12‑month period, under a mentor. This role offers exposure to transit operations and career opportunities in transportation.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Transit Data Analytics Intern - Operations & Scheduling
Transit Data Analytics Intern - Operations & Scheduling

Octa, LLC • Orange (CA)

On-site
USD 28,000 - 32,000
Transit Data Analytics Intern: Ops & Scheduling
Transit Data Analytics Intern: Ops & Scheduling

Octa, LLC • Santa Ana (CA)

On-site
USD 28,000 - 32,000
Transit Operations Intern: Data, Analysis & Field Support
Transit Operations Intern: Data, Analysis & Field Support

Octa, LLC • Orange (CA)

Hybrid
USD 28,000 - 32,000
Mentoring
Career counseling
Paid internship
Transit Operations Intern — Data & Contract Oversight
Transit Operations Intern — Data & Contract Oversight

Octa+ Energie • California

On-site
USD 28,000 - 32,000
Paid internship
Mentor program
Career counseling
Intern, Bus Operations & Scheduling
Intern, Bus Operations & Scheduling

Octa+ Energie • Orange (CA)

On-site
USD 28,000 - 32,000
Transit Programs Intern: Data, Outreach & Impact
Transit Programs Intern: Data, Outreach & Impact

Octa+ Energie • Santa Ana (CA)

On-site
USD 28,000 - 32,000
Intern, Bus Operations & Scheduling
Intern, Bus Operations & Scheduling

Orange County Transportation Authority • Santa Ana (CA)

On-site
USD 28,000 - 32,000
Intern, Bus Operations & Scheduling
Intern, Bus Operations & Scheduling

Octa, LLC • Orange (CA)

On-site
USD 28,000 - 32,000
Transit Data & Contracts Intern
Transit Data & Contracts Intern

Octa+ Energie • Orange (CA)

On-site
USD 28,000 - 32,000
Paid College Intern – Specialized Transit Programs
Paid College Intern – Specialized Transit Programs

Octa, LLC • Orange (CA)

Hybrid
USD 28,000 - 32,000