Senior Data Analyst, Perkins Reporting

State of Ohio; Columbus (OH); On-site; USD 80,000 - 95,000; Full time

Job summary

Ohio Department of Higher Education is seeking a Senior Data Analyst, Perkins Reporting, to manage and analyze CTE data. The role focuses on HEI data workflows, reporting, and policy support within ODHE’s Data Management & Analysis division.

Based in Columbus, OH, the position requires strong SQL skills, advanced scripting, and experience presenting findings to diverse audiences.

Qualifications

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

Responsibilities

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

Skills

SQL

Python

R

Data analysis

Presentation skills

Communication

Education

Bachelor's degree

Master's degree (preferred)

Tools

SQL Server

Job description

Agency: Ohio Department of Higher Education

Agency Contact Name and Information: Patricia Guseman; [e-mail]

Work Location: 25 South Front Street
Columbus, Ohio, 43215-4104
United States

County: Franklin

Compensation: $80,000-$95,000

Schedule: Permanent - Full Time

Work Hours: 8am-5pm

Classified Indicator: Unclassified

Union: Exempt from union

Primary Job Skill: Data Analytics

Primary Technology: SQL Server

Who We Are

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.

What You'll Do

Senior Data Analyst, Perkins Reporting - Administrative Staff and unclassified pursuant to §124.11 (A) (30) and §3333.03 of the Revised Code. Serves at the pleasure of the Chancellor and in a fiduciary capacity to the Ohio Department of Higher Education (ODHE). Reports to the Director of Data Management & Analysis. This position will spend 70% of working time focused on Postsecondary Career and Technical Education (CTE) data processes and reporting.

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

Additional Information

• This position reports to the agency headquarters located in downtown Columbus, Ohio five (5) days a week.
• Selected applicants may be asked to complete an exercise to demonstrate ability to complete duties outlined above.

Why Work for the State of Ohio

The State of Ohio is a drug‑free workplace which prohibits the use of marijuana (recreational marijuana/non‑medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug‑Free Workplace Policy (HR‑39), and as outlined in the posting.

Qualifications

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

Preferred Qualifications

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

ADA Statement

Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.

Drug-Free Workplace

The State of Ohio is a drug‑free workplace which prohibits the use of marijuana (recreational marijuana/non‑medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug‑Free Workplace Policy (HR‑39), and as outlined in the posting.