Transit Data Analytics Intern - Operations & Scheduling

Octa, LLC

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 Bus Operations & Scheduling in Orange, CA. The role focuses on data analytics, automation, and reporting improvements using Excel, VBA, SQL, Power BI, and AI tools.

You will work about 20 hours per week for up to 1,000 hours in a 12-month period, with a pay range of $20.00–$23.00 per hour. You'll analyze workflows, develop automated reports, and support dashboards while collaborating with staff and gaining exposure to transit operations.

Qualifications

  • Currently enrolled full-time as a freshman, sophomore, junior, or senior in a four-year college or university.
  • Pursuing a bachelor's degree in Computer Science, Data Analytics, Information Systems, Business Analytics, Engineering, Business Administration, or related field.
  • Minimum cumulative GPA of 2.5 or higher.
  • Familiarity with Excel, SQL, VBA, Power BI, or similar data analysis tools.
  • Strong analytical, technical, organizational, and problem-solving skills.
  • Effective written and verbal communication skills.
  • Ability to work independently and collaboratively.

Responsibilities

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

Skills

Analytical skills
Problem solving
Effective communication
Excel
SQL
Power BI
Automation

Education

Pursuing Bachelor's degree

Tools

Excel
VBA
SQL
Power BI
AI tools

Job description

OCTA is seeking a College Intern for Bus Operations & Scheduling in Orange, CA. The role focuses on data analytics, automation, and reporting improvements using Excel, VBA, SQL, Power BI, and AI tools.

You will work about 20 hours per week for up to 1,000 hours in a 12-month period, with a pay range of $20.00–$23.00 per hour. You'll analyze workflows, develop automated reports, and support dashboards while collaborating with staff and gaining exposure to transit operations.

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: 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 Programs Intern: Data, Outreach & Impact
Transit Programs Intern: Data, Outreach & Impact

Octa+ Energie • Santa Ana (CA)

On-site
USD 28,000 - 32,000
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
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