Bus Operations & Scheduling Intern
Orange County Transportation AuthorityAdded 6d ago
Save this job and browse the whole board.
No credit card needed
Quick summaryby newgrad.ai
What you'll do
- Automate reporting processes using Excel, VBA, SQL, and Power BI.
- Analyze operational data to support management decision-making.
- Develop and document technical solutions to improve daily workflows.
What they're looking for
- Full-time undergraduate students in technical or business-related fields.
- Minimum 2.5 cumulative GPA.
- Proficiency with data analysis tools and strong problem-solving skills.
Pay and perks
- Hourly pay ranges from $20.00 to $23.00.
- Year-round position capped at 1,000 hours per 12-month period.
- Includes mentorship and career counseling opportunities.
Job Description College Intern – Bus Operations & Scheduling
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.
What We’re Looking For
- 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.
Why You’ll Love It Here
- 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 insight into how data supports transit operations and business decisions.
- Develop valuable professional skills in data analysis, process improvement, problem-solving, and collaboration.
- Build your resume and professional network through meaningful projects that connect technology, business operations, and public transportation.
- Join a team where innovation, integrity, and strategic thinking are valued.
Apply now to help shape the future of OCTA’s programs.
OCTA is an equal employment opportunity employer that recruits, hires, and promotes qualified people without regard to race, color, religion, creed, ancestry, national origin, age, sex, pregnancy, gender, gender identity and/or expression, sexual orientation, marital status, medical condition, disability, genetic information, military and veteran status, or any other legally protected status.
OCTA is the county’s transportation planning commission and public transit operator. With a focus on safety and accountability, we plan, fund, and implement countywide projects that include bus and rail transit, freeways and express lanes, rideshare, microtransit, paratransit, active transportation, and environmental programs. We’re passionate about creating a balanced, equitable and sustainable transportation system that reflects the diverse travel needs of the county’s 34 cities and 3.2 million residents. Our employees rated OCTA as a top workplace in Orange County. Come join us on our mission of keeping Orange County moving.
From Orange County Transportation Authority's public posting, laid out for reading by newgrad.ai with the wording unchanged. Check the original before you apply.
Apply on Orange County Transportation Authority's site.
Apply nowListing wrong or expired, or you're the employer and want it removed? Let us know.
