Transit Data Analytics Intern: Ops & Scheduling

Octa, LLC

Santa Ana (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 offering a College Intern position in the Bus Operations & Scheduling Department. You will gain hands-on experience with data analytics, automation, and reporting improvements using Excel, VBA, SQL, and Power BI under a transportation professional team.

The role is a year-round paid internship with mentorship, dashboards development, and opportunities to contribute to operational decisions. Expect about 20 hours per week, with no employee benefits eligibility.

Qualifications

  • Enrolled full-time as a college student pursuing a bachelor’s degree in CS, data analytics, or related field.
  • Strong analytical and problem-solving skills; able to work independently.
  • GPA 2.5+ and familiarity with Excel/SQL/VBA/Power BI.

Responsibilities

  • Analyze workflows to improve reporting accuracy and efficiency.
  • Develop automated reports using Excel, VBA, SQL, and Power BI.
  • Compile and reconcile operational data to support decisions.
  • Create dashboards and analytical tools; document procedures.
  • Collaborate with staff to understand needs and suggest improvements.

Skills

Excel
SQL
VBA
Power BI
AI tools

Education

Bachelor's degree in Computer Science
Data Analytics

Tools

Power BI
SQL
VBA

Job description

OCTA is offering a College Intern position in the Bus Operations & Scheduling Department. You will gain hands-on experience with data analytics, automation, and reporting improvements using Excel, VBA, SQL, and Power BI under a transportation professional team.

The role is a year-round paid internship with mentorship, dashboards development, and opportunities to contribute to operational decisions. Expect about 20 hours per week, with no employee benefits eligibility.

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+ Energie • Orange (CA)

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

Octa, LLC • Orange (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
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

Octa+ Energie • Orange (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
Transit Data & Contracts Intern
Transit Data & Contracts Intern

Octa+ Energie • Orange (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
Paid College Intern – Specialized Transit Programs
Paid College Intern – Specialized Transit Programs

Octa, LLC • Orange (CA)

Hybrid
USD 28,000 - 32,000