Education Program Consultant Des Moines - 50313 - Polk County

Iowa National Guard; Des Moines (IA); On-site; USD 70,000 - 90,000; Full time

Job summary

Iowa Department of Education seeks an Education Program Consultant (Data and Reporting) to lead data processing for student, staff, and course records across Iowa’s 15 community colleges, supporting state and federal accountability reporting. The role also handles HSED candidate records and MIS enhancements.

Responsibilities include data cleaning, automation, and providing technical assistance to educators and stakeholders, with emphasis on data quality and system improvements.

Qualifications

• Experience with managing data for state or federal reporting.
• Experience using Google Workspace and data analytics tools.
• Proficiency with Power BI, Tableau, ArcGIS or similar.
• Programming/editing databases with Visual Basic/Access/SQL/Excel.

Responsibilities

• Provide leadership in data processing to create detailed and summary databases for accountability reporting.
• Acquire data from primary/secondary sources and maintain statewide databases/data systems.
• Assist with statewide MIS database maintenance.
• Evaluate and design data processing support for the MIS and data submissions.
• Edit MIS databases using Visual Basic, Access, SQL, and Excel or coordinate edits with contractors.
• Filter and clean data to locate and correct code problems.
• Design processes to automate edits and provide instant validation feedback.
• Provide data/technical assistance for year-end federal reporting and statewide data analysis.
• Collaborate on statewide initiatives and data sharing with stakeholders.
• Other MIS/data duties as assigned.

Skills

Data processing

Google Workspace

Power BI

Tableau

ArcGIS

SQL

Excel

Tools

Visual Basic

Access

SQL

Excel

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.

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

If you wish to review a copy of the Position Description Questionnaire, please [e-mail].

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:

• 1) 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:
  1. a. Professional training, teaching, or counseling experience in an educational setting;
  2. b. Professional administrative experience in an educational setting;
  3. c. Professional finance, accounting, or auditing experience, including the preparation or analysis of financial statements;
  4. d. Professional experience in a major technical program area housed within the Iowa Department of Education;
  5. e. Professional data integration, data analysis, and statistical analysis experience;
  6. f. Professional communications experience, including public relations, marketing, or journalism;
  7. g. Professional school safety and emergency preparedness experience.
• 2) 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.
• 3) 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.
• 4) 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.

For additional information, please click on this link to view the job description.