Intern, Bus Operations & Scheduling

Job Description

Kick-start your career while using technology and data to improve public transportation! As a College Intern supporting OCTA’s Bus Operations & Scheduling Department, you’ll gain hands‑on experience in data analytics, automation, and process improvement while working alongside experienced transportation professionals. In this role, you’ll help improve reporting processes, develop innovative solutions, and support operational decision‑making using tools such as Excel, VBA, SQL, Power BI, and agency‑approved ChatGPT applications.

You will perform a variety of professional entry‑level duties related to your major field of study and the sponsoring department’s current business operations. As a College Intern, you will be exposed to OCTA’s career opportunities in the transportation industry. You will gain deeper awareness of transportation’s many facets through your OCTA orientation, projects and teams, and internal networking.

OCTA’s College Intern Program is a year‑round paid student/intern program. You will gain real world work experience on meaningful projects under the guidance of a transportation professional. You will have the opportunity to use problem solving, communication and decision‑making skills as you gain valuable work experience. You will also work with a mentor and benefit from career counseling.

The pay range is from $20.00 - $23.00 per hour depending on your education level. This position is not eligible for employee benefits. The work schedule will consist of approximately 20 hours a week, not to exceed 1,000 hours within a continuous 12-month period.

This posting will remain open until a candidate is selected.

What You’ll Do

• 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.

• 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.
• Strong analytical, technical, organizational, and problem‑solving skills.
• Interest in data analytics, automation, process improvement, and emerging technologies.
• Minimum cumulative GPA of 2.5 or higher
  .
• 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.
• A motivated, detail‑oriented individual who enjoys learning new technologies and developing creative solutions.

• Gain real‑world technology and analytics experience by working on projects that improve public transportation operations.
• Put your technical skills into practice using Excel, SQL, Power BI, automation, and emerging AI technologies.
• Make a measurable impact by helping streamline reporting processes, improve data accuracy, and increase operational efficiency.
• Learn from experienced transportation professionals while gaining…