Senior Application Developer & Data Insights Lead

State of Iowa; Des Moines (IA); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

IPERS

Health insurance

Dental insurance

Vision insurance

Generous vacation & holidays

Life and disability insurance

Retirement savings options (RIC)

Flexible Spending Accounts

Job summary

The State of Iowa, Department of Management – DoIT in Des Moines, IA, seeks an Application Developer to manage and enhance diverse systems, troubleshoot defects, and provide data-driven insights. You will collaborate with business partners and vendors, write SQL queries, and lead junior developers to ensure system reliability.

Remote/hybrid options are available; onsite work in Des Moines is required with Iowa residency.

Qualifications

• Proven ability to support, troubleshoot, and enhance complex systems using strong analytical skills.
• Experience with SQL, data maintenance, and report development to ensure data integrity.
• Strong communication and collaboration skills, including mentoring junior developers.
• Ability to translate data into actionable insights through BI tools.

Responsibilities

• Manage, maintain, and support new and legacy computer systems of moderate to high complexity as a junior or senior developer.
• Analyze, document, and resolve system defects identified by business unit partners or vendors.
• Develop, update, and optimize SQL queries, reports, and data export jobs to support business operations and system continuity.
• Maintain database integrity by creating and executing import jobs and data maintenance scripts using SQL and related development tools.
• Troubleshoot complex system issues by reviewing programming code and identifying alternative technical solutions.
• Plan and perform system testing, including automation testing, to ensure quality and functionality.
• Collaborate with vendor partners to clarify code ownership, recommend improvements, and support remediation of vendor-owned system components.
• Provide mentorship and technical guidance to junior developers, offering day-to-day support, reviewing code, assigning tasks, and serving as a technical lead.
• Support business units through data analysis, transforming raw data into clear, interactive dashboards, charts, and reports using BI and data visualization tools.
• Perform other related duties as assigned to support departmental and organizational goals.

Skills

Analytical skills

Mentoring

Vendor collaboration

Problem solving

Data interpretation

Communication

Tools

SQL

BI visualization

Job description

The State of Iowa, Department of Management – DoIT in Des Moines, IA, seeks an Application Developer to manage and enhance diverse systems, troubleshoot defects, and provide data-driven insights. You will collaborate with business partners and vendors, write SQL queries, and lead junior developers to ensure system reliability.

Remote/hybrid options are available; onsite work in Des Moines is required with Iowa residency.