Data Analyst 2, Analytics and Program Integration Des Moines - 50319 - Polk County

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

Benefits offered by this job

Paid holidays

Vacation and sick leave

Military leave

Jury duty leave

IPERS retirement benefits

Health and dental insurance

Job summary

The Iowa Department of Education seeks a Data Analyst 2 to join the Analytics and Program Integration team. You will help maintain and improve data systems supporting nutrition programs across Iowa, enabling schools and care providers to operate efficiently and deliver reliable services to children and families statewide.

Responsibilities include data management, reporting, system administration, and project coordination.

Qualifications

• Strong analytical and problem solving abilities.
• Technical aptitude and curiosity for learning new systems and tools.
• Ability to manage multiple priorities and projects simultaneously.
• Strong communication skills, written and verbal.

Responsibilities

• Gather, organize, and analyze information from databases, spreadsheets, and other data sources.
• Develop reports, visualizations, and summaries communicating findings clearly.
• Identify, track, and monitor key performance indicators aligned with bureau goals.
• Support data-driven decision-making through meaningful reporting and analysis.
• Serve as liaison between bureau staff and data system contractors to translate business needs into solutions.
• Manage system service and access requests from end users (schools, childcare providers, stakeholders).
• Coordinate system enhancements and updates; plan and conduct testing; document outcomes.

Skills

Analytical thinking

Problem solving

Microsoft SQL tools

T-SQL queries

Data visualization

Education

Accredited four-year college degree in business analytics or related field

Tools

Microsoft SQL Server

Job description

Note: Applicants must reside in Iowa at the time of hire

Help Strengthen the Systems that Support Iowa Students

At the Iowa Department of Education, our mission is to ensure all students experience a world-class education. Achieving that mission takes more than classrooms and curriculum- it also requires strong systems, reliable data, and people who can turn information into meaningful action.

The Bureau of Nutrition and Health Services is seeking a Data Analyst 2, Analytics and Program Integration to serve as a key member of the Data, Reporting, and Program Support Team. In this role, you will help maintain and improve the systems that support nutrition programs across Iowa. Your work will help ensure that participating schools, child care organizations, and other partners have efficient processes and dependable systems that ultimately support children and families throughout the state.

If you enjoy solving problems, improving processes, managing complex systems, and transforming data into practical insights, this role offers an opportunity to make a meaningful statewide impact.

What You’ll Do

As a member of our team, you will help manage and improve critical data systems and processes that support bureau operations and program delivery.

Data Management & Reporting

• Gather, organize, and analyze information from databases, spreadsheets, and other data sources
• Develop reports, visualizations, and written summaries that communicate findings clearly
• Identify, track, and monitor key performance indicators aligned with bureau and department goals
• Support data-driven decision-making through meaningful reporting and analysis

System Administration & Process Improvement

• Serve as a liaison between bureau staff and data system contractors to translate business needs into effective system solutions
• Manage system service and access requests from end users, including schools, childcare providers, and other stakeholders
• Resolve system issues through data corrections, configuration updates, or process improvements
• Develop recommendations and workflows that improve efficiency and strengthen system performance
• Provide technical recommendations related to system enhancements and future development opportunities

Project Coordination & Quality Assurance

• Coordinate multiple concurrent system enhancements and updates
• Plan and conduct system testing and document outcomes
• Partner with internal teams and end users to ensure enhancements move successfully into production
• Support secure data storage, retention, disposal practices, and data integrity standards

What We’re Looking For

Successful candidates will bring or have the ability and desire to develop, the following:

• Passion for public service and improving outcomes for Iowa students and communities
• Strong analytical and problem-solving abilities
• Technical aptitude and curiosity for learning new systems and tools
• Ability to manage multiple priorities and projects simultaneously
• Strong organizational and time-management skills
• Ability to work both independently and collaboratively
• Strong written and verbal communication skills
• Ability to translate technical information into understandable language for a variety of audiences
• Strong interpersonal and relationship-building skills
• Ability to navigate complex situations and meet deadlines
• Commitment to working effectively with diverse teams and stakeholders

Preferred Qualifications

The ideal candidate may have experience in one or more of the following areas:

• Experience using Microsoft SQL tools within recent platform versions
• Experience writing complex T-SQL queries against SQL Server databases
• Experience managing multiple projects and priorities simultaneously
• Experience working in environments with multiple stakeholders and competing priorities
• Strong attention to detail and ability to apply established procedures with accuracy and efficiency
• Experience with office software applications including spreadsheets and reporting tools
• Experience implementing government regulations or policy requirements
• Experience with USDA Child Nutrition Programs preferred

Schedule

Monday-Friday, 8:00 a.m.-4:30 p.m. Occasional evenings, weekends, and in-state or out-of-state travel may be required.

What’s In It for You?

• Make a meaningful difference in the lives of Iowa students, families, and communities
• Join a collaborative and supportive work environment
• Work alongside passionate colleagues committed to public service
• Opportunities for learning, growth, and professional development
• Collaboration with experts and partners across the country
• Employee discounts through a variety of vendors
• Competitive salary and comprehensive benefits package including:
  • Paid holidays, vacation, sick leave, military leave, and jury duty leave
  • Low-cost, high-quality health and dental insurance options
  • Retirement benefits through IPERS
  • Life insurance and long-term disability coverage
  • Optional supplemental benefits and retirement savings opportunities

For more information, check out Benefits Beyond the Paycheck.

Applicants must reside in the State of Iowa at the time of hire

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) Six years of full-time work experience in business/data/statistical analytics, economic research, or data science.

2) Graduation from an accredited four-year college or university with a degree in business analytics, economics, data science, statistics, mathematics, management information systems, or industrial management, and experience equal to two years of full-time work (as described in number one). An unofficial transcript MUST be attached. Note: Computer Science degrees do NOT meet this qualification

3) All of the following (a and b):

a. A total of four years of education and/or full-time experience in business/data/statistical analytics, economic research, or data science, where thirty semester hours of accredited college or university coursework in business analytics, economics, data science, statistics, mathematics, management information systems, or industrial management equals one year of full-time experience; and

b. A total of two years of graduate-level education and/or full-time experience (as described in part a), where twenty-four semester hours of accredited graduate college or university coursework in business analytics, economics, data science, statistics, mathematics, management information systems, or industrial management equals one year of full-time experience. An unofficial transcript MUST be attached.

4) All of the following (a and b):

a. A total of four years of education and/or full-time experience in business/data/statistical analytics, economic research, or data science, where thirty semester hours of accredited college or university coursework in any field equals one year of full-time experience; and

b. Graduation from an accredited college or university with a Master’s degree in business analytics, economics, data science, statistics, mathematics, management information systems, or industrial management. An unofficial transcript MUST be attached. Note: Computer Science Master’s degrees do NOT meet this qualification

5) All of the following (a, b, and c):

a. Two years of full-time work experience in business/data/statistical analytics, and data science; and

b. A total of four years of education and/or full-time experience (as described in part a), where thirty semester hours of accredited college or university coursework in any field equals one year of full-time experience; and

c. Possession of a professional certificate in data science, business analytics, or data analytics. An unofficial transcript and copy of Certificate MUST be attached.

6) Current, continuous experience in the state executive branch that includes eighteen months of full-time work as a Data Analyst 1.

An unofficial transcript MUST be attached for educational experience to be considered.