Intern, Bus Operations & Scheduling

OCTA•Orange, CA

6d•$20 - $23

About The Position

The College Intern – Bus Operations & Scheduling supports OCTA’s Bus Operations & Scheduling Department by using technology and data to improve public transportation. The intern gains hands-on experience in data analytics, automation, and process improvement while working with transportation professionals and supporting operational decision-making. Tools may include Excel, VBA, SQL, Power BI, and agency-approved ChatGPT applications. The role involves professional entry-level duties related to the intern’s major and the department’s business operations. The year-round paid student program provides real-world experience on meaningful projects under the guidance of a transportation professional, along with an OCTA orientation, internal networking, a mentor, and career counseling. The schedule is approximately 20 hours per week, with a limit of 1,000 hours during a continuous 12-month period. Pay is $20.00–$23.00 per hour depending on education level. The position is not eligible for employee benefits. The posting remains open until a candidate is selected.

Requirements

Currently enrolled full-time as a freshman, sophomore, junior, or senior at a four-year college or university, pursuing a bachelor’s degree in Computer Science, Data Analytics, Information Systems, Business Analytics, Engineering, Business Administration, or a related field.
Minimum cumulative GPA of 2.5.
Strong analytical, technical, organizational, and problem-solving skills.
Interest in data analytics, automation, process improvement, and emerging technologies.
Familiarity with Excel, SQL, VBA, Power BI, or similar data analysis tools.
Effective written and verbal communication skills.
Ability to work independently and collaboratively in a professional environment.
Motivated and detail-oriented, with an interest in learning new technologies and developing creative solutions.

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.