Intern, Bus Operations & Scheduling

Orange County Transportation Authority • Orange, CA

4d

About The Position

The College Intern – Bus Operations & Scheduling supports OCTA’s Bus Operations & Scheduling Department with data analytics, automation, and process improvement. The intern performs professional entry-level duties related to their major and the department’s business operations, helping improve reporting processes and support operational decision-making with tools such as Excel, VBA, SQL, Power BI, and agency-approved ChatGPT applications.

OCTA’s year-round paid College Intern Program provides hands-on experience on meaningful projects under the guidance of transportation professionals. Interns receive an OCTA orientation, work with a mentor, benefit from career counseling, and gain exposure to career opportunities and different facets of the transportation industry through projects, teams, and internal networking.

The pay range is $20.00–$23.00 per hour, depending on education level. The position is not eligible for employee benefits. The schedule is approximately 20 hours per week, with a maximum of 1,000 hours within a continuous 12-month period. 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.

What This Job Offers

• Job Type: Part-time
• Career Level: Intern