Team Kentucky Internship Program - Transportation - Department of Highways

Commonwealth of Kentucky

Frankfort (KY)

Presencial

USD 23.000 - 27.000

Jornada completa

Hace 2 días
Sé de los primeros/as/es en solicitar esta vacante

Consigue una respuesta de este empleador

Tu currículum y tu carta de presentación, adaptados exactamente a lo que buscan contratar.

Supera los filtros ATS

Descripción de la vacante

Commonwealth of Kentucky, Transportation Cabinet – Department of Highways, is seeking participants for the Team Kentucky Internship Program (TKIP) in Frankfort, KY. Interns will audit data pipelines, build Power BI dashboards, and collaborate with agency staff to translate complex data into actionable insights.

Undergraduate and graduate students are welcome, with hourly pay and potential year‑based increases. Hours are 37.5 per week, and the internship lasts up to nine months.

Formación

  • Be dependable: Comply with a designated work schedule and meet deadlines.
  • Take initiative: Look for ways to go above and beyond in day-to-day work.
  • Take advantage of learning opportunities: Seek out new opportunities to learn about your state agency and state government.

Responsabilidades

  • Audit data and pipelines: Check ETL processes and audit data quality.
  • Collaborate with Business Users: Meet with staff to understand data and workflows.
  • Build Power BI Dashboards: Connect SQL views to Power BI to track performance.
  • Brief Leadership: Present statistical summaries to leadership and translate findings into actions.

Conocimientos

Dependable
Initiative
Learning opportunities

Descripción del empleo

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

Team Kentucky Internship Program - Transportation - Department of Highways

Pay Grade

03

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

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 agencyhandles everything from major infrastructure construction and bridge inspections to driver licensing, vehicleregistration, and highway safety programs, all aimed at keeping people and freight moving safely andefficiently 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
  • 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 at Tracy.Nowaczyk@ky.gov or (502) 782-5595.
An Equal Opportunity Employer M/F/D
Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Team Kentucky Internship Program - Personnel Cabinet
Team Kentucky Internship Program - Personnel Cabinet

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Health & Family Services - Office of Human Resource Management
Team Kentucky Internship Program - Health & Family Services - Office of Human Resource Management

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Health & Family Services - Division of Family Support
Team Kentucky Internship Program - Health & Family Services - Division of Family Support

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Governor - Communications Office
Team Kentucky Internship Program - Governor - Communications Office

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Public Protection - Department of Insurance
Team Kentucky Internship Program - Public Protection - Department of Insurance

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Public Protection - Dept. of Housing, Buildings & Construction
Team Kentucky Internship Program - Public Protection - Dept. of Housing, Buildings & Construction

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 28.000
Team Kentucky Internship Program - Health & Family Services - Quality Assurance Branch
Team Kentucky Internship Program - Health & Family Services - Quality Assurance Branch

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Public Protection - Department of Professional Licensing
Team Kentucky Internship Program - Public Protection - Department of Professional Licensing

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Public Protection - Office of Communications and Public Outreach
Team Kentucky Internship Program - Public Protection - Office of Communications and Public Outreach

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 23.000 - 27.000
Team Kentucky Internship Program - Energy & Environment - Water Infrastructure Branch
Team Kentucky Internship Program - Energy & Environment - Water Infrastructure Branch

Commonwealth of Kentucky • Frankfort (KY)

Presencial
USD 19.000 - 27.000
Overtime pay eligibility
Paid internship