Data Analyst, Perkins Reporting

State of Ohio • Columbus, OH

2d • Onsite

About The Position

This position serves at the pleasure of the Chancellor and in a fiduciary capacity to the Ohio Department of Higher Education (ODHE). The Data Analyst, Perkins Reporting will spend 70% of working time focused on Postsecondary Career and Technical (CTE) data processes and reporting. The Ohio Department of Higher Education is a Cabinet-Level agency for the Governor of the State of Ohio that oversees higher education for the state. The agency's main responsibilities include authorizing and approving new degree programs, managing state-funded financial aid programs, and developing and advocating policies to maximize higher education's contributions to the state and its citizens. The Data Management and Analysis division is responsible for the collection of Higher Education Information (HEI) system data and the activities around the use of that data. Data management staff work with institutions to submit data, troubleshoot errors and warnings that occur during the submission process, and provide guidance on how to interpret data elements in the system. In addition to providing support to the institutions for data submission, the Data Management and Analysis area also provides data and analyses to fulfill the ad hoc reporting requirements of the agency, the legislature, governor, and public, and fulfills data requests related to higher education.

Requirements

• Bachelor’s degree.
• Strong quantitative and analytical skills.
• Proficient with use of SQL and at least one other scripting language.
• Experience with making presentations and leading discussions.
• Solid customer service skills and team work experience are essential.
• Strong oral and written communication skills are necessary.
• Ability to organize and express ideas concisely.

Nice To Haves

• Master’s degree or two years’ experience in a postsecondary, higher education setting.
• Knowledge and professional work experience in career-technical education systems.

Responsibilities

• Uses SQL, Python, and R to extract, clean, merge, and validate HEI and non‑HEI datasets for the purposes of Postsecondary CTE processes.
• Serves as technical lead for data area procedures and policies for CTE related programming to career center staff, campus staff, ODHE staff, and public at-large.
• Develops reproducible scripts, automated processes, and documentation to support ongoing state and federal reporting.
• Conducts research and analyzes data from HEI and national higher education data sources using SQL, Python, or R.
• Analyzes and reviews data to identify data reporting issues and to ensure data reliability and validity for queries, reports, publications, and other Postsecondary CTE purposes.
• Responds to routine internal and external data requests using relational database and other data tools appropriate for generating reports.
• Represents ODHE to deliver speeches and presentations at meetings/conferences.
• Participates in development and revision of CTE program policies and procedures related to data management.
• Other duties as assigned.

Benefits

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems ( such as OPERS, STRS, SERS, and HPRS ) & Optional Deferred Compensation ( Ohio Deferred Compensation )

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level