Data Quality & Reporting Analyst

Oakton College•Des Plaines, IL

1d•Hybrid

About The Position

The Data Quality & Reporting Analyst supports the validation, analysis, and reporting of student-level data required for state, federal, and external reporting in an Illinois community college environment. This role focuses on enrollment, demographics, completion, transfer, and outcomes data and does not include financial reporting responsibilities. Working under the guidance of Institutional Research staff, the Analyst assists with Illinois Community College Board (ICCB) student data reporting, Integrated Postsecondary Education Data System (IPEDS) survey preparation and validation, National Student Clearinghouse (NSC) enrollment and degree reporting validation, and grant-related student data support. The position emphasizes data accuracy, documentation, and developing expertise in complex reporting systems while contributing to institutional accountability, equity initiatives, and student success analysis.

Requirements

Bachelor's degree with no specific discipline required; preference for data analysis and/or statistical coursework.
1-year minimum experience working with data in a higher education, education, or public-sector setting. Experience can include coursework with datasets.
Excellent analytical and problem-solving skills.
Strong attention to detail and interest in learning student data reporting standards.
Ability to work with structured datasets and follow detailed validation procedures.
High proficiency with Microsoft Excel and proficiency with other office tools, i.e. Google Suite.
Effective written and verbal communication skills.

Nice To Haves

Experience in an Illinois community college environment.
Familiarity with ICCB, IPEDS, or National Student Clearinghouse reporting (coursework, internships, or prior roles).
Experience with student information systems or institutional data warehouses.
Basic experience with SQL, Excel, SPSS, or data visualization tools.

Responsibilities

Support the preparation and review of student-level data, student-related surveys, and employment data submitted to ICCB, IPEDS and NSC, including assisting with validation, reconciliation, quality checks, and error resolution for all datasets such as the ID, E1, A1, and A2.
Review enrollment, demographic, credential, and outcome data to ensure alignment with ICCB, IPEDS, and NSC definitions and reporting requirements, among other external definitions.
Document reporting rules, validation steps, and data definitions to support consistency across reporting cycles and submissions; identify data limitations and propose solutions.
Respond to internal or external data questions and requests related to ICCB, IPEDS, and NSC student reporting under the direction of senior staff.
Support student-level data reporting for grants and funded initiatives, including tracking grant participant cohorts, enrollment status, and student outcomes, while ensuring accuracy and alignment with grant requirements, in coordination with grant managers and the college grants office.
Assist with analysis of trends in enrollment (credit and non-credit), completion, transfer, and student outcomes and other metrics that support institutional and strategic priorities, including equity-focused analyses by examining student demographics and emerging variables (e.g., parental status).
Prepare tables, summaries, and basic visualizations for internal reporting and dashboards and help translate technical data concepts into clear summaries for non-technical audiences.
Collaborate with Institutional Research, IT, Student Affairs, Academic Affairs, Financial Aid, and Grants staff to clarify data definitions and resolve discrepancies.
Contribute to process improvement by identifying recurring data quality issues and documentation gaps.
Perform other job-related duties as assigned.