Skip to main content
Commonwealth of Kentucky logo

Team Kentucky Internship Program - Transportation - Department of Highways

Commonwealth of Kentucky

Frankfort, KYTemporary / Full-time$16.77–19.48/hrSeen todayIn the employer's feed · checked in the last 2 days

See where you stand before you apply. No sign-up to start.

You apply on the posting's application page, with no Olive account needed.

Watch jobs like this.

Don't just apply. Show up ready.

Olive works from this exact posting.

At a glance

Compensation
$16.77–19.48/hr
Location
Frankfort, KY
Role Type
Internship
Schedule
Temporary / Full-time
Work Authorization
Not specified

Olive focuses on jobs in the United States, including remote roles you can work from there.

Job overview

The Team Kentucky Internship Program places college students in public-service roles with the Department of Highways. This position focuses on transportation data: auditing ETL processes and data quality, writing SQL views, building Power BI dashboards, collaborating with Cabinet staff, and presenting findings to leadership. Participants receive professional development and networking opportunities. Applicants must meet enrollment, GPA, and age criteria; program completion includes 300 working hours and specified events and deliverables.

Skills & qualifications

RequiredNice to have

Skills

ETL Auditing, nice to haveData Quality Auditing, nice to haveSQL, nice to havePower BI, nice to haveData Visualization, nice to haveData Forecasting, nice to haveStatistical Summarization, nice to haveDependability, nice to haveInitiative, nice to haveProblem Solving, nice to haveCommunication, nice to have

Qualifications

Enrolled at Accredited Postsecondary School, requiredGPA 2.5+, requiredMust Be 18+, requiredFull-Time High School Senior Enrolled in College Courses or Accredited Postsecondary Enrollment, required

Full job description

Advertisement Closes

1/29/2027 (11:59 PM ET)

2606234

Team Kentucky Internship Program - Transportation - Department of Highways

Pay Grade03

Salary

Undergraduate Student - $16.773

Graduate Student - $19.478

TKIP participants will receive additional compensation ($1/hour) for each year that they return as an Intern, after previously completing the program.

Employment Type

EXECUTIVE BRANCH | LESS THAN 9 MONTHS MAXIMUM | ELIGIBLE FOR OVERTIME PAY | 18A | 37.5 HR/WK

Click here for more details on state employment. (https://personnel.ky.gov/Pages/Careers.aspx)

Hiring Agency

Transportation Cabinet | Department of Highways

Location

200 Mero Street

Frankfort, KY 40622 USA

Description

About Transportation –

The Kentucky Transportation Cabinet (KYTC) is responsible for Kentucky’s transportation network. The agency handles everything from major infrastructure construction and bridge inspections to driver licensing, vehicle registration, and highway safety programs, all aimed at keeping people and freight moving safely and efficiently across the Commonwealth.

A Day in the Life –

  • Audit data and pipelines: Check automated Extract, Transform, Load (ETL) processes and audit data quality. Write and refine Structured Query Language (SQL) views to ensure complex transportation datasets are clean and accurate.

  • Collaborate with Business Users: Meet with staff across the Cabinet to understand their data, clarify operational questions, and map out organizational workflows.

  • Build Power Business Intelligence (BI) Dashboards: Connect SQL views to Power BI to build interactive dashboards, track performance, and forecast departmental trends.

  • Brief Leadership: Present concise statistical summaries to the Assistant State Highway Engineer and leadership team, turning technical findings into actionable decisions for the Department of Highways.

About Team Kentucky Internship Program –

The Team Kentucky Internship Program brings talented and motivated college students into the world of public service. The program provides meaningful and relevant work experience, professional development activities, and offers interns networking opportunities with other interns across the Commonwealth, all while working alongside program and field professionals, state government leaders. The Team Kentucky Internship Program is a prestigious and competitive program; therefore, interested applicants must complete an online application and be vetted through an interview process. Those selected for the program will perform valuable work in our state agencies.

To be considered for a position in the Team Kentucky Internship Program, applicant must:

  • Be enrolled at an accredited post-secondary school.

  • Be in good standing with the school with at least a 2.5 grade point average at hire.

  • Graduating high school seniors enrolled in college courses with a 2.5 GPA may also qualify and apply to participate in the program. Candidates must be 18 years of age by May 17, 2027.

TKIP participants will be paid the following rates:

  • Undergraduate Student - $16.773

  • Graduate Student - $19.478

  • TKIP participants may receive additional compensation ($1/hour) for each year that they return as an Intern, after completing the Team Kentucky Internship Program.

Program Requirements –

To successfully complete the Team Kentucky Internship Program and be eligible for the valuable benefit of receiving interview preference when applying for an advertised KRS Chapter 18A classified position within the Executive Branch, in compliance with Kentucky Administrative Regulation 101 KAR 2:086, you must:

  • Attend TKIP Orientation

  • Attend ALL Professional Development Days

  • Attend at least 1 Agency Tour

  • Complete 300 working hours throughout the program

  • Submit a final project

  • Attend TKIP Reception

What You’ll Need to Succeed –

  • Be dependable: Comply with a designated work schedule and meet assigned deadlines. Communicate with your supervisor ahead of time if you are unable to follow your work schedule, would like to request a schedule adjustment, or if you need further support to meet a deadline.

  • Take initiative: Look for ways to go above and beyond in your day-to-day work to show your supervisor that you are a self-motivated problem solver.

  • Take advantage of learning opportunities: Seek out new opportunities to learn about your state agency and state government. Request feedback on your job performance - this will show you are receptive and searching for opportunities to grow. Ask questions if you are unsure how to complete an assigned task or need additional support or guidance.

Minimum Requirements

EDUCATION:NONE

EXPERIENCE, TRAINING, OR SKILLS:NONE

Substitute EDUCATION for EXPERIENCE:NONE

Substitute EXPERIENCE for EDUCATION:NONE

SPECIAL REQUIREMENTS (AGE, LICENSURE, REGULATION, ETC.):Must be 18 years of age at the time of employment. Must be enrolled on a full-time basis in high school as a graduating senior enrolled in college courses OR enrolled at an accredited post-secondary school. Applicants must furnish proof of enrollment in such a program to the Personnel Cabinet. Must maintain any required licensure(s), certification(s), or other credentials for the length of employment in this job classification. Employing agency is responsible for ensuring employee possesses and maintains required licensure(s), certification(s) or other credentials.

Working Conditions

Working conditions will vary based on agency and position.

Probationary Period

NONE

If you have questions about this advertisement, please contact Tracy Nowaczyk [email protected] ([email protected] ?Subject=2606234 - Team Kentucky Internship Program - Transportation - Department of Highways) or (502) 782-5595.

An Equal Opportunity Employer M/F/D

How this job compares

Set against the 4,646 open Data Analyst jobs on Olive Jobs, counted November 19, 2026.

Pay
  • This posting$16.77–19.48/hr
  • US median$40–48/hr384 hourly ranges

This range's midpoint, $18.13/hr, is 58% below the US median midpoint ($43/hr) — in the lowest quarter of Data Analyst hourly ranges across the US.

Openings
Olive Jobs lists 49 open Data Analyst jobs in Kentucky and 4,646 across the US. 8% of them nationwide are listed as remote or flexible.
Hiring the most in Kentucky
Experience
Data Analyst postings that state a minimum ask for 3 years of experience at the median; the middle half ask for 2 to 5 years (3,674 postings).
Education
1,743 of the 4,646 open Data Analyst jobs (38%) ask for a bachelor's degree or higher.

Pay, requirements and demand for Intern jobs

Counted across the open, public US postings on Olive Jobs on November 19, 2026. Figures based on too few postings are left out.

Prepare for this role

You've read the whole posting — now see how you match it.