Education Data & Reporting Specialist

State-of-Iow; Des Moines (IA); On-site; USD 80,000 - 110,000; Full time

Job summary

Iowa Department of Education is seeking an Education Program Consultant (Data and Reporting) to lead data processing, maintain statewide databases, and support federal and state reporting across Iowa’s 15 community colleges.

The role involves technical assistance to educators and stakeholders, working with MIS systems, and coordinating high school equivalency diploma records. Strong SQL, Excel, and analytics skills are required.

Qualifications

• Experience utilizing Google Workspace.
• Experience with Business Analytics tools such as Power BI, Tableau, ArcGIS or similar
• Experience with programming languages such as Visual Basic, Access, SQL, and Excel, or working with contractors to develop such edits and processes. Experience with SQL is particularly desirable.
• Experience providing technical assistance and professional learning to educators.
• Experience preparing compliance data for state, federal or legislative stakeholders.
• Experience interpreting and implementing state or federal education law.

Responsibilities

• Provide leadership in data processing and programming to create detailed and summary databases of students, staff, and credit and non-credit course information received from Iowa's 15 community colleges for state and federal accountability reporting purposes.
• Acquire data from primary or secondary data sources and maintain statewide databases/data systems.
• Assist with the maintenance of the statewide community college MIS database.
• Evaluate and design data processing support for the community college MIS, including developing or locating new process improvement opportunities, including web-based data submission.
• Edit the community college databases and the division's MIS using either programming language such as Visual Basic, Access, SQL, and Excel, or working with contractors to develop such edits and processes.
• Filter and "clean" data by reviewing reports, printouts, and performance indicators to locate and correct code problems.
• Design processes to automate edits into the statewide submission process with immediate feedback of validation issues or data irregularities.
• Provide data and technical assistance to division staff, supervisors, and various education and legislative stakeholders for year-end federal reporting (comprehensive annual report) and statewide program data reporting and analysis.
• Provide technical assistance and data to the division's team responsible for implementing the Voluntary Framework of Accountability national project or any other statewide initiative.
• Other MIS/data team duties as assigned.
• Coordinate the department's efforts with the issuing of high school equivalency diplomas.
• Serve as liaison with the vendor responsible for managing the issuing of high school equivalency diplomas and records.
• Coordinate the database and maintenance of accurate and complete HSED candidate records.
• Support the Department, Division and Bureau priorities through performing other duties as assigned.

Skills

Google Workspace

Power BI

Tableau

ArcGIS

SQL

Excel

Data analysis

Tools

Visual Basic

Access

SQL

Excel

Job description

Iowa Department of Education is seeking an Education Program Consultant (Data and Reporting) to lead data processing, maintain statewide databases, and support federal and state reporting across Iowa’s 15 community colleges.

The role involves technical assistance to educators and stakeholders, working with MIS systems, and coordinating high school equivalency diploma records. Strong SQL, Excel, and analytics skills are required.