Education Program Consultant

State of Iowa; Des Moines (IA); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Competitive benefits package

Job summary

The Iowa Department of Education seeks an Education Program Consultant (Data and Reporting) to support the Bureau of Community Colleges data team in managing student, staff, and course databases for accountability reporting across Iowa's community colleges.

Responsibilities include data processing leadership, data cleaning, and assisting with federal/state reporting. Strong technical skills in SQL, Excel and visualization tools are required, with travel as needed.

Qualifications

• Graduation from an accredited U.S. four-year college and five years of post-graduate work experience in any one or a combination of areas listed.
• A total of five years of post-graduate education and full-time experience may satisfy the requirement.
• Master's degree plus three academic years of teaching/admin experience may meet the requirement.
• Possession of a School Business Official Authorization and seven years of professional experience may meet the requirement.

Responsibilities

• Provide leadership in data processing and programming to create detailed and summary databases for accountability reporting.
• Acquire data from primary or secondary sources and maintain statewide databases/data systems.
• Assist with maintenance of the statewide MIS database and design data processing support for MIS improvements.
• Edit databases and MIS using programming languages or by working with contractors.
• Filter and clean data to locate and correct problems and automate validation processes.
• Provide data and technical assistance for year-end federal reporting and statewide program data reporting.
• Coordinate high school equivalency diplomas and maintain candidate records.
• Collaborate on statewide initiatives like the VFA national project.

Skills

Google Workspace

Power BI

Tableau

ArcGIS

SQL

Excel

Data analysis

Technical assistance

Education

Bachelor's degree

Master's degree (preferred)

Five years of post-graduate experience

Tools

Visual Basic

Access

SQL Server

Job description

Iowa Department of Education's mission is ensuring all students experience a world-class education. To accomplish our mission, we need talented, passionate people working together to build an excellent education system that empowers all students to achieve their full potential.

Education Program Consultant (Data and Reporting)

The Education Program Consultant (Data and Reporting) provides data support for the Bureau of Community Colleges data team by managing student, staff, and course databases across Iowa's 15 community colleges for state and federal accountability reporting. Key responsibilities include cleaning data, automating validation processes, and providing technical assistance to educational and legislative stakeholders. Additionally, the position manages candidate records for high school equivalency diplomas (HSED).

Your 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 management information system (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.

DESIRABLE 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.

Hours: 8:00 a.m. - 4:30 p.m., Monday - Friday; some nights and weekends, occasional in-state and out-of-state travel

A successful candidate will bring or have the ability and desire to learn:

• Passion for pursuing common goals in pursuit of public service
• Strong technical skills
• Strategic and analytical mindset
• Ability to work in complex situations and meet deadlines while leading teams as a non-traditional leader (no supervisory authority)
• Experience providing technical assistance and professional learning to educators
• Ability to interpret and break down highly technical or regulatory language, and present information in an understandable manner
• Ability to manage self in relation to prioritization and time management
• Conflict resolution and interpersonal skills
• Desire to work with diverse teams and stakeholders

WHAT'S IN IT FOR YOU?

• Opportunities to make a widespread difference in the lives of children, their families, and Iowa communities
• Collaborative, positive work environment
• Talented and passionate work colleagues that will help you learn and grow
• Opportunities to collaborate with experts from around the country
• Employee discounts from a variety of vendors
• Competitive salary and benefits package:

https://das.iowa.gov/sites/default/files/hr/documents/employment/Benefits_Beyond_the_Paycheck.pdf

E-Verify and Right to Work

The State of Iowa participates in E-Verify, a federal program that helps employers confirm the employment eligibility of all newly hired employees. Within the required timeframe, new hires will be verified through the E-Verify system to ensure authorization to work in the United States. The State of Iowa also complies with the federal Right to Work laws, which protect employees' rights to work without being required to join a labor organization. For more information, please visit www.e-verify.gov.

Applicants must meet at least one of the following minimum requirements to qualify for positions in this job classification:

• Graduation from an accredited U.S. four-year college or university and five years of full-time post-graduate work experience in any one or a combination of the following areas:
• a. Professional training, teaching, or counseling experience in an educational setting;
• b. Professional administrative experience in an educational setting;
• c. Professional finance, accounting, or auditing experience, including the preparation or analysis of financial statements;
• d. Professional experience in a major technical program area housed within the Iowa Department of Education;
• e. Professional data integration, data analysis, and statistical analysis experience;
• f. Professional communications experience, including public relations, marketing, or journalism;
• g. Professional school safety and emergency preparedness experience.
• A combination of a total of five years of post-graduate education and full-time experience (as described in number one), where twenty-four semester hours of accredited U.S. post-graduate college or university course work equals one year of full-time experience.
• Graduation from an accredited U.S. college or university with a Master's degree, possession of a valid Iowa Teaching Certificate, and three academic years of teaching and/or administrative experience in PK-12 and/or a post-secondary educational institution.
• Possession of a School Business Official Authorization from the Iowa Board of Educational Examiners and seven years of full-time professional experience in finance, accounting, or auditing, including the preparation or analysis of financial statements.