About The Position

The Kentucky Transportation Cabinet (KYTC) manages Kentucky’s transportation network, including infrastructure construction, bridge inspections, driver licensing, vehicle registration, and highway safety programs. This internship is with the Department of Highways and involves transportation data analysis and reporting. Interns audit automated Extract, Transform, Load (ETL) processes and data quality, write and refine SQL views, collaborate with Cabinet staff to understand datasets and workflows, and use Power BI to create interactive dashboards and track performance and trends. They also prepare and present statistical summaries to the Assistant State Highway Engineer and leadership team. The Team Kentucky Internship Program provides college students with relevant public-service work experience, professional development, and networking opportunities. Applicants are vetted through an interview process. Participants must complete program activities, including orientation, all Professional Development Days, at least one agency tour, 300 working hours, a final project, and the TKIP Reception. Successful program completion can make participants eligible for interview preference when applying for an advertised KRS Chapter 18A classified Executive Branch position, in accordance with 101 KAR 2:086. The position is listed as less than nine months maximum, eligible for overtime pay, and 37.5 hours per week. Pay is $16.773 per hour for undergraduate students and $19.478 per hour for graduate students. Returning interns who previously completed the program may receive an additional $1 per hour for each year they return.

Requirements

  • Be enrolled at an accredited post-secondary school, or be a graduating high school senior enrolled in college courses.
  • Be in good standing with the school and have at least a 2.5 GPA at hire.
  • Be at least 18 years old at the time of employment; candidates must be 18 by May 17, 2027.
  • Furnish proof of enrollment to the Personnel Cabinet.
  • Maintain any required licenses, certifications, or other credentials for the length of employment.
  • Be dependable, meet assigned deadlines, and comply with a designated work schedule.
  • Demonstrate initiative and a self-motivated approach to problem-solving.
  • Seek feedback and learning opportunities and ask for support or guidance when needed.

Responsibilities

  • Audit automated ETL processes and data quality.
  • Write and refine SQL views to ensure transportation datasets are clean and accurate.
  • Meet with staff across the Cabinet to understand data, clarify operational questions, and map organizational workflows.
  • Connect SQL views to Power BI and build interactive dashboards to track performance and forecast departmental trends.
  • Present concise statistical summaries to the Assistant State Highway Engineer and leadership team.
  • Attend TKIP Orientation, all Professional Development Days, at least one Agency Tour, and the TKIP Reception.
  • Complete 300 working hours throughout the program and submit a final project.
  • Follow the designated work schedule, meet deadlines, and communicate with a supervisor about schedule changes or support needs.
  • Seek learning opportunities, request feedback, and ask questions when guidance is needed.

Benefits

  • Eligible participants may receive interview preference after successful program completion when applying for an advertised KRS Chapter 18A classified Executive Branch position.
  • Returning interns who previously completed the program may receive an additional $1 per hour for each year they return.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service