Senior Associate, Data and Advanced Analytics

Application Due Date:  Preference given to applications received by Oct. 1, 2024
Location:  Frankfort, KY with limited telecommuting 
Travel In-state and limited out-of-state travel
Compensation:  $62,000 - $65,500
Retirement:  TIAA

Function of Position

The Senior Associate will be responsible for the fulfillment of all internal and external data requests and reporting deliverables using Tableau and other business intelligence tools. This includes support of researchers by creating and providing research datasets, performing descriptive analysis in support of agency projects, and maintaining/running scripts for reoccurring external reporting obligations.   

Duties and Responsibilities

• Custom dataset creation from the KPEDS Data Warehouse in support of researchers or special projects using T-SQL, R, or Python languages from a Microsoft Server RDBMS.
• Descriptive data analysis based on policy/agency need.
• Creation and delivery of annual external data obligations.
• Ensuring that annual data collections are received, and data are warehoused in a timely manner.
• Maintenance of existing dashboards. Includes yearly data updates (as data become available) and enhancement requests.
• Design of new visualization and dashboards based on policy/agency need.
• Quality assurance auditing of existing visualization and research datasets.

Education and Experience

• Bachelor’s degree or above in a technical or education field.
• Experience working with large administrative datasets. 
• Experience working with Tableau and other business intelligence tools.   
• Experience working with education related data.  Preferably in an institutional research or institutional effectiveness role.
• Proven competency in using T-SQL, R, or Python languages in data analysis and dataset creation.
• Basic knowledge of Relational Database Management Systems (RDBMS). 

Application Information

Interested applicants should send the follow materials to CPE.HR@ky.gov :

• Letter of application specifically addressing the responsibilities and qualifications of the position.
• Resume.
• Names, titles, and contact information for at least three professional references.